Forum Discussion
Helper ICount emails sent during non-working hours
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?
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.
3 Replies
- amitchandak
Super User
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.
- v-janeyg-msft
Community Support
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.
