Forum Discussion
active users over a period
Hi, I have a requirement where i need to find the count of active user per month/Qtr/Year based on slicer selection from the sample data attached here.The active or inactive status is described by F...
The factual start date will always be month begining and the end date will never be within the month.
Example of use case in the dataset-
User John started on Jan 2020,and quits by Jul 2020.
The he is rehired in Oct 2020 and stays until Dec 2023.
Thanks a lot for looking into it.Please help with this request.
Hi Anonymous ,
Has your problem been solved?
If not , what is the expected output of the matrix when the slicer selects ‘2020-05’?
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.