Block Chart Subtotal Aggregation Type?

[#1]

Is it possible to change the aggregation type for the header row of the block chart when you have 2 dimensions?  Right now it looks like its just summing the expression.  This is a problem when the expression is an Average and I want the total aggregation to be an average as well.

[sunny_talwar]

Have you already tried using Dimensionality() or Aggr() function to get this resolved?

[#3]

I haven't yet but do you have an example of what it might look like?

Robby

[sunny_talwar]

In general -

Dimensionality:

How to use - Dimensionality()

The second dimension... or how to use secondarydimensionality()

Aggr():

https://www.analyticsvidhya.com/blog/2014/02/aggr/‌

Particularly for your example it would be helpful if you can provide a sample, even dummy data will work, but a sample with expectation of an output will be very helpful in getting you to your final result.

[#5]

In its simplest form if you look at the picture I posted where it shows 180,194.  I want this to be an avg instead of a sum.

If I gave you a data set that had

Apple Green 2

Apple Red 4

Orange Red 5

Orange Orange 10

The total field should show 3 instead of 6 for Apple and 7.5 for Orange instead of 15.  Currently the total will only SUM the expression which is a problem if the expression is an average.