Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I am trying to build a bar chart counting the number of orders at each stage in the process, these stages are numerical.
My problem is that each order can have multiple stages within it, and I want to report on the earliest (smallest number) of those stages.
For example, I want to be able to have the minimum task stage as depicted below as a dimension in a bar chart.
Order Reference | Stage | Minimum Task Stage |
ABCD | 3 | 2 |
ABCD | 2 | 2 |
ABCD | 6 | 2 |
EFGH | 1 | 1 |
EFGH | 9 | 1 |
EFGH | 4 | 1 |
I've tried using min(total<[Order Reference]>[Stage])
But that displays an Invalid Dimension error.
is there a solution to this?
Thank you
Hi,
In your chart, try as calculated dimension
aggr(min(TOTAL <Order> Minimum_Task_Stage),Order,Stage)
May be you need this
Aggr(Min(Stage), [Order Reference])
Thank you for this - I don't get an error anymore, but it is returning all values as null.
Hi,
In your chart, try as calculated dimension
aggr(min(TOTAL <Order> Minimum_Task_Stage),Order,Stage)
What all dimensions do you have in your chart? Do you have any expressions?
thank you both so much for your help.
The expression which worked was:
aggr(min(TOTAL <[Order Reference]> [Stage]),[Order Reference],[Stage])