Forum Discussion
Shared Mailbox Analytics - Average response time and number of email responses by agent
Resolver IVI forgot to say but you can use the Power BI Path function to get the whole chain of mails in one column which would be really useful for this.
Good day, pbiuseruk.
Thank you for taking the time to respond. Greatly appreciated. I am working on it this week, so will respond back accordingly. As for the Path function, can you give me an example on how to use as I am not a PBI expert, but a newby.
Thank you,
- pbiuseruk
No problem and sure,
The path function works on parent-child relationships and can pull in the whole chain into one field value.
This is the documentation: https://learn.microsoft.com/en-us/dax/path-function-dax
This is an example: = PATH(Employee[EmployeeKey], Employee[ParentEmployeeKey])
In this example we'd replace the first parameter with id and the second parameter with the InReplyTo field. This will basically make a chain of ids that will lead to the ultimate parent like this:
emailid1, emailid2,..... emailid ultimate parent. This would be useful if you wanted to find out the time taken between any selected mail and the initial mail that triggered the chain.
What you could quite easily do with this is extract out the last emailid (which would be the parent email id and the first email as part of the chain). Then you can lookup that email id and pull back the timestamp for it. Then you can make a column or measure that would show the duration (current emails timestamp - parent emails timestamp).
Just some random suggestions but hope it helps.