How to get a count of boolean data in a timeseries

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.