Filter needs reset to show all values

Q&A
, , ,
1

I have a multi-select drop-down filter in a dashboard. The drop-down wasn’t showing all values from the dataset until the filter was reset manually, and then the missing values were there and selectable. There are less than 10 distinct values for this filter. Is there a way to get the filter to automatically reset/refresh so all values are always displayed?

2

Hello @ngonser, welcome to the Quick Sight Community!

I have a few questions about this. Are the values returned by the filter changing or do they remain the same? Also, is the dataset that is connected to those values stored in SPICE and refreshed on a timer or is it on direct query?

If they are changing, and you don’t require many fields for your controls, it may be worth creating a dataset just for your filter values that is set to direct query. That way they will auto-refresh every 24 hours. Here is an Amazon document that explains this feature.

3

Hi @DylanM!

It’s a direct query. The values don’t change often, but we do occasionally get a new value. I think what might be happening is a new value came in since the last time the user viewed the dashboard. I was hoping there was a way for them to show up automatically in the filter without having to reset or refresh it. A couple users noticed the missing value that had logged in previously. When a user who had never logged in before viewed the dashboard for the first time, the values were all there without having to refresh.
ETA: looking into the link you posted, I think that’s probably the answer.

1 Like
4

Hello @ngonser, it definitely sounds like an issue related to caching the values from the last time the user visited the dashboard. From what I am seeing on this article though, that should automatically update every 24 hours as long as it remains on direct query.

I know that isn’t a perfect solution for the problem you are facing, but do you have any other questions about this process?

5

@DylanM I think that covers it. I’ll do some more investigating next time to see if the values came in since the last filter refresh. Thank you!