I would like to extract only Hotfix versions and show data by Month, Fix Version description and count.
I got the filter working by adding Fix Version with this query in the Fix version page.
)
)
However I could not read only Hotfix Releases from the list with count. Please help. Thank you.
What results are you retrieving?
It seems that regex returns everything that contains Hot within the name
What you can try is to use this regex:
[Fix Version].CurrentHierarchyMember.Name MATCHES '^Hot.*'
Here is the output I am looking for but with only Hotfix versions.
This is the code I am using in User defined field called Version Report:
Generate(Filter(
[Fix Version].[Version].Members,
IIF (
DateInPeriod(
[Fix Version].CurrentMember.get(‘Release date’),
[Time].CurrentHierarchyMember
) ,
([Time].CurrentHierarchy.DefaultMember,
[Measures].[Issues created]) ,0) > 0),
– show version name
[Fix Version].CurrentMember.Name,
', ’
)
I need Month and Hotfix version released in that month and count
With that formula, you can filter the name like:
NonZero(Count(
Filter(
Descendants([Fix Version].CurrentMember, [Fix Version].[Version]),
DateInPeriod(
[Measures].[Version release date],
[Time].CurrentHierarchyMember)
AND
[Fix Version].CurrentMember.Get("Status") <> "Unreleased"
AND
[Fix Version].CurrentMember.Name MATCHES ".*Hot.*"
AND
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember) > 0
)))
Or if you want to generate only the name as a list:
Generate(
Filter(
Descendants([Fix Version].CurrentMember, [Fix Version].[Version]),
DateInPeriod(
[Measures].[Version release date],
[Time].CurrentHierarchyMember)
AND
[Fix Version].CurrentMember.Get("Status") = "Released"
AND
[Fix Version].CurrentMember.Name MATCHES '.*Hot.*'
AND
([Measures].[Issues created],
[Time].CurrentHierarchy.DefaultMember) > 0
), [Fix Version].CurrentMember.Name, ',')
As an example, you can see the amount of releases we did per month and how to show the filtered releases as a number or as a String (in my case we don’t use “Hot”, checked with “Api”)
