Hello all I am trying to build a Dashboard using graph panel. For which I am trying using the following Query
This is working perfectly fine
SELECT
$__timeGroup(“created_date”, $period, 0) ,
count(col2_name) as col2_count,
count(col2_name) as col3_count,
count(col3_name) as col3_count
FROM table_name
WHERE
($__timeFilter(“created_date”) and (col1_name in ($col1)) and (col2_name in ($col2)) and (col3_name in ($col3)))
GROUP BY time
ORDER BY time
Now I need to group by the values using multiple columns so I am Selecting and group ing them
SELECT
$__timeGroup(“created_date”, $period, 0) ,
count(col2_name) as col2_count,
count(col2_name) as col3_count,
count(col3_name) as col3_count, col4, col5
FROM table_name
WHERE
($__timeFilter(“created_date”) and (col1_name in ($col1)) and (col2_name in ($col2)) and (col3_name in ($col3)))
GROUP BY time , col4, col5
ORDER BY time
grafana is throwing an error. p1: syntax error at “,”.
Please help me in understanding if we can group by values[categorical variable] for a graph panel.