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.