6 Replies Latest reply: Dec 19, 2017 11:27 AM by Sunny Talwar RSS

    Making chart dimensions using calendar variable

    DANIEL ARAUJO

      Dear Colleagues,

       

      Id like to create a chart which dimensions are based on a calendar variable. The dimensions should show the IDs that happened from the chosen date, 30 days before the chosen date and so on..

       

      IDDate
      101/12/2017
      201/11/2017
      3

      11/10/2017

      412/09/2017

       

      Let´s suppose that we chose the day 19/12/2017.

       

      The dimensions should show then "19/12/2017, 19/11/2017 ... 19/12/2016" (13 dimension values).

       

      The expression should be a simple count distinct ID.

       

      Can someone help me out?

       

      Thx!