Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi ,
In my current dashboard, there is one YoY analysis chart which has some issues while displaying data for current Year.
Details -:
1. Dashboard pulling data from 2009 - (2009,2010,2011,2012,2013 & Current year upto today).
2. In YoY Chart i am using below Expression with Set analysis -:
=(sum({<Date = {">=$(=MonthStart(Max(Date), -12))<=$(=MonthEnd(Max(Date),-1))"},DATE=,Year=,Month=>}sales)
-sum({<Date = {">=$(=MonthStart(Max(Date), -24))<=$(=MonthEnd(Max(Date),-13))"},DATE=,Year=,Month=>}sales))
Above expression working fine for previous years but when dashboard user select Current Year from Year filter (i.e. 2014) logicaly , YoY chart should display data only upto AUGUST - 2014 however it shows data for all 12 months ( from previous years ) as well.
My requirement is : Whenever user select Year as Current Year , YoY chart should show data up
Jan 2014 to August - 2014 .
Your inputs on this really appreciating to us.
Thanks
Sanket
Use YearStart(max(Date)) instead of MonthStart(Max(Date),-12) if you want to calculate from the start of the year instead of from 12 months earlier. For the previous year use YearStart(Max(Date),-1)