Converting seconds to 'hh:mm:ss' format is not working properly
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)
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)
I am working with a metric in seconds(session duration) which is in the numerator and the Sessions in the denominator which is just a count of sessions across which the session duration is being measured.
Yes, the desired output, which is expected with this KPI is the difference between the benchmark (i.e. 00:02:22) and the current value of the metric (i.e. 00:00:51) i.e. 00:01:31 or -00:01:31 or 91 (Something like this would do)
If I understand correctly, your calculation returns something negative. If you want to show a negative time span (or in general a time span), you need to use Interval() instead of Time(), just as Jonathan said.
Can you double check using a different chart object that Interval() is not working as expected? I don't know your extension object, so just make sure that no format option included with the extension object is messing up with the expression format.
It is not allowing me to work on the difference it is showing under target mode or maybe i am doing something wrong to calculate it. The numbers by themselves look alright its just the difference that is not working correctly.