Dashboard SQL size limit

[jeanettemcmahon]

Is there a limit on the dashboard SQL? I have a user building a dashboard utilizing the individual filter. His list is extremely long. Is there a character limit? If so, what is that limit. 

[JoeM]

@jeanettemcmahon 

Are you looking to see how many distinct values the filter can display? 

Or how are you looking for the max length of individual values in the filter options?

[jeanettemcmahon]

@JoeM 

Yes, is there a limit to the distinct values a filter can display? Thanks

[JoeM · Accepted solution]

There is a default limit of 1000 values for a list of values in the prompts. Technically, you could add more using the bulk filter, however, adding more could cause some performance issues.