Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hello,
I have the following expression in a straight table and the expression is O.K
Fractile
({<[Reportable Month]={$(=monthstart(today()))
} >}
[Total Wait]
,0.95)/1440
I also have in my label for this expression:
=
monthstart(today
())
However when I apply this expression, I return no data
I am trying to estbalish the current months 95th centile and display the value in a table.
Could anyone advise whether such a expression can be used in a gauge graph?
Kind Regards
Helen
Dear Helen,
In my oppinion you need to aggrigate this exprression over the Month.
Try Like:
Fractile (aggr(Sum({<[Reportable Month]={$(=monthstart(today())} >}[Total Wait]),[Reportable Month]),0.95)/1440
Regards
Rahul
Hi Helen can you post a sample application with some sample data so that we can help with.