Set Analysis Question

[rustyfishbones]

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

[sunny_talwar · Accepted solution]

May be this

Count(DISTINCT {<SNAPSHOT_DATE = {">=$(=Date(MAX(SNAPSHOT_DATE)-20, 'DD/MM/YYYY'))"}-{'16/09/2017'}, FileType = {'HISTOPEN'}>} [Service Request Number])

[rustyfishbones]

Yes, that's it, perfect