topic Re: Totals in bar Chart in App Development

Totals in bar Chart

dnagarajan — Sat, 16 Nov 2024 01:14:17 GMT

Hey..

How to attain the average in totals in bar Chart instead of sum .

Appreciate any quick help. Thanks

Re: Totals in bar Chart

Kushal_Chawda — Tue, 27 Oct 2020 12:15:31 GMT

@dnagarajan not clear what you are looking at. Can you please elaborate

Re: Totals in bar Chart

dnagarajan — Tue, 27 Oct 2020 12:42:12 GMT

Hi @Kushal_Chawda..

this is qlik native bar chart.

Dimension is stacked category & month, Measure is just sum(field1)/sum(field2).

Totals is displayed as Sum of all values (76). instead i want to display Average in totals(~10.8)

Re: Totals in bar Chart

forte — Tue, 27 Oct 2020 12:49:37 GMT

Hi @dnagarajan

I'm affraid you can't change that issue. Bar chart is always totalizing as a adding values of all segments (try with an avg, it does just de same addition).

You should use two different charts, or may be a combo chart with average as a line (or symbol) on secondary axis.

Hope it helps

Regards

Re: Totals in bar Chart

dnagarajan — Tue, 27 Oct 2020 12:58:45 GMT

Thanks @forte i also thought of the same combo chart idea. 🤗

Trying to grasp folk's workaround solution for the same.

Re: Totals in bar Chart

Kushal_Chawda — Tue, 27 Oct 2020 14:36:51 GMT

@dnagarajan as others mentioned, you can't directly do it , as a work around you can use custom tool tips where in you can represent the avg values.