Forum Discussion
Check user status based on activity
Hello everyone,
Can anybody help me with this? I am trying to understand how many active and inactive users in our system. We can track the status of the user based on his activity.
If he created a record within a 3-month window thus he is active.
Example:
| User | Transaction Date | Date Dimension | Status |
| A | 01/01/2019 | January | Active |
| A | 01/01/2019 | February | Active |
| A | 01/01/2019 | March | Active |
| A | 01/01/2019 | April | Inactive |
| A | 01/01/2019 | May | Inactive |
| A | 06/01/2019 | June | Active |
| A | 06/01/2019 | July | Active |
| A | 06/01/2019 | August | Active |
| A | 06/02/2019 | September | Inactive |
1 Reply
Hi ogureisuo,
I am not clear about your requirement, so if possible, could you please inform me more detailed information (such as your expected output)? Could you please explain your logic based on above sample and inform me your expected output, then I will help you more correctly.
Best Regards,
Zoe ZhiIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
