Visualize hourly query counts and highlight peak/off-peak hours

[Rohitb]

Hello,

I have a log table which showcases the number of queries executed like below.

Here, the column "Event Time" has a data in date time field (with seconds included as well).

I have a requirement to create visuals to display the number of queries executed per hour in a database for a specific day. Identify the hour with the highest number of queries and the hour with the lowest number of queries executed

What can be the best way to achieve this ?

[PabloDeheza · Accepted solution]

Hi @Rohitb!

You can achieve this by creating a Date and a Time table. This way you can filter the log table by day and time independently. The pbix I share has the Power Query code needed to create both Date and Time tables. After that you need to split the DateTime column from your Log table into Date and Time. After that the last step is creating the relationships between Log[Date] - Date[Date] and Log[Time] - Time[Time].

Following those steps will allow you to create the visuals that you need to identify the hours of most executions as shown below.

I share you the link to the .pbix file: Queries 

Let me know if that helps!