Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
I'm attempting to obtain the number of locations having more than three incidents last week.
Here's my latest attempt -- which is giving me the number of locations with more than three incidents -- regardless of date.
Count({$<Location={"=Count(distinct [Incident Number])>3"}, [Incident Date.autoCalendar.WeeksAgo]={1}>} distinct Location )
Any assistance much appreciated.
Thanks.
Glenn
try to nest the set analysis
=Count({<Location={"=count(distinct {<[Incident Date.autoCalendar.WeeksAgo]={1}>} [Incident Number])>3"}>} distinct Location)
try to nest the set analysis
=Count({<Location={"=count(distinct {<[Incident Date.autoCalendar.WeeksAgo]={1}>} [Incident Number])>3"}>} distinct Location)
Maybe combine the test:
Count({$<Location={"=Count(distinct [Incident Number])>3 and [Incident Date.autoCalendar.WeeksAgo]=1"}>} distinct Location )
Thank you for your reply!
Thank you for your reply!