eazyBI specific transition by release

[CBNL]

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

[eazyBI Support]

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