Forum Discussion
Active User Curve - help needed
I am trying to create a graph to show what % of my active user base completes 1, 2, 3, 4, etc. number of tasks in a given month. (see image to understand output desired and axis )
I have the following tables:
- CALENDAR TABLE
- ACTIVTY TABLE:
| Activity Reference | ActivityPrevStatus | ActivityNewStatus | UserID | Date |
| 12 | Assigned | Assigned | 1 | 12/19/19 |
| 12 | Completed | Completed | 1 | 12/22/19 |
| 13 | Assigned | Assigned | 3 | 12/19/19 |
| 13 | Completed | Completed | 3 | 12/22/19 |
| 14 | Assigned | Assigned | 1 | 12/19/19 |
| 14 | Completed | Completed | 1 | 12/22/19 |
USERS TABLE
| USERID | USERSTATUS | Date Activated | Date Deactived |
| 1 | Active | 11/1/19 |
|
| 2 | Deactivated | 11/1/19 | 12/1/19 |
| 3 | Active | 11/1/19 | |
| 4 | Active | 12/1/19 |
How can I create measures with this information to make the graph I want?
amitchandak you've been super helpful before, any thoughts?
2 Replies
Hi Anonymous
Which should be used to color the columns of the picture?
Could you clear me what is the value and the rule to calculate it?
Best Regards
MaggieBump on this post. This is almost identical to what I'm trying to do. Any idea on steps I need to take?
I have two tables. One is Unique Users and date they activated on my website. The second is User ID, ActivityID, date of ActitivityID.
What I need to do is summarize the users that have 1 activity, and then group them and show them as a whole (18 users for "1"), and then proceed for each day value. Right?
