topic Re: Dashboard SQL size limit in Dashboards & Analytics Discussions

Dashboard SQL size limit

jeanettemcmahon — Wed, 18 May 2022 17:13:39 GMT

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.

Re: Dashboard SQL size limit

JoeM — Wed, 18 May 2022 17:58:26 GMT

@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?

Re: Dashboard SQL size limit

jeanettemcmahon — Wed, 18 May 2022 18:29:04 GMT

@JoeM

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

Re: Dashboard SQL size limit

JoeM — Wed, 18 May 2022 21:51:12 GMT

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.