Expand my Community achievements bar.

Planner: Filter out projects with PLN = 0

Avatar

Level 9

9/19/23

Description - Monthly we run capacity reports based on Planner in attempt to determine if we have enough in-house capacity for Creative job roles. No matter how we filter, we still see projects listed even if a job role isn't associated with the project.

Why is this feature important to you - Without the ability to filter out these projects that aren't relevant to the job role, we run into the row limit outrageously fast. Ultimately we're stuck with exporting over a dozen permutations of our filters each time we want to run our capacity planning protocol. I confirmed with Support that there is no good filter to ignore rows of 0s.

How would you like the feature to work - Offer a toggle switch to include/exclude rows of 0 data.

Current Behaviour - After exporting data to Excel, we have to manually exclude rows of 0 planned hours.

3 Comments

Avatar

Level 3

9/21/23

This has always been a pet peeve of mine with planner (for years!). I used to pull reports, export to excel and then manually remove the 0 PLN projects. Very frustrating to have to do this instead of being able to actually filter these out.