Heat map totals to use AVERAGE instead of SUM

Charlie Bantoft · 2024-01-23T10:25:24+00:00

There was an error rendering this rich post.

Hi folks. I have a heatmap with the values as averages of values within the data.

I've asked domo to add a 'Total Row' and a 'Total Column' (red outline below) but rather than these also being averages - domo is totalling the rows/columns. I need them as averages.

Any ideas?

Thanks

Find more posts tagged with

Charting

Heatmap

Accepted answers

MichelleH

@Charlie Bantoft Total rows and columns will use the same aggregation as the "Values" field by default. In other words if the other values are being summed, then your totals will also be using a sum. You could try swapping a beast mode with a fixed function into the values field like this:

avg(sum(`value_field`) fixed (by `row_field`, `column_field`))

All comments

MichelleH

avg(sum(`value_field`) fixed (by `row_field`, `column_field`))

Charlie Bantoft

Hi @michelleH - thanks for your responses. I can't seem to get total rows and columns to use the same aggregation and I've tried your formula (thank you) but it's still not right (same result as before actually). I'll tinker around with it. Thanks again.