Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I need to have the min of this set analysis :
(sum({<$(MTD)>} CALLSANSWERED) - sum({<$(MTD)>}CALLSANSWEREDAFTTHRESHOLD))
/
sum({<$(MTD)>}CALLSANSWERED)
Thanks for help
(I used Min like that but it doesn't works :
Min(
(sum({<$(MTD)>} CALLSANSWERED) - sum({<$(MTD)>}CALLSANSWEREDAFTTHRESHOLD))
/
sum({<$(MTD)>}CALLSANSWERED)
)
)
As always this returns single value only, So that is Min only. To get rid work you need
Min(Aggr((sum({<$(MTD)>} CALLSANSWERED) - sum({<$(MTD)>}CALLSANSWEREDAFTTHRESHOLD))
/sum({<$(MTD)>}CALLSANSWERED), Dim1, Dim2))