I want to get a report, by release of tickets that have some specific transitions.
So I have the rows set with the fix version and columns I have transition status and measures selected, within measures selecting "issue history"
What I want to do though is filter so that I only see tickets with the transitions;
software test -> fixing
software test -> queued
i.e. this would then show me all tickets in a release that at some point failed software test
Hi Tom,
In this case, you could create a new calculated member in "Transition" dimension using this code:
[Transition].[Software => Fixing]+ [Transition].[Software => Queued]
And then you could use this new calculated member in the tuple when creating a new calculated measure in "Measures" dimension
( [Measures].[Issues history], [Transition].[<new calculated member from 'Transition' dimension>] )
stacked bar chart - report.jpg
Please contact support@eazybi.com if you have further questions regarding this!
Kind regards,
Martins Vanags / support@eazybi.com
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.