Count the number of True items in a table column

Use a Query with JSON on the table data
select count(*) from {{yourtable.data}} where yourcolumnnamefromdata = true

2 Likes