6 Replies Latest reply: Sep 30, 2017 1:51 AM by Antonio Mancini RSS

    Trying to exclude the current month from a line chart

    Brian Bohr

      I have been struggling with trying to exclude the current month from a line chart if I use this it works fine but it is hard coded and I want to do this dynamically so I do not have to update the chart every month.

       

      Sum({$<Date={'<=8/31/2017'}>}AvgSessionDuration*Sessions)/3600

       

      However if I try something along these lines it does not seem to work, I know I am missing something simple

       

      Sum({$<Date={'<=Inmonth(Date,today(),-1)'}>}AvgSessionDuration*Sessions)/3600

       

      Any help would be much appreciated