Current Month - Fractile Function

[helen_pip]

    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

[#2]

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

[Anonymous]

Hi Helen can you post a sample application with some sample data so that we can help with.