Hi,
The data on my adobe analytics platform is capturing the time spent on specific flows (hard coded before) as a dimension. So it shows that how many times xyz flow took 19 secs, 20 secs, 2300 secs and so on. I want to create this into a metric so that I can calculate average, median, mode etc for those specific flows. Any recommendations on how to do this the best way possible?
Thank you.
That is correct. Dimension values are always stored as strings. So even though you and I see "19 sec" and recognise it as 19 seconds, to AA, that is the string "19 sec" (like "one nine space s e c") and has no other knowledge of it aside from being a string of alphabets and numbers and punctuation.
If you need to report on time as a metric, you should change your implementation to track your time durations to a success event in seconds. Then, in Analysis Workspace, though that metric gets reported as an integer, you can create a Calculated Metric from it and format it as "Time" to get a more familiar hh:mm:ss format.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.