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: 
rmdnkevin
Contributor III
Contributor III

Count Avg from Chart

Hi, everyone.

I have 2 charts like this :

Screenshot_9.png

Those 2 charts are the result of computation from this chart :

Screenshot_10.png

What I want to ask is, how can I count the average over 5 months of Simulation Clicked and Report-to-Click Ratio ?

Any answer would be greatly appreciated

Thank you

- Kevin

1 Solution

Accepted Solutions
Lisa_P
Employee
Employee

Whatever your expression is to create the bar chart, you will need to use the aggr function to aggregate by the dimension in your chart.

If your dimension is month, then it would look like this:

Avg(Aggr(........... , Month))

View solution in original post

3 Replies
Lisa_P
Employee
Employee

Whatever your expression is to create the bar chart, you will need to use the aggr function to aggregate by the dimension in your chart.

If your dimension is month, then it would look like this:

Avg(Aggr(........... , Month))

rmdnkevin
Contributor III
Contributor III
Author

Great !

Beside that, can you help to make a summary table from Click & Report Rates and Report-to-Click Ratio charts ?

Lisa_P
Employee
Employee

You could either copy and paste and convert to a table or toggle between the two using the Fast change option.