Split TimeOnSite string into FocusedTime and SpentTime

Question

I found on the support pages that the TimeOnSite field is reporting Spent time and Focused time separated by a pipe (|). I have tried many attempts to split this in the survey flow embedded data block, but nothing seems to work. ChatGPT and Bard also suggested to use Java Script in a text question or a calculated field in the survey flow, but those do not seem to be available options on the Qualtrics Employee platform. Has anyone had any luck with trying to separate TimeOnSite into two fields? We would like to use this field in dashboards to report on site intercept stats.Support Page

NZungia · Accepted Answer

Hi @LaurenR-- I’m unsure if this will work for your use case but I did manage to find a solution. Here’s my processAdd in an appropriately named embedded data field to the intercept(s) the Survey is attached to.Set the value of the above embedded data field to "Time Spent on Site."Add an embedded data field to the Survey Flow whose name matchesexactlythat of the embedded data field in the intercept(s). (I.E. , if the Intercept EDF is called "SiteTime", the EDG in the survey must also be SiteTime)Add two EDFs in the survey flow beneath SiteTime and call them "TimeSpent" and "TimeFocus".Add Javascript to the first question the respondent sees (it is best if this is a forced response question).In the Javascript dialogue, replace the default script with the script below:Qualtrics.SurveyEngine.addOnload(function(){//Place your JavaScript here to run when the page loads//Javascript for splitting Time Spent/Focus on Sitevarstr = "${e://Field/SiteTime}";var res = str.split("|");Qualtrics.SurveyEngine.setEmbeddedData('TimeSpent', res[0]);Qualtrics.SurveyEngine.setEmbeddedData('TimeFocus', res[1]);});Qualtrics.SurveyEngine.addOnReady(function(){/*Place your JavaScript here to run when the page is fully displayed*/});Qualtrics.SurveyEngine.addOnUnload(function(){/*Place your JavaScript here to run when the page is unloaded*/});Publish your survey.Test and verify that the fields are populating as intended.

NZungia · Answer

Hi @LaurenR-- Did you end up finding a solution?I’m currently trying to solve the same problem and will report back with any updates.

Sign up

Login to the Community

Scanning file for viruses.

This file cannot be downloaded