Difficulty loading filters

[christg]

Hello all,
I have this problem with filters on AGOL: after updating data on my dashboard, the filters no longer load. 
Each filter must display a maximum of 20 elements.
I'd like to point out that my database has more than 300,000 rows. 
What can cause it?
How can I ensure that after loading the data, the filters load quickly?

[JakeSkinner]

Hi @christg ,

Manually define the values for you filters using Defined values:

This way the application is not querying the 300,000 rows to retrieve the 20 values.

[christg · Accepted solution]

thank you.