Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
I have a chart with the following set as Dimensions & Measures - I've read through the posts on exclusions and Set Analysis but I cant seem to get it to work.
Dimension =
=Aggr(Only({1<Site = {'Site 1','Site 2','Site 3','Site 4','Site 5','OSite 6','Site 7','Site 8','Site 9','Site 10','Site 11'}>} Site), Site)
Measure =
Count({< Status = {'3.Due'} >} IF(Date >= Date(Today() , 'MM/DD/YYYY') AND Date <= Date(Today()+7, 'MM/DD/YYYY'), Status))
Is there anyway i can use Set Analysis to exclude this chart from all other filtering on the sheet, if not can anyone suggest another solution/way to do so?
Thanks in advance for any assistance
Steve
You need to add the 1 identifier to your measure:
Count({1< Status = {'3.Due'} >} IF(Date >= Date(Today() , 'MM/DD/YYYY') AND Date <= Date(Today()+7, 'MM/DD/YYYY'), Status))
You need to add the 1 identifier to your measure:
Count({1< Status = {'3.Due'} >} IF(Date >= Date(Today() , 'MM/DD/YYYY') AND Date <= Date(Today()+7, 'MM/DD/YYYY'), Status))
Try this...
Count({1<Status={'3.Due'}>*<Date={">=$(=Date(Today(), 'MM/DD/YYYY'))"}>*<Date{"<=$(=Date(Today()+7, 'MM/DD/YYYY'))"}>} Status)
I was nearly there! I was putting the 1 in its own set of braces!
Count({{1}< Status = {'3.Due'} >} IF(Date >= Date(Today() , 'MM/DD/YYYY') AND Date <= Date(Today()+7, 'MM/DD/YYYY'), Status))
Many thanks Gary, my headache is over!