How to see fix versions by Project

karl_wm · June 18, 2020, 5:26pm

I’m looking to create a report which shows the number of fix versions by time with Project as a page. I have a user measure for all fix versions but can’t find the collection I need to have the number of fix versions be filtered by the selected project.

Apologies for asking something so basic, is anyone able to help?

janis.plume · June 30, 2020, 10:09am

Hi,
You can add the Fix version at the project level to the report rows and create a custom measure counting the versions under this project. The Count and Descendants function would do that:

Count(
  Descendants([Fix Version].CurrentMember,
       [Fix Version].[Version])
)

Kindly,
Janis, eazyBI support