Because proceed is only one by unique ID, and open has multiple,
I think Average of Open time - Proceed time works.
To calculate datetime value, need to convert and convert back between datetime and float.
Data sample_SM_10.5.twbx 44.5 KB
Thanks Shin that has helped a lot..
Follow up question, if i was aggregating the average time to open for a receiver ID across multiple email ids (100+), this would require averaging all of the avg time to opens. Any recommendation on how best to roll up this view?
As i am trying to explore receiver id's by;
- who receives most emails
- who opens the quickest
I don't have a good sample to attach presently, but hopefully it makes sense?