Created v/s any other status

Questions & Answers
1

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]

image
image.png1378×523 57.7 KB

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

Thanks

2

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:

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

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

Issues_-Customer_reps-_eazyBI
Issues_-_Customer_reps_-_eazyBI.png3320×1182 252 KB

Lauma / support@eazybi.com