Set analysis MOM

[nareshthavidishetty]

Hi,

The chart expression used is

• count({<AppStats={'Approved'}, Month={$(vMaxMonth)}, Year={$(vMax)}>}DISTINCT AppNUM)
• count({<AppStats={'Approved'}, Month={$(vMaxMonth)}, Year={$(vPrev)}>}DISTINCT AppNUM)

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..

[jagan]

Try like this

Current Month:

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date)))<=$(=MonthEnd(Max(Date)))’}>} Sales)

Previous Year Same Month:

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(Max(Date), -12))<=$(=MonthEnd(Max(Date), -12))’}>} Sales)

Hope this helps you.

Regards,

jagan.

[Anonymous]

Did you try what I suggested you?

[PrashantSangle]

Hi,

need little change in second expression suggested by JAgan

try below

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(AddMonths(Max(Date),-12)))<=$(=MonthEnd(AddMonths(Max(Date), -12)))’}>} Sales)

or you can use addYears()

Sum({<Year=, Quarter=, Month=, Week=, Date={‘>=$(=MonthStart(AddYears(Max(Date),-1)))<=$(=MonthEnd(AddYears(Max(Date), -1)))’}>} Sales)

Regards

[nareshthavidishetty]

Thanks to all the issue got resolved.

[Anonymous]

Dont forget to close this thread by selecting correct/helpful answer