2 Replies Latest reply: Sep 21, 2012 1:38 PM by Vinay Bangari RSS

    Current Month - Fractile Function

    Helen Pippard

          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