Is it possible to use an embedded dashboard filter to select for rows that have a specific column value greater than 0? Or any comparison?
I have a dashboard that displays one table. The table has a column named quantity. I would like to filter by quantity for all rows. Namely, any row that has a quantity greater than 0. The quantity values are widely varied. I would like to the pass the data as a locked parameter. I don’t see mention of this type of filtering in the Dashboard Filters docs or the Embedding docs. I do see that ‘greater than’, ‘less than’, ‘is’, ‘is not’ are options in the query builder. Does this functionality exist for dashboards? If not, any suggestions for workarounds?
Thanks!