How to count releases for a project

nauris.malitis · August 7, 2024, 2:11pm

Got it!

You can define a new measure “Unreleased versions” with a formula like this:

Count(
  Filter(
    Descendants([Fix Version].CurrentMember,[Fix Version].[Version]),
    [Fix Version].CurrentHierarchyMember.Parent.Name = "Unreleased"
    AND
    [Measures].[Issues created]>0
  )
)

Then you’ll have a report like this that counts the total number of versions and the unreleased ones:

Next, switch to the Gauge chart and apply a gauge limit to the Unreleased versions measure:

And you should see a report like this that shows how many unreleased versions from all versions there are per each project:

Best regards,
Nauris