Heat map totals to use AVERAGE instead of SUM
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
Best Answer
-
@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`))
0
Answers
-
@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`))
0 -
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.
1
Categories
- All Categories
- 1.8K Product Ideas
- 1.8K Ideas Exchange
- 1.6K Connect
- 1.2K Connectors
- 300 Workbench
- 6 Cloud Amplifier
- 9 Federated
- 2.9K Transform
- 102 SQL DataFlows
- 626 Datasets
- 2.2K Magic ETL
- 3.9K Visualize
- 2.5K Charting
- 755 Beast Mode
- 61 App Studio
- 41 Variables
- 693 Automate
- 178 Apps
- 456 APIs & Domo Developer
- 49 Workflows
- 10 DomoAI
- 38 Predict
- 16 Jupyter Workspaces
- 22 R & Python Tiles
- 398 Distribute
- 115 Domo Everywhere
- 276 Scheduled Reports
- 7 Software Integrations
- 130 Manage
- 127 Governance & Security
- 8 Domo Community Gallery
- 38 Product Releases
- 11 Domo University
- 5.4K Community Forums
- 40 Getting Started
- 30 Community Member Introductions
- 110 Community Announcements
- 4.8K Archive