Forum Discussion

James_Galis1's avatar
James_Galis1
Helper II
2 years ago
Solved

Count events on dates based on condition

Hello Community

Hoping to get some assistance with the following.

 

I have a table of contents that has clients attending an event over various dates.
I want to count the events but only when there has been more than 4 clients attend over any given date .
Eg

 

Visit Start DateClient ID
10/04/2024AC000001559
10/04/2024AC000072718
10/04/2024AC000637102
10/04/2024AC000876443
10/04/2024AC000949724
10/04/2024AC001095530
10/04/2024AC001118236
10/04/2024AC002313429
10/04/2024AC003762526
10/04/2024AC004373399
10/04/2024AC005013076
12/04/2024AC002313429
16/04/2024AC000001559
16/04/2024AC000857537
16/04/2024AC001032870
16/04/2024AC001070439
16/04/2024AC001118236
16/04/2024AC001743949
16/04/2024AC002564643
16/04/2024AC004049946
16/04/2024AC004228120
16/04/2024AC004269964
16/04/2024AC004373399
16/04/2024AC005013076

 

From the above , there are 3 dates. Only the 10th and 16th have a count of more than 4 clients.

The outcome im wishing to acheive is to have a measure to calculate the number of events and from the above the results should be 2.

Many Thanks

Need Help

3 Replies