Could you please tell me how to calculate session duration in Qlik Sense. I am checking Sessions log file. It's having Session Duration as a field and it's giving value something like this. 3.939074. I want to show it in hrs:mm:ss format.
Saw this unanswered post when looking for something else. The data is available in the operations monitor as [Session Duration] the value is in days. You can divide the value by 1440 to get the minutes. a value specific for a month can be like interval(Sum({<Month={"Jul 2022"}>}[Session Duration])/1440,'DD hh:mm:ss')
