Is there a limit on the Pivot visualization?

[maggieo]

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?

[Abhay Kumar1]

@maggieo As per servicenow documentation:

Max number of groups:

Maximum number of groups that the Group by condition returns. The groups with highest values are shown first. Any groups beyond the limit are combined into the single group Other.

If you select Show all, all groups up to a limit of 50 are displayed. The rest of the results are grouped as Other.

Show Other Check box to include the Other group in the report. The Other group contains data for all groups that exceed the number specified in Max number of groups.

ServiceNow documentation: https://docs.servicenow.com/bundle/utah-now-intelligence/page/use/reporting/concept/c_MultilevelPivo...

Hope this will help you.

[jeffrubinoff]

That's a Core UI multilevel pivot report doc. Maggieo is specifically asking about Next Experience Data Visualizations. 
I can't find a limit mentioned in the doc I wrote. I will ask the visualizations team. However, since our goal in general is feature parity, I would not be surprised at all if there is the same limit as in Core UI. (We are expressly not allowed to say "classic!") 

[maggieo]

I understand this behavior in the classic reporting, the question is in the Platform analytics. Even if I select show all, it doesn't go beyond the 50 rows.

[jeffrubinoff · Accepted solution]

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.