Count emails sent during non-working hours

[caznaran]

Is there a way to obtain the number of emails being sent during non-working hours in a Microsoft 365 tenant?

We're aiming to create a Digital Disconnection score to count emails that shouldn't be sent until next day for reliefing the stress of the team.

Is there any standard Microsoft 365 database I can use for this query?

[v-janeyg-msft · Accepted solution]

Hi, @caznaran 

If you are using Outlook mailbox, you can get the corresponding data through the PBI connector, then you can count the data you want.

Like this:

If it doesn’t solve your problem, please feel free to ask me.

Best Regards

Janey Guo

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@caznaran , This video talks about how to deal with business hours. See if that can help to get opposite of it https://exceleratorbi.com.au/calculating-business-hours-using-dax/

Can you share sample data and sample output in table format? Or a sample pbix after removing sensitive data.

[caznaran]

Thanks for the help. I actually want to know if there is a datasource (like O365 Analytics) for all emails being sent from a tenant. I do not want to read the contents but just basic stats like number of emails sent during non-working hours.