Count of locations with more than three incidents last week

[glenn2460]

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

[Kushal_Chawda · Accepted solution]

try to nest the set analysis

=Count({<Location={"=count(distinct {<[Incident Date.autoCalendar.WeeksAgo]={1}>} [Incident Number])>3"}>} distinct Location)

[dwforest]

Maybe combine the test:

Count({$<Location={"=Count(distinct [Incident Number])>3 and [Incident Date.autoCalendar.WeeksAgo]=1"}>} distinct Location )

[glenn2460]

Thank you for your reply!

[glenn2460]

Thank you for your reply!