If the result of the query has a column with a value of 0 and if the counter visualization is mapped to that column, then the counter does not show the value as 0.

Query: https://dune.com/queries/2027599