Is there a limit on the Pivot visualization?

maggieo · ‎11-07-2024

I have more than 50 users that I want to report on the number of cases that they have handled.

When I create a pivot visualization, even after selecting to show all, I only see 50 users.

Is this a default setting? how can it be overwritten?

jeffrubinoff · ‎11-11-2024

Confirmed with development, Data Visualizations have the same 50-group limit for table data as Reports have. You can increase this limit with the system property par_viz.table_data_max_groups, which is in the sys_properties table as documented in https://www.servicenow.com/docs/bundle/xanadu-platform-administration/page/administer/reference-page.... Admin role required.

View solution in original post

J A Lindsay · 4 weeks ago

I tried adding this system property in Yokohama and setting it to 100, but it made no difference to the pivot table visualization I was working on. Tried setting it to 10 and it didn't update it either. Tried clearing cache and impersonating other users, no dice.

jeffrubinoff · 4 weeks ago

I am sorry, I got the property name wrong, it's par_viz.table_data.max_groups. It is available OOTB.