Ability to Order the Transition status in a report

Questions & Answers
1

Have a report that shows Average Days in Status and want to order how the status are presented in the report

EazyBI1
EazyBI1.png1593Ă—675 35.9 KB

I have tried

Aggregate({
[Transition Status].[Transition Status].Members,
[Transition Status].[Done],
[Transition Status].[Cancelled]
})

but only get a total not a list of the status

EazyBI2
EazyBI2.png1653Ă—320 11.9 KB

2

Hi @briantaylor,

You are on the right track. To order transition statuses, you can define a new calculated member using function Aggregate().
Your formula has a redundant line, which should be removed:

[Transition Status].[Transition Status].Members

For more details, see this topic and short instruction video How to change order of columns and rows in the report?

Best,
Zane / support@eazyBI.com

3

Zane

I have the following

Aggregate({
[Transition Status].[Done],
[Transition Status].[Cancelled]
})

but still only get a single line not a list of just the aggregated issues

EazyBI%2014
EazyBI 14.png1829Ă—632 55.5 KB

4

@briantaylor you see only one bar chart because you have not expanded the aggregated member “Transition Status Order” to see transition statues it is composed.

  1. Switch to the Table view
  2. Expand “Transition Status Order”
  3. Remove “Transition Status Order”
  4. Switch back to the Bar view.

On topic How to change order of columns and rows in the report? is a short GIF showing how to do this.

1 Like