10 Replies Latest reply: Feb 3, 2017 8:09 AM by Sunny Talwar RSS

    comparing daily sales between years

    Глеб Аитов



      I am trying to put two dimensions on the line chart in order to compare daily sales for the chosen years:

      1. Date(Date,'MM/DD') - custom dimension

      2. Year


      Unfortunately, it creates duplicated dimensions equal to the number of years I have and does not combine it (in my example i have three years horizon and it creates three 01/01 values, 02/01 values and so on)


      PS: I am still able to make it when the dimension is "Day of the Year" (see the screenshot below), but is does not work for me - I need to see actual dates (DAY and MONTH) on the X-axis.



      can you help me please