Hello,
I'm having an issue calculating a rolling 12 month count of records. It works for all of my line charts, however, when I add an embedded set analysis statement, the rolling 12 month set analysis no longer work. Would anyone have a solution?
count(DISTINCT{<Calendar.C_YEAR_DASH_MONTH={">=$(=Addmonths(MAX(DATE#(Calendar.C_YEAR_DASH_MONTH,'YYYY-MM')),-12))<=$(=MAX(DATE#(Calendar.C_YEAR_DASH_MONTH,'YYYY-MM')))"},Calendar.Date=, Calendar.MONTH=,Calendar.Year=>} Fact.ACCOUNT))
The above expression works perfectly, however, when I add the embedded set analysis like the expression below, it no longer works.
count(DISTINCT{<Calendar.C_YEAR_DASH_MONTH={">=$(=Addmonths(MAX(DATE#(Calendar.C_YEAR_DASH_MONTH,'YYYY-MM')),-12))<=$(=MAX(DATE#(Calendar.C_YEAR_DASH_MONTH,'YYYY-MM')))"},Calendar.Date=, Calendar.MONTH=,Calendar.Year=,Fact.ACCOUNT = p({$<Fact.POI_VALUE = {1}>}Fact.ACCOUNT), Metric1.Description *= e(Metric1.Description) >} Fact.ACCOUNT))
Any help is greatly appreciated.