Monthly Line Chart with 2 Dimensions Divided by Monthly Total
Hi All,
I have a set of features and am plotting the usage of those features over a 12 month period using a line graph with 2 dimensions.
This is what the graph looks like if I just count the number of users that have used each of the features:
What I want to do is plot the number of users that have used each feature as a percentage of the number of customers that have signed up within the same month.
If I use:
COUNT(distinct [ACCOUNT ID])/COUNT(DISTINCT TOTAL [ACCOUNT ID])
I obviously get the number of users that have used the feature that month divided by the total number of users in the whole app.
I have tried:
COUNT(distinct [ACCOUNT ID])/COUNT(DISTINCT TOTAL <[SIGNUP DATE.autoCalendar.YearMonth]> [ACCOUNT ID])
but it just does the number of users of each feature, divided by the total number of customers that have signed up over the past 12 months.
What I would like to be able to plot is this (but for every month, this is just an example of 1 month):
Feature
No. of Signups in September 2021
Users per Feature
USERS/SIGNUPS
1
1436
346
346/1436=0.240947075
2
1436
545
545/1436=0.379526462
3
1436
573
0.39902507
4
1436
377
0.262534819
Note: One user may use multiple features, so the Users/Signups doesn't sum to 100%