Hello there,
First, here is a little bit of context for you.
We have a product where we can see some tickets coming from the back-end system.
Each ticket contain an information that means for how long the ticket has been in the system in minutes.
When the ticket has been handled, we close it using a button (tracked with an event).
Now, i've been asked if it possible to know the average time it took to close a ticket in our Adobe Workspace.
So, at first i was thinking that using a Calculated Metrics wich could be some thing like that :
= ((Dimension value = 1 * number of occurences of that value)+(Dimension value = 2 * number of occurences of that value)) / Total of occurences
The thing is that dimension could return me an infinite (ish) numbers of value (as we can have ticket solved in 2min or in 2880min (2 days), and if we look at the calcul that i thought about, i would have to create 2880 items in my calculated metric (No thanks!).
Do you have any idea to do that and be able to display that information in Adobe Workspace without having to export the data and then import it in Adobe ?
Thanks a lot for your time and help !