Heat maps with multiple index columns
Heat maps with multiple index columns display a rectangle hierarchy. The number of levels of the hierarchy is the number of columns from the visualized data table that are specified as index columns.
In such a heat map, there is a rectangle at level n for each unique sequence of values from the first n index columns, for every level between 1 and the number of index columns, inclusive.
For a given such sequence of n index values, the area of the corresponding rectangle is proportional to the result of aggregating the values in the size-data column in those rows whose first n index columns contain the values in the sequence. You specify the type of aggregation to use (sum, count, average, min, or max) with the sizeValueGroupType property.
In addition, for a given such sequence of n index values, the color of the corresponding rectangle is determined by the result of aggregating the values in the color-data column in those rows whose first n index columns contain the values in the sequence. You specify the type of aggregation to use (sum, count, average, min, or max) with the colorValueGroupType property.
Important! Negative aggregated values are treated as 0.