Qlik Community

New to Qlik Sense

Discussion board where members can get started with Qlik Sense.

cancel
Showing results for 
Search instead for 
Did you mean: 
Highlighted
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
Highlighted
Employee
Employee

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

View solution in original post

1 Reply
Highlighted
Employee
Employee

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

View solution in original post