Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I have a table like this and i have to make a bar chart to compare this time period.
Time Frame | Current Month Start Date | Current Month Last Date | Previous Month Start Date | Previous Month End Date |
3 Months Vs 3 Months | 12/1/2011 | 2/1/2012 | 9/1/2011 | 11/1/2011 |
6 Months Vs 6 Months | 9/1/2011 | 2/1/2012 | 3/1/2011 | 8/1/2011 |
12 Months Vs 12 Months | 3/1/2011 | 2/1/2012 | 3/1/2010 | 2/1/2011 |
Baseline Vs SPTD | 1/1/2012 | 2/1/2012 | 4/1/2011 | 9/1/2011 |
The expression used will be "Current Month Last Date - Current Month Start Date" to get the bars. And current and previous months bars should be stacked.
I am using timeframe in dimension and "Current Month Last Date - Current Month Start Date" in expression for different timeframes but i am getting very weird values.
How can i do this ??
The problem is with the Date formats in your data. I mean if you simply copy this data to excel you can see that the dates are intrepeted incorrectly.
I mean if you see 2nd row (6 Months Vs 6 Months) - The Current Month Start Date is interpreted as 9th January 2011 instead of 1st September 2011. The month and dates are swapped and everything is interpreted as January 2011, Hence you since the difference between the dates is marginal. Same is the case with the other dates.
I hope this makes sense!
Cheers - DV