Expand my Community achievements bar.

Filter stacking on reports akin to resourcing tools

Avatar

Level 10

3/18/22

Filter stacking

Allow the usage of more than one filter on a report just like you can do in the Workload Balancer.


Instead of having 18 filters like:

Assignment: Team A, Project Status: Active, Task Status: Active,

Assignment: Team A, Project Status: Active, Task Status: Complete,

Assignment: Team A, Project Status: Complete Task Status: Complete

Assignment: Team B, Project Status: Active, Task Status: Active

Assignment: Team B, Project Status: Active, Task Status: Complete

Assignment: Team B, Project Status: Complete Task Status: Complete

Assignment: Team C, Project Status: Active, Task Status: Active,

Assignment: Team C, Project Status: Active, Task Status: Complete

Assignment: Team C Project Status: Complete Task Status: Complete

Assignment: Team A and Team B, Project Status: Active, Task Status: Active,

Assignment: Team A and Team B, Project Status: Active, Task Status: Complete,

Assignment: Team A and Team B, Project Status: Complete Task Status: Complete

Assignment: Team A and Team C, Project Status: Active, Task Status: Active,

Assignment: Team A and Team C, Project Status: Active, Task Status: Complete,

Assignment: Team A and Team C, Project Status: Complete Task Status: Complete

Assignment: Team B and Team C, Project Status: Active, Task Status: Active,

Assignment: Team B and Team C, Project Status: Active, Task Status: Complete,

Assignment: Team B and Team C, Project Status: Complete Task Status: Complete


You can have 7 filters and mix and match:

Assignment: Team A

Assignment: Team B

Assignment: Team C

Project Status: Complete

Project Status Active

Task Status: Active

Task Status: Complete


In this simple example I cut 18 filters to 7. When you filter for more than 3 things and with more choices it compunds exponentially.

2 Comments