Calculated total in charts
I am preparing reports where I use calculated fields to get averages or other values. It works well and I then use the Calculated total in the Totals option, and it works well.
However I then need to prepare a chart that is a Numeric Display showing this calculated total and I don't see this option. I see the total or the average or a count but not the calculated total. When one aggregates data and wants to show a number (KPI) in the form of a Numeric Display the calculated total is the true value we should be showing. How can I do this? Meaning, how can I get a Numeric Display chart showing this calculated total?
The same applies to other chart types such as the Meter, Thermometer or Dial.
We use the March 2018 built of 7.4.