Fix Version.by Name based on fix versions of a specific project

Our product version development in Jira is spread across multiple projects. We track the total work across the projects by ensuring each project has the same version number.

There’s [Fix Version.By name] calculated measure I can use to easily get a list of all projects that contain a specific version. I’d like to extend this to be more dynamic to list [Fix Version.by Name] where all names match the fix versions names in project x.

Is there a way to rewrite the aggregate below to do this without having to manually update a list of versions in with “Matches” statements or some other approach I should take?

Aggregate(
Filter([Fix Version.By name].[Name].Members,
[Fix Version.By name].CurrentHierarchyMember.Name MATCHES
‘1.5.*’)
)

Hi @pdaly,
welcome to eazyBI community! :wave:

An easy way to do it is to add Project dimension to Pages and use it to filter your issues by it.

best,
Gerda // support@eazyBI.com

Greetings @gerda.grantina, is there a way to filter versions in time?
thanks

Hi @Mauro_Bennici,
could you please specify what do you mean by filtering versions in time?
We have one demo report that shows Versions on Timeline
https://eazybi.com/accounts/1000/cubes/Issues/reports/50020-versions-on-timeline

As well as this - Versions with release date in period - https://eazybi.com/accounts/1000/cubes/Issues/reports/143703-versions-with-release-date-in-period

Maybe that could be something useful for you?

@gerda.grantina yep they’re something close to what I needed, btw I kept working on it and found some kind of way out.
regards.

1 Like