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
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)
Average in Excel=1:23:44 showing correct
But iam not getting this value in qliksense
Seems to be working for me
Retrieving data ...