I have a larger list of data including more than 5000 items. Users create entries and assign them to managers for review. Managers action the items and users re-review. I am using SharePoint 2013 and I don't have SP designer access.
I have a dashboard view that has worked up till the 5000 limit. All the columns I am using to filter are indexed.
The dashboard has 2 views of the list, one for unactioned items and one for actioned items. The unactioned items should display any item created by you, or assigned to you from the last 60 days where the issue status is not "closed". The actioned items list should show the same, except that issues status must equal "closed"
I feel like I have tried every combination of AND/OR I can think of.
Created >= Today-60 and Created by = Me and Issue Status NOT closed or Created >= Today-60 and Assigned to = Me and Issue Status Not closed.
I've also tried
Assigned to = Me or Created by = Me and Issue status not Closed and Created >= Today-60
I've tried a few other combinations too, but I either get zero results, or a 5000 item limit error.
In the interim I have created a 2nd dashboard for managers, but it would be great if I could get the main dashboard working for both user groups.
How do I setup the filter correctly to achieve the above with > 5000 items?