1 Reply Latest reply: Jul 9, 2018 5:55 AM by Khalil Foudhaily RSS

    Calculated date dimension in x-axis of line chart

    Jasmina Karčić

      Hi experts,

       

      I need line chart that can be modified by choosing different DATE in filter.

       

      If I choose, for example date 06.07.2018, I want in my chart on x-axis 8 dates:

       

      18.05.2018, 25.05.2018, 01.06.2018, 08.06.2018, 15.06.2018, 22.06.2018, 29.06.2018, 06.07.2018.

       

      But if I don't choose anything, I want default values, starting from the end, from today. If today is 09.07.2018, then default values are:

       

      21.05.2018, 28.05.2018, 04.06.2018, 11.06.2018, 18.06.2018, 25.06.2018, 02.07.2018, 09.07.2018.

       

       

      Difference between two days is one week (7 days).

       

      Any help for making this dimension?

       

      Thanks a lot...