Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I created a synthetic dimension (1 to 10). Based on a startdate I would like to have rolling period.
So startdate + 1,startdate + 2.
From what I know you cannot use a synthetic dimension in a set analysis. So I tried to use Rowno() instead.
This expression workfine whitout re-calculating it $(= ..)
$(=date(addmonths(makedate(2013,01),RowNo()),'YYYYMM'))
(Count({1<PARTY_ID=Cohort_1::PARTY_ID,
YEARMONTH={'$(=date(addmonths(makedate(2013,01),RowNo()),'YYYYMM'))' } >}PARTY_ID)
Thanks,
Ben
Hi Ben, Why you are using Synthetic Dimension here ? What is your actual requirement ?
Your dimension id tied the STARTDATE , so you can create the new field on the data model and use the new field in your chart.
Can you please post sample qvw here ?