Your achievements

Level 1

0% to

Level 2

Tip /
Sign in

Sign in to Community

to gain points, level up, and earn exciting badges like the new
Bedrock Mission!

Learn more

View all

Sign in to view all badges

Filter stacking on reports akin to resourcing tools

Avatar

Level 10

18-03-2022

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