Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
My current dimension is:
=Dual(If(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), '>120'),
If(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID) <= 120, Class(Aggr(Sum({<Flag_CurrentStep={1}>}WORKFLOW_DURATION), REQUEST_ID), 60), 120))
and it gives me these labels:
My customer wants the labels to display (and then sort the same way) more simply:
<60
60-120
>120
I've been playing with the Dual Replace function in the dimension but can't get it to work correctly.
Thanks.
I was so close yet so far.