9 Replies Latest reply: Sep 24, 2018 11:53 AM by Vipul Narang RSS

    Converting seconds to 'hh:mm:ss' format is not working properly

    Vipul Narang



      I am using an extension object "climber KPI version 1.5.0"


      By using that, i am showing a metric versus a benchmark. For example, Time on site is in seconds and by using the following formula , i for the metric and benchmark i get the output as the image attached (TimeOnSite)




      Which is how it should work.


      But when i use the same for a different metric with similar calculation and numbers, the result comes out to be less than 1 minute (which is correct) but then the difference it is showing with relation to the benchmark is different (check image - TimeOnPage)


      Can anybody please help me resolve this issue?