Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
The chart expression used is
where,
vMaxMonth = month(max(Rep_date)
vMax = max(year)=2016
vPrev=(max(year)-1 = 2015
I need to show month level comparison like am having 2015 and 2016 years and month filter.Am using Combo chart.
Thanks..
Sample app would be help you better.
What issue you are facing?
what error ur getting? expression seem correct
When we doing MOM for 2015 and 2016 for FEB-2015 no of days = 28 for 2016 no of days = 29 here i need to compare dynamically. with in one chart
Define a month sequence number in your calendar at script like:
Year * 12 + Month as MonthNumber (where Year and Month are the respective fields from your calendar)
Then month on month would look something like:
Sum({<MonthNumber ={"$(=Max(MonthNumber ))"}>} Amount) //For max month
Sum({<MonthNumber ={"$(=Max(MonthNumber )-12)"}>} Amount) // For Max same month but last year
Ok let me do this and will get back.
Thanks..
HI,
Check this links below
Set Analysis for certain Point in Time
Set Analysis for Rolling Periods
Current Month:
Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date)))<=$(=Max(Date))’}>} Sales)
Previous Month:
Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date), -1))<=$(=MonthEnd(Max(Date), -1))’}>} Sales)
Hope this helps you.
Regards,
Jagan.
Hi Jagan,
I need to compare 2016 vs 2015 mom like 2016 feb vs 2015 feb