Hi Team, I’m working on a heatmap and was wondering if there’s a way to convert the legend from seconds to hours, similar to how I formatted the metric using custom time conversion.

HI Suzhe, to convert ONLY the legend it is not possible, but you can create a metric using the fact/metric in seconds to convert it to hours like the attached screenshot.

SELECT SUM({fact/totalamount})/3600

And then use that metric in the heatmap. Please, give it a try and let us know if that works for you.

Hi Mauricio, thanks for your help. All good on my side now, thanks!