
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
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%
