I have a problem with one of my reports. What I want to do is to count Fix versions by month, but with a slight catch. We have multiple releases that have the same release number as a part of their name, like this:
- AN 5.1.1 New links
- AN 5.1.1 Bugfixes
- AN 5.1.1 New feed
When we create our report, those Fix versions are counted separately - which is expected, but we would like to count all that have the same number as a single release.
What we tried is to create a custom calculated measure:
Descendants([Fix Version].CurrentMember, [Fix Version].[Version]),
[Measures].[Version release date],
[Fix Version].CurrentMember.Get(“Status”) <> “Unreleased”
[Fix Version].CurrentMember.Name MATCHES “AN .*”
([Measures].[Issues created], [Time].CurrentHierarchy.DefaultMember) > 0
ExtractString([Fix Version].CurrentMember.Name, ‘\s+([^\s]+)’, 1),
, WHAT TO PUT HERE???)
The idea is that we can get all Fix versions in a period, extract the version part of the string from the Fix version name, put that back as a set, remove duplicates and count remaining members.
But we can’t get StrToSet to work and we can’t find any docs around this - any help or better suggestion on how we could achieve this?