Skip to main content
Announcements
Introducing Qlik Answers: A plug-and-play, Generative AI powered RAG solution. READ ALL ABOUT IT!
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