Our releases(fix versions) are worked on by multiple teams across multiple Jira projects. I’m trying to create a high level dashboard that shows overall fix version status across all the teams (Jira projects). Similar to the Jira releases page that works at the individual project level.
I can use the [Fix Version by name] to get the following
As you can see in your screenshot, the same fix version can have a different start date and release date in different projects.
Therefore, there should be a question of what is the correct result on the version level in such report (which project to pick from).
Assuming you would like to cover all the issues from all projects on the Fix version level (in your report) you could try the following code (earliest version start date)
CASE WHEN
[Fix Version].CurrentHierarchyMember.Hierarchy.name = "Fix Version.By name"
AND
[Fix Version].CurrentHierarchyMember.Level.name = "Name"
THEN
TimestampToDate(
Min(
Filter(
Childrenset([Fix Version.By name].CurrentHierarchyMember),
[Measures].[Issues created]>0
),
DateToTimestamp([Measures].[Version start date])
))
WHEN
[Fix Version].CurrentHierarchyMember.Hierarchy.name = "Fix Version.By name"
AND [Fix Version].CurrentHierarchyMember.Level.name = "Project"
THEN
DateParse([Measures].[Version start date])
END
It would return the earliest version start date. You can use this new calculated measure instead of “Version start date” in your report.
And then similarly you could use Max function in that formula to return the last date from Version release date
