Skip to main content
Announcements
See what Drew Clarke has to say about the Qlik Talend Cloud launch! READ THE BLOG
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)