5 Replies Latest reply: Nov 13, 2015 1:33 PM by Mayank Raoka RSS

    How to add another condition in month() ?

    Jim Chan

      Hello all!

       

      here's my another question.

       

      how to add another condition in month() for example scenario as below:

       

      close_dateticket_status

      12/2/2015

      open
      14/2/2015closed
      3/3/2015closed
      8/3/2015work in progress

       

      i want to use month(close_date),[close_date] = 'closed' . but my expression is not working? i only want to my barchart to display with months that have tickets have been CLOSED.

       

      Please help!