Shared Mailbox Analytics - Average response time and number of email responses by agent

Hi,

I never knew that you can import Exchange data but really interesting.

I just tried this on my side and in order for you to do what you mentioned, you'd firstly connect and import the Mail table.

Once you've imported the mail table, go to the attribute column and expand the "InReplyTo" field.

That field is the ID of the email that is being replied to.

Close and Apply.

Then if you want to see some stats, these are my suggestions.

Make a Dax column that works out the time taken to respond to the initial query. If you send automated responses then you may need to index the responses and remove the first one to see the actual response email's time.

Then I'd suggest just making a simple measure which is something like avg(<field you made to see the time difference>)

Let me know if this helps?