I have combined the two earlier responses and made a sample file to match your requirement using a Resident Load.
If this helped you, please mark as Helpful. If it solves your issue, please mark as Answer
If you are viewing this topic and found it informative, please like my comment.
Thank you for the response. This was close...sticking to your example, I have more than 100 products so its not feasible for me to show all products in a single chart .... is there an option where we can have an Input Box and select a company to dynamically change the <client> on the chart?
I tried your resident load method, it gives me the following error
Table not found
Sum([Overall Impact From 3R's])/Count(DISTINCT [Overall Impact From 3R's]) as Averageoverallimpact3Rs
resident [Overall Impact From 3R's]
Instead of the above .. can I just not have another expression for average? like avg(sales) ?
Please let me know what you think.