7 Replies Latest reply: Dec 14, 2016 11:06 PM by DIVYA ANAND RSS

    Help - writing expression for a monthly chart using date field

    DIVYA ANAND

      Hi all,

       

      Any suggestions on writing the expression for the below case that I would like to see on a Monthly bar chart (Month is the dimension)

      ScheduledDate<=MonthEnd of every month

      Jan: count of all tickets where scheduledDate <=Jan (including jan 2016,dec 2015, nov 2015 & so on)

      Feb: count of all tickets where scheduledDate <=Feb (including feb 2016, jan 2016,dec 2015, nov 2015 & so on)

      Mar: count of all tickets where scheduledDate <=Mar etc

       

      Thank you in advance.