Heatmap exclude totals

[davidovv]

I created a pivot where i have daily hours as main data, where columns are weekdays. At the end of each row there is summary for every week. Since there is 8 hour expected for every date, a heat-map is very useful in detecting overtime and undertime. When there is record that differs more from 8 hours it gets higher color..., but i get "high heat color" in totals where data is summarized. Is there a way to exclude totals from heat-map? I cant figure out if there is such option or this could be an issue.

[mswastik]

+1

[nicolaskruchten]

The total row and total column are colored according to their own min/max scales, and the non-total table area is colored by its own min/max scale... Check out the screenshot below, where the highest cell in the non-total area has the same intensity of red as the highest cell in the total row and the highest cell in the total column:

Are you wanting the total/row columns to just be uncolored?

[mswastik]

Yes just noticed, then its fine.

[davidovv]

Yes i wanted them to be uncolored The idea was to have value dependent color, like for range 7.5 to 8.5 hours green, under 7.5 blue, over 8.5 red But when creating such custom heat-map i get totals always in red red and my visual presentation is kind of spoiled Now that you say that totals use different heat-map, and my totals are week summary where 40 hours are expected, can i set different color map ranges for totals, and if so, how?

[nicolaskruchten]

@davidovv What I meant by "are colored according to their own min/max scales" is that the bounds of the scale are computed separately for the totals than for the main table body. Unfortunately they still use the same actual color scale, so there's no easy way to simply not color the total cells :(