Heatmap Functionality - Domo Disappointment :(

Data_Devon

Hi team,

This might be the first time that Domo couldn't do something that I was after.

I need a Pivot Table that has heatmap color formatting, and I need each row to be formatted independently of other rows.

I can't find anything - hoping you guys have an idea.

Here's my Pivot Table: I want each row to be colored independently of other rows, but maintain the pivot structure.

ArborRose

I don't think you apply heatmap color formatting on row-level independent heatmaps (per row). By default, heatmap or conditional formatting in pivot tables would be applied across the entire column. :(

You could try something using a Magic ETL and calculate row min/max or percentage. Then compute a color scale per cell based on each row's value.

CONCAT('<div style="background-color:rgba(255,0,0,', `Heat Intensity`, ');">', `Value`, '</div>')

Or do it in a brick, but that's much more work.

Data_Devon

@ArborRose Thanks for the thoughts, but it appears my suspicions are correct and there is no easy/default functionality.

Help me understand how the MagicETL calculation would work, and how it would accomplish my goal?