Expand my Community achievements bar.

Latest Community Ideas Review is Out: Discover What’s New and What to Expect!

How to refine a milestone report?

Avatar

Level 10

I have a milestone report which is on the Project level, a basic report, and I'd like to refine it to include only milestone tasks that are less than 100% complete. I can't find a way to do that, as completion date for tasks is not an available option from a project report - which is weird since it is one level down I thought it would be.

Topics

Topics help categorize Community content and increase your ability to discover relevant content.

1 Reply

Avatar

Community Advisor

I think you're thinking "one level up". So things that are one level up from the object you're reporting on, is no problem. Think of it in this way: usually the thing that is one level up from your thing is a unique thing. Your project can only have one portfolio and one program, so it's pretty easy to report such things.

Your project can have many tasks and many files, so it's going to be a bit harder to filter these "things that are one level down". Things one level down may require either a collections filter or expression, or an exists filter, depending on what you're trying for.