I’m building a table of metrics using count as the aggregation and want to filter out results where the count is 0. So far I haven’t seen anything in the documentation that points to that. Is this a thing that is possible?
Unfortunately no, there is no direct way to do this today.
Is there not even a way to query out zero values in the DQL? I figured at least that would be possible
DQL is the query language used to query the underlying documents. It does have a way to filter documents based on various parameters. The table visualization however uses the aggregation API. This api aggregates the document information and displays it on the table. This does not have an option to filter results at the moment. At least not in a way that i’m familiar with.