3 Replies Latest reply: May 14, 2013 8:15 AM by Daniel Etten, van RSS

    Unable to get correct Average time Gauge Chart

      Hi,

       

      I have a Gauge Chart that looks like a speedometer, which I need to represent my average fix times.  I have a field called (fix_time_true), which pulls out the fix time on each incident.  However in my guage chart, the speedometer shows correct, however in the Presentation Tab -> and text in chart section, I have the following code - =avg(fix_time_true).  However this pulls it out as 0.0464400008 and it should show an average of 1:06:52. 

      The fix time is in seconds and in the load script I ran the following ,interval(time(fix_time/86400, 'hh:mm:ss')) as fix_time_true.

       

      Regards,

       

      Jon Ditchfield