I did some testing and unfortunately, the functionality is that Time Spent On Site records two metrics: the Time Spent On Site and the Time Focused On Site (2358|2314). There isn't a way to alter this.
What i want to have is a split of "Time Sent On Site" and another one with "Time Focused On Site". In this way i'm able to use it in the dashboard. The ultimate goal is that i create buckets like this [1-2min], [2-5min],...
=IF([@[Time_Spent_onsite2]]>600;">10min"; IF([@[Time_Spent_onsite2]]>299;"[5-10min]"; IF([@[Time_Spent_onsite2]]>119;"[2-5min]"; IF([@[Time_Spent_onsite2]]>0;"[1-2min]";"[null]"))))
Question
Un-concatenate - Time Spent On Site records two metrics
Be the first to reply!
Leave a Reply
Rich Text Editor, editor1
Editor toolbars
Press ALT 0 for help
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.