Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I am trying to create a set analysis expression which will count the number of cases within a week from this year compared to the same week last year. I have created Week_No in my calendar table (WeekName(RecordDate)), and I can work out the comparable Week_No from last year as
=WeekName(Week_No-364)
However, in set analysis, I am unable to work out how to add this as a modifier - the nearest I get is:
=count({$<Week_No={$(=WeekName(Week_No-364))}>} Distinct CaseID)
My results table using the above comes out as:
The data table is attached
Grateful for any help here
Try using this
Above(YourExpression4NoOfCaseThisYear)
I need to be able to see on each line the value for (eg) 2018/02 and the corresponding value for 2017/02
If I use 'Above', the value will be the figure for 2018/01 against the line for 2018/02, will it not?
My bad, you can do it do ways
1) Use The As-Of Table
2) Try with this Above(YourExpression4NoOfCaseThisYear, 12) but make sure you remove any set analysis related to restricting the data to show only 2018
Thanks - my problem might be the fact that I am using Dimensions which are date-based as well, so will have to re-think
Thanks anyway