Best Of

Thanks, @MarkSnodgrass The goal was to set the ID of each square of the chart as a concat of its x & y categories and then assign a count against each cell of the 5 x 5 matrix (25 cells). If the colour of each square were pre-set, the only thing I would be missing would be the data label, as I could just put a count against the concat categories. I will play with it tomorrow and see what happens.

However, you have presented an excellent example of how it could look if the requirements were simply a gradient of colours. If I can't get it to work, I will regress to this process as I've managed to fix my sort by including dummy 0 values when no data is available and "checking" show 0 values, too.

It's a shame there aren't more options for colour logic in these charts because overriding and filling a cell with a specific colour is almost impossible but could be incredibly valuable.

Hi Mark,

Thanks for your response - I've been watching a lot of the content you have put out on custom charts on behalf of DOMO with this, so I appreciate your time and want to thank you for your help with SVG files and the custom chart format.

Unfortunately, the Risk Heatmap card suffers from the same problem as any other table where if you want to use a custom sort through a beast mode, any cells with 0 values will not be captured and sorted correctly, leading to the categories being out of order, (unless I'm missing a trick?).

The other issue with the risk heatmap is that as it's a gradiated colour pallet, the set cells that need to be a specific colour cannot be coloured correctly. Part of the work we will be doing in other graphs is trending the time-series of the count of each colour bucket to differentiate severity visually. So the set colour per cell is, unfortunately, crucial for the story we are looking to tell.