Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Please see the attached file. I want to show a year over year line chart based on daily data or 7 day moving average. Currently 2010 and 2011 data points are showing up continuously on the X-axis. Instead, i would like to display 2011 data on top of 2010.
Hope it makes sense.
Thanks.
You need to map your dates to Day # in FY (i prefer to use business days and combine sat and sundays but this is an example) Then use Day # in Year as your chart dimensino so 1/1/10 will be on same axes point as 1/1/11
Date | Day # in Year |
1/1/2010 | 1 |
1/2/2010 | 2 |
1/3/2010 | 3 |
1/4/2010 | 4 |
1/5/2010 | 5 |
1/1/2011 | 1 |
1/2/2011 | 2 |
1/3/2011 | 3 |
1/4/2011 | 4 |
1/5/2011 | 5 |
Hi Deepkohlitvna ,
May be you have to change your expressions or you have to change your dimension into a calculated dimension for separate years , Try to change your expressions from if conditions to set-analysis coding year(date)='2010' and similarly for year 2011.
the lines are continuing because of not using any year limitation for specified year in your expression and continution of dates in the dimension from 2010 to 2011 .
hope it helps
thanks
Meher
Doesn't seem to work. Can't get 2011 to overlap 2010.
You need to map your dates to Day # in FY (i prefer to use business days and combine sat and sundays but this is an example) Then use Day # in Year as your chart dimensino so 1/1/10 will be on same axes point as 1/1/11
Date | Day # in Year |
1/1/2010 | 1 |
1/2/2010 | 2 |
1/3/2010 | 3 |
1/4/2010 | 4 |
1/5/2010 | 5 |
1/1/2011 | 1 |
1/2/2011 | 2 |
1/3/2011 | 3 |
1/4/2011 | 4 |
1/5/2011 | 5 |
I think I am missing something here. When I use Day # in Year, my X-axis now shows Days from 1 till 365 but the data on the line chart is the sum of 2010 and 2011 instead of separate lines, eventhough I am using separate expressions for 2010 and 2011.
this is the code use for my daily average charts. I create one expression for each period. In my case this is quarters and the axes is Day# in FQ comparing current qtr to last qtr and same qtr last year.
rangeavg
( above( sum({$<NumFYQTR={$(=Max(NumFYQTR,2))},[Subscription Indicator]={'$(=vProdorSub)'},[Vert-Horz]={"Vertical"},[Sales Type] = {"Commercial"},[WWS Sub Geo] = {"North America"}>} [TOTAL BOOKED ($)]), 0, RowNo()) )
Thanks debbiepy. It worked.