SharePoint grouped view item count

%3CLINGO-SUB%20id%3D%22lingo-sub-1383180%22%20slang%3D%22en-US%22%3ESharePoint%20grouped%20view%20item%20count%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1383180%22%20slang%3D%22en-US%22%3E%3CP%3EI%20have%20SharePoint%20online%20list%20with%20about%206500%20items.%20One%20column%20is%20an%20indexed%20choice%20column%20with%20about%20six%20choices.%20If%20I%20create%20a%20modern%20grouped%20view%2C%20grouped%20on%20this%20choice%20column%2C%20the%20item%20count%20for%20each%20group%20shows%20the%20number%20in%20that%20group%2C%20%3CEM%3Ebut%20only%20up%20to%20the%20item%20limit%20set%20in%20the%20view%20properties%3C%2FEM%3E.%20If%20I%20increase%20the%20item%20limit%20up%20to%204999%2C%20then%20the%20grouped%20view's%20item%20count%20increases%20%3CEM%3Eup%20to%20this%20limit%3C%2FEM%3E%20(still%20doesn't%20show%20all%20because%20there%20are%206500%20total%20items)%20and%20the%20view%20then%20takes%20an%20%3CEM%3E%3CSTRONG%3Eextremely%3C%2FSTRONG%3E%3C%2FEM%3E%20long%20time%20to%20load%20(unusable).%20Increasing%20the%20item%20limit%20to%20from%204999%20to%205001%20causes%20the%20%22something%20went%20wrong%22%20error%2C%20presumably%20because%20the%20list%20view%20threshold%20was%20exceeded%20even%20though%20the%20columns%20involved%20in%20the%20view%20are%20indexed.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESo%20my%20question%20is%2C%20how%20can%20a%20grouped%20view%20be%20provisioned%20on%20a%20large%20list%20so%20that%20the%20item%20count%20makes%20some%20kind%20of%20sense%20(i.e.%20like%20not%20showing%20it%20all%20in%20this%20case)%3F%20Showing%20a%20list%20with%206500%20items%2C%20grouped%20by%20six%20categories%20that%20each%20show%20an%20item%20count%20that%20totals%2036%20is%20quite%20misleading%20to%20everyone%20who%20looks%20at%20it.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Grouped%20View%20on%20Large%20List.png%22%20style%3D%22width%3A%20520px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Fgxcuf89792.i.lithium.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F190989i2085A02BD143F54E%2Fimage-size%2Flarge%3Fv%3D1.0%26amp%3Bpx%3D999%22%20title%3D%22Grouped%20View%20on%20Large%20List.png%22%20alt%3D%22Grouped%20View%20on%20Large%20List.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1383180%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ESharePoint%20Online%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Highlighted
New Contributor

I have SharePoint online list with about 6500 items. One column is an indexed choice column with about six choices. If I create a modern grouped view, grouped on this choice column, the item count for each group shows the number in that group, but only up to the item limit set in the view properties. If I increase the item limit up to 4999, then the grouped view's item count increases up to this limit (still doesn't show all because there are 6500 total items) and the view then takes an extremely long time to load (unusable). Increasing the item limit to from 4999 to 5001 causes the "something went wrong" error, presumably because the list view threshold was exceeded even though the columns involved in the view are indexed.

 

So my question is, how can a grouped view be provisioned on a large list so that the item count makes some kind of sense (i.e. like not showing it all in this case)? Showing a list with 6500 items, grouped by six categories that each show an item count that totals 36 is quite misleading to everyone who looks at it. 

 

Grouped View on Large List.png

0 Replies