cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Regular Visitor

Percent time of day queries run

I am trying to create a table that shows how much (percent time) of the day that a server is being used to execute queries. I have a table that has start and end time columns of query executions throughout each day rounded up to the minute and I also have created a table that has every minute of date and time possible in each day. I have attached what I am hoping the chart will look like, but I am not sure how to create it, I am still fairly new at power BI so any help is appreciated. Thanks friends. 

 

Snapshot.PNG

1 ACCEPTED SOLUTION

Accepted Solutions
Highlighted
Regular Visitor

Re: Percentage of daily query execution time

What I ended up doing was counting the number of 5 minute periods compared to how many 5 minute periods are in a day to figure it out.

View solution in original post

4 REPLIES 4
Highlighted
Super User IV
Super User IV

Re: Percent time of day queries run

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

 

I think an approach very similar this file will be needed

https://www.dropbox.com/s/bqbei7b8qbq5xez/leavebetweendates.pbix?dl=0



Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!
Dashboard of My Blogs !! YouTube Channel !! Connect on Linkedin

Proud to be a Super User!

Highlighted
Regular Visitor

Re: Percent time of day queries run

Here is the example of what the date data looks like, I want to be able to see out of a given day, how much time is within these ranges and how much is not. 

 

Snapshot.PNG

Highlighted
Regular Visitor

Re: Percent time of day queries run

I tried using the example that you posted chaning the values to my data and it just gives me the count of 1 for each day. Any other ideas? 

Highlighted
Regular Visitor

Re: Percentage of daily query execution time

What I ended up doing was counting the number of 5 minute periods compared to how many 5 minute periods are in a day to figure it out.

View solution in original post

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Tech Marathon

Maratón de Soluciones de Negocio Microsoft

Una semana de contenido con +100 sesiones educativas, consultorios, +10 workshops Premium, Hackaton, EXPO, Networking Hall y mucho más!

Top Solution Authors
Top Kudoed Authors