Percentage of (sub)total

Questions & Answers
, ,
1

Hi!

It’s me again…

I want to do an analysis on which status are really used in my Jira projects. I am using measure “Transition to status issues count” which works perfect.

What I now want is to add a percentage per project (like having a subtotal of issues), but when I add the “% of total” it is calculated by all rows selected. Is it possible to add a filter on the projected of the row?

See the red marks in this screenshot:

image
image1010×541 36 KB

2

Thanks to this post I was able to find a solution to my topic.

This is the measure I am using now:

[Measures].[Transitions to status issues count]
/
DefaultContext(
([Measures].[Transitions to status],
[Time].CurrentHierarchyMember,
[Project].CurrentHierarchyMember,
[Issue Type].CurrentHierarchyMember)
)