Hi, we use a critiera section at the top of our dashboards to allow the user to restrict the results for example selection a country and all widgets are adjusted to be filtered.
Currently we are using total mode on these critiera widgets as they filter correctly.
Please can the search widget be controlled in the same manner? This will allow our criteria widgets to be smaller on the dashboard and this will reduce query times as it does not need to aggregate the data. Below is an example of where total shows the correct available values (top line, wheras on the bottom line this shows search shows all values:
Ideally we want the search widget to return only the 5 rows where records are available.
This maybe a gap in my knowledge if it is possible please let me know!
Regards,
Jon