Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I am trying for a expression someone can help me for taking Average for hh:mm:ss
I have converted Seconds to hh:mm:ss
Used expression Avg(waittime/3600)
In excel when we calculate its perfect but in qliksense getting a different average
Seems to be working for me
Would you be able to share the sample data you tried to work with in Excel?
i have converted seconds to hh:mm:ss using 3600
and applied Avg(waittime/3600)
0:00:00 |
3:35:12 |
0:36:00 |
Average in Excel=1:23:44 showing correct
But iam not getting this value in qliksense
Seems to be working for me