I would like to add the highest priority of an issue as a dimension.
Currently we use the priority dimension but this skews our reports as it common to reduce the priority during the issue life-cycle after a certain status. We would like to have the same functionality like the All Priorities dimension but instead of the current priority we would like it to return the highest priority.
Is this possible? Any help is appreciated.
Hi @AlexD ,
You could try creating new calculated member “Highest” in “Priority” dimension using this formula.
you can use the link - Calculated measures and members
Or share the snip what you are trying to do. so that we can see and help you
Hi @AlexD ,
One option is to create a measure with hardcoded rank values depending on your priority name.
See the comments in the formula below:
NonZero( Count( Filter(Descendants([Issue].CurrentMember,[Issue].[Issue]), --filter issues and ignore the current issue priority ([Measures].[Issues created], [Priority].DefaultMember)>0 AND -- order issue priorities by the hardcoded rank Order( Filter([Priority].[Priority].Members, ([Measures].[Transitions to], [Transition Field].[Priority])>0 ), --hardcoded rank CASE [Priority].CurrentMember.Name WHEN "Highest" THEN 1 WHEN "High" THEN 2 WHEN "Medium" THEN 3 WHEN "Low" THEN 4 WHEN "Lowest" THEN 5 END, ASC --filter the report by the highest priority that matches the priority selection in pages ).Item(0).Name=[Priority].CurrentMember.Name ) ) )
In the report, this would look like this. In Pages, I am filtering the priority “Highest,” and the measure returns me issues that currently have other priorities but in history have had the “Highest” value:
Gerda // firstname.lastname@example.org