And in the dashboard displaying the count twice with different values for status ?
Ideally I don't want to have a "public" filter in the dashboard. I want to set the status field on the count display.
In reality my query is more complexe and I would avoid to have the same sql query in multiple question for maintenance.
Then how can I choose to display Red or Green in a dashboard widget ? My guess is that the result in table format will impact the available display widget for the query
My goal is to have a query with parameters and specify a parameter for widget A and another params for widget B. And I have only one query to maintains.
i.e. instead of using a dashboard filter to input parameters into a query, just put a parameter "harcoded" into the widget config