How to replace blank values with 0 in a heatmap?

Question

I have a heat map as shown in image.

enter image description here

For white regions blank there are empty rows and columns.

Verification done:

SELECT * FROM final_concurrency where region = 'APSE1' and weekday_name = 'Sat'

This produces empty rows i.e no data is there for this particular query.

I even tried checking **Show Empty Rows and Show Empty Columns ** and

using calculated field as ZN(AVG([utilization_percentage])) and adding it to color and label. But still the region in heatmap is white and with no values.

Is there any way to fix this.

Why do you want to substitute "no data available" and blank for a misleading data is 0? BTW the fonts could do with being larger and numbers look better centred in a heatmap. — Martin Brown
– Martin Brown, Commented Sep 24 at 21:20
The expected output is 0 on the heatmap. Is there some any other way or scaffolding is required. — Rikky Bhai
– Rikky Bhai, Commented Sep 24 at 21:42
Why do you expect 0. The values in neighbouring cells around the blank cells hint that the value is more likely to be 20. Missing data is missing. — Martin Brown
– Martin Brown, Commented Sep 25 at 9:21

Alex Blakemore · Accepted Answer · 2025-09-27 19:22:01Z

1

Try wrapping your calc with LOOKUP(xxx, 0), replacing xxx with your measure, For instance

LOOKUP(AVG([utilization_percentage]), 0)

answered Sep 27 at 19:22

Alex Blakemore

12k2 gold badges30 silver badges51 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

How to replace blank values with 0 in a heatmap?

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related