0 Replies Latest reply: Jul 11, 2017 4:46 AM by Deepanshu Chamoli RSS

    13 month

    Deepanshu Chamoli

      Hello All


      Please help me in the below query. I have the data from Feb'12 to till date.


      I need to create a bar graph which picks only last 13 month data.


      I have created a variable as


      Rolling13 = DATE(MONTHSTART(TODAY(),-13), 'YYYY-MM-DD')


      Can some one please guide me how to use it in the below formula


      COUNT(CASES) with dimension as  Open Month


      Please guide