Hi, I build a dashboard with dashboard parameters, it works pretty easy!
The advantage of dashboard parameters is that you do not have to set a default (it can be: all). This is convenient when you need to filter on values that change every time the query is run. However, my query-output can be long. The table has a warning that only xx rows are displayed.
It seems that values that certainly exist in the query output, show 'no data' when trying to select them in the parameter box. I suspect that only the 'displayed rows' deliver the values for the parameter. Is this correct?
I can think of two ways to avoid:
* reduce the number of selected rows. This requires prior knowledge, which I not always have
* use a query parameter instead of a dashboard parameter, but this one needs an explicit default value.
Does anyone have a hint on this one?