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.
