I’m stuck up with one task below.
I need to find the active users based on the month filter selection in the report.
Consider the below sample data set.
Aug-21 Sep-21 Oct-21
Customer A Customer A Customer A
Customer B Customer C
Customer C Customer D
When I'm filtering for the last 3 months , I would like to to see the count as 1 customer because Customer A is active for all the months.
what I get here is the total count as 9. I'm using count operation.
I'm not getting the calculation of how to implement this logic.
Can somebody help?