SELECT user_leads.id,
first_name AS 'Nombres',
last_name AS 'Apellidos',
ip AS 'IP o número de telefono',
city AS 'Ciudad',
state AS 'Estado',
From_unixtime(user_leads.timestamp) AS 'Fecha',
Count(wadmin.id) AS 'Total Grupos de Whatsapp (Admin)',
Coalesce(Group_concat(wadmin.name), '') AS 'Grupos de Whatsapp (Admin)',
lead_sources.name AS 'Fuente',
lead_statuses.name AS 'Status',
dw.session_id
FROM user_leads
LEFT JOIN dialogflow_sessions AS dw
ON dw.lead_id = user_leads.id
LEFT JOIN user_lead_global_fields AS gf_ans
ON gf_ans.leadid = user_leads.id
LEFT JOIN lead_sources
ON lead_sources.id = sourceid
LEFT JOIN lead_statuses
ON lead_statuses.id = user_leads.statusid
LEFT JOIN whatsapp_groups AS wadmin
ON wadmin.admin_lead_id = user_leads.id
GROUP BY user_leads.id
ORDER BY user_leads.id DESC
Im currently using that query, here is what I tried
Has anyone faced this issue?
Found it. Data Studio doesn't like spaces in column aliases, yet it won't show any error for them. The working is the same with all spaces in aliases replaced by underscore