1 Reply Latest reply: Oct 1, 2012 2:07 PM by Kevin Bertsch RSS

    Exclude current month from chart

      Hi all.

      I wish to simply exclude the current month from a chart.

      I have a simple line chart showing a ratio of one status versus another but the current months data is skewing the chart.

       

      Here is my expression:

      =Count(If(ReferralAction = 'Denied', ReferralActions.InternalID))

      /

      Count(If(ReferralAction = 'Sent', ReferralActions.InternalID))

       

      Many thanks

      John

        • Re: Exclude current month from chart

          Not knowing what field you have for dates, I'd try two things off the top of my head..

           

          First, if you never want to see the current month, why not set a trigger on the page that sets the "Month" field to all but the current month? Something like "Month < Month(today())"

           

          Second, if you might want to see the current month, why not put a listbox on the page, and again set a trigger as above, but now if the user does want to see the current month, he can simply select it.