Skip to main content
Announcements
Have questions about Qlik Connect? Join us live on April 10th, at 11 AM ET: SIGN UP NOW
cancel
Showing results for 
Search instead for 
Did you mean: 
ajinkyabhonsle
Contributor III
Contributor III

Calculate Average per month

Hi Qlik users,

I need to find out the average transactions per month for our customers. here is the layout(attached). The blue column is the way our data is structured. I am looking for the value in Green column. I am looking for an average transactions customer is sending when they are active. Here is the set analysis for Transactions column.

sum({<METRIC_NAME = {'Sends'},CLASSIFICATION = {'CUSTOMER','PARTNER'}>}Transactions)

What will be the set analysis to get the average transactions? For eg: Salesforce was sending transactions for 8 months and so its average is 113 as mentioned in the green column. 

 

 

 

 

 

Labels (1)
1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Aggr(NoDistinct Avg({<METRIC_NAME = {'Sends'},CLASSIFICATION = {'CUSTOMER','PARTNER'}>}Transactions), Customer)

View solution in original post

1 Reply
Lisa_P
Employee
Employee

Aggr(NoDistinct Avg({<METRIC_NAME = {'Sends'},CLASSIFICATION = {'CUSTOMER','PARTNER'}>}Transactions), Customer)