Grafana Cloud v9.1.6-10b38e80 (46a8c21981)
I am trying to display counts in certain time bins of boolean data from a AWS Timestream table.
My current query looks like this:
SELECT CREATE_TIME_SERIES(time, measure_value::boolean) AS ts FROM $__database.$__table group by bin($__database.$__table.time, 1m)
I do not get counts, just a “true” line:
I want the y axis to display the number of true values in that bin in a timeseries chart.