10-27-2017 01:50 AM
I have following website visitor data:
avgsessionduration (in seconds but in numeric format)
+ dimensions like 'campaign' and 'ad'
As the idea is to report avgerage sessions duration by 'campaign', I have created 'weighted average session duration' (as the avgsessionduration is already aggregated): 'sum of avgsessionduraton weighted values' / 'sum of sessions'
Now I have time weighted session duration in seconds, but it's a numeric value. How to convert this value to time format?
I know how to convert the original measure 'avgsessionduration' to time format by creating a new calculated item, but I can't figure out how to use the calculated item in the 'weighted average session duration' calculation. Nor I cannot convert calculation afterward to time format.
11-10-2017 02:55 PM - edited 11-10-2017 02:56 PM
maybe this might help.
Create another calculated item being a time variable and use the following function.
Now just calculate the Hour/Minutes/Seconds form the previous calculated seconds variable.
greetings and good luck