How to add a DateTime to Microsoft 365 Usage Analytics

[extrasiyf]

Hello, 

How can I add a DateTime to a report in Microsoft 365 Usage Analytics to filter number of emails by DateTime. 

Thanks,

[v-rzhou-msft]

Hi @extrasiyf 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[v-rzhou-msft]

Hi @extrasiyf 

You may try to build a slicer in your report to filter the number of emails as below.

Best Regards,

Rico Zhou

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

[extrasiyf]

@v-rzhou-msft 

Thanks for response, but I want to filter my emails by Time for example to count the number of emails beetween 18AM & 24 PM, not just by Date.

[v-rzhou-msft]

Hi @extrasiyf 

Due to we couldn't build measures or calculated columns in Power BI Service, you may need to build an hour column by hour function in Power BI Desktop.

And use this column to build a slicer to count the emails between 18 & 24.

Hour = HOUR('Table'[DateTime])

Build a card visual and use count function in it.

Best Regards,

Rico Zhou

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

[extrasiyf]

@v-rzhou-msft 

The probleme there, there is no field DateTime, there is just Date no field for time in Usage Analytics. 

[v-rzhou-msft · Accepted solution]

Hi @extrasiyf 

If you get Microsoft 365 Usage Analytics as an app in your Power BI Service, you will find a workspace with same name as this app.

My app:

My worksapce:

You can download your report as a pbix file in your workspace and then transform your report with measure or calculated column in your Desktop. Then you need to publish the new report again into the workspace and update your app.

Best Regards,

Rico Zhou

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

[collinq]

Hi @extrasiyf ,

THis link shows you how to customize the report:

https://docs.microsoft.com/en-us/microsoft-365/admin/usage-analytics/customize-reports?view=o365-wor...

I would appreciate Kudos if my response was helpful. I would also appreciate it if you would Mark this As a Solution if it solved the problem. Thanks!