Skip to Content
Dec 21, 2016 at 10:26 PM

How to display seconds in timestamp format hh:mm:ss as measure in Design Studio Application



We have a requirement to show Average Wait Time for answered calls for each time interval for a our Call Center. We are adding this measure in our Design Studio Dashboard application. Avg Wait time is a calculated field where the result is in seconds, we were able to convert this already to hh:mm:ss format (concat) in the universe level and set this as a measure. When we bring this measure in to our DS application, value is 0. We need to show this as a measure to line up with rest of our measures; Incoming Calls, Answered, etc. How can we keep this as a measure with the hh:mm:ss format?

Thank you in advance for any help and suggestions.