4 Replies Latest reply: Aug 26, 2016 1:46 PM by Robby Meyers

# Block Chart Subtotal Aggregation Type?

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.

• ###### Re: Block Chart Subtotal Aggregation Type?

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

• ###### Re: Block Chart Subtotal Aggregation Type?

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

Robby

• ###### Re: Block Chart Subtotal Aggregation Type?

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.

• ###### Re: Block Chart Subtotal Aggregation Type?

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.