Qlik Community

New to Qlik Sense

If you’re new to Qlik Sense, start with this Discussion Board and get up-to-speed quickly.

Announcements
Read about the latest Qlik Community enhancements on the Community News 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. 

 

 

 

 

 

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)

View solution in original post