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.
![](https://uploads-us-west-2.insided.com/qualtrics-us/attachment/1a9a6fdc-2095-4acb-996d-34a020b12dde.png)