1 Reply Latest reply: Nov 9, 2015 3:36 AM by Gysbert Wassenaar RSS

    Two different fields into one dimension

    Stella Patrizio

      Hi everyone.

       

      I have the sales of a product for two different periods: the first week of September and the first week of October (in this week there were sales).

       

      In order to show the variation of sales between the two periods, I used two alternate states for the periods, so I assigned the first week of September to the alternate state called 'Period ONE' and the first week of October to the alternate state called 'Period TWO'.

       

      Now, my aim is to create a line chart where I can see sales for every day of the two weeks, but I want the two lines on the same dimension.

      In other words, I'd like to have Day 1, Day 2, ... , Day 7 in the X-Axis , and not Sep/01,Sep/02,...,Sep/07,Oct/01,Oct/02,...,Oct/07.

      How can I do this?