Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content

Announcements
Want to see what's currently in public preview? We've pulled it all together in one place. Check it out here
cancel
Showing results for 
Search instead for 
Did you mean: 
hannah0096
Contributor
Contributor

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: 

hannah0096_0-1642087677665.png

 

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%

Labels (4)
0 Replies