Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi Folks ,
I'm facing on small issue while calculating average in Straight table and in Bar charts. Please see below:
In this Straight table below I'm calculating Act. Tanks Scrapped % as expression = avg(Scrap) which is giving me result 3.4% which is right number. (Here I have set expression total as Average so I'm getting 3,4% which is correct)
Now the same thing I'm calling in a Bar chart calling the same expression =Avg(Scrap) , but here I'm getting average as 3,5% which is not the exact average . As we don't have option for setting Expression Total as Average for Bar chart. I want to show here exactly 3.4% instead of 3.5% .
Kindly help me here in bar chart , how to get exactly average numbers.
Thanks,
AS
Why don't you help us by attaching sample qvw that shows the issue?
Tresesco,
Sorry I can't share , but it would be helpful if you can help me how to enable Expression Total (Total Mode) options for Combo chart:
Thanks,
AS
You can't enable that. Workaround - try expression like:
=Sum(Aggr( Sum([Act Scrap $]), Dimension1))