Active User Curve - help needed

[Anonymous]

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? 

[v-juanli-msft]

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
Maggie

[seanpratt]

Bump 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?