Days Hours Minutes Seconds format not flowing through to Chart
I have created a calculated field using the Pre-Defined Formula type and function "Time difference (seconds), SQL Server
It calculates the average time correctly and displays it in the desired hh:mm:ss
But on the chart, it shows the value in seconds (i.e. as a number) instead of the hh:mm:ss that I am expecting.