Created v/s any other status

So I want to create a line graph to see stack bars of created issues versus escalated (or any other status).
Right now im using

[Measures].[Transitions to status],
[Transition Status].[Squad Pending]

I tried to find in community but couldn’t find the right formula.


Hi Miguel,

Yes, Issues created shows only for All transition statuses level while Transitions to status measure displays how many issues transitioned to selected statuses as well as All level.

To put this together in one chart you can create a calculated measure that shows the Transitions to status issue count only in case the Default transition status All level is not showing:

NOT [Transition Status].CurrentHierarchyMember IS [Transition Status].CurrentHierarchy.DefaultMember
  [Measures].[Transitions to status issues count]

Then you can select individual statuses from Transition status dimension to show in stacked bar and Issues created for All transition status level, see example

Lauma /