enhance list view filtering options to collectively filter then produce results
Enhance list view filtering options to allow multiple filtering options to be collectively run THEN count the view total.
It is evident that the first filtering used on a view, such as a date range, must filter results under 5,000 versus the collective filters returning a count of under 5,000. An example of what I mean by “collective filters” is setting a view to filter on data range + location + other criteria, etc. While our SharePoint 2007 environment was able to do this, SharePoint Online appears to be much more limited with its collective filtering abilities. In other words, SharePoint Online does not run all the filters THEN output the view. It steps through the filters one by one, and therefore the first filter must make output less than 5,000 items.
The filters should filter collectively thereby allowing a data set larger than 5000 items to essentially be queried and then more fine tuned with the collective set of filters bringing the total results down to 5000.