Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All,
Is it possible to use Set Analysis within Set Analysis.
Like this example, which does not work
COUNT(DISTINCT {<SNAPSHOT_DATE = {">=$(=Date(MAX({<SNAPSHOT_DATE -= {'16/09/2017'}>}SNAPSHOT_DATE)-20,'DD/MM/YYYY'))"},FileType = {'HISTOPEN'}>}[Service Request Number])
This part works fine
COUNT(DISTINCT {<SNAPSHOT_DATE = {">=$(=Date(MAX(SNAPSHOT_DATE)-20,'DD/MM/YYYY'))"},FileType = {'HISTOPEN'}>}[Service Request Number])
I would like to count the Service Request Numbers for the last 20 days, but not include data for a specific date within those 20 days, can it be done in an expression using set analysis?
Regards
Alan
May be this
Count(DISTINCT {<SNAPSHOT_DATE = {">=$(=Date(MAX(SNAPSHOT_DATE)-20, 'DD/MM/YYYY'))"}-{'16/09/2017'}, FileType = {'HISTOPEN'}>} [Service Request Number])
May be this
Count(DISTINCT {<SNAPSHOT_DATE = {">=$(=Date(MAX(SNAPSHOT_DATE)-20, 'DD/MM/YYYY'))"}-{'16/09/2017'}, FileType = {'HISTOPEN'}>} [Service Request Number])
Yes, that's it, perfect