Counting users who had two events types in a specific time frame

[labodd]

I’m wanting to count total users who have had at least one of each event time within the filtered time frame. The issue I’m having is that the table has the structure:

User ID | event date | event name 00001 | 01/01/2024 | event 1 00001 | 02/02/2024 | event 2

So when I use set analysis with “and” logic, it will always come up as 0 users. E.g. in the example layout above, if I wanted to count total users who had both event 1 and event 2 during January - March 2024, it will come up as 0. But actually I should be getting 1 as user 00001 has had both event 1 and event 2 during that time, so therefore meet the criteria to be counted.

Any suggestions much appreciated.

[Anil_Babu_Samineni]

Try like this? 

Create Quarter from [event date] and use that in analysis. It depends how that is popup bases on your financial calendar.

Count(Total <[User ID]> {<[event date Quarter]={"=$(Min([event date Quarter]))"}>} [User ID])