1 of 1 people found this helpful
The following formula should help get the desired outcome:
str(int([Time])) + ":" + str(([Time]%1)*60)
Hope this helps!
Thanks for passing this on. I got it to "work" but now what was previously a numeric measure is a character string and can not be included with my other summary measures.
It's an awesome and fairly concise solution, but this seems to be an unnecessarily complicated workaround. Are there any plans to have this type of conversion/formatting in future releases?
For context, I am replicating the Average Time on Page Metric from Google Analytics and I certainly wont be the first person that comes across this situation.