alert metric name problem

[myshzzx]

my sql looks like select time, metric, count() from xx group by time,metric

and show like

then I add an alert , and get notice like this

[Slach]

duplicated with previous issue try follow suggestion here https://github.com/Altinity/clickhouse-grafana/issues/498#issuecomment-1829409212

[Slach]

try to following query

SELECT
    t,
    groupArray((metric, cnt)) AS groupArr
FROM (
  select time AS t, metric, count() cnt from xx group by t,metric
)
GROUP BY t
ORDER BY t