Forum Discussion

zero's avatar
zero
Regular Visitor
3 years ago

Downtime Hours, Open/Close Dates Visualization

Hi all,

 

Trying to get downtime (in hours) data below in a Table & Line/Bar Visualization by Month & Quarter. Struggling a bit to get an accurate representation due to dates. Could you please advise on best solution.

 

 

Data Sample:

 

 

Need Help

2 Replies

  • Shaurya's avatar
    Shaurya
    Icon for Memorable Member rankMemorable Member
    3 years ago

    Hi zero,

     

    Create a date table if you don't already have one. Add columns in that for Month Year and Quarter. Join the Date in your date table to Completed Date and then you'll be able to add a table visual or line chart with Downtime and Month/Quarter.

     

    Mark this post as a solution if that works for you!
    Check out this post of mine: Forecast Period - Previous Forecasts 
    Spare some time to read: How to Export Telemetry Data from Azure IoT Central into Power BI 

  • Mikelytics's avatar
    Mikelytics
    Icon for Resident Rockstar rankResident Rockstar
    3 years ago

    Hi zero ,

     

    I thikn the challenge is more on how to asssign the downtimes on the timeline since there is the start, the end and the dates in between. So where to put the duration to? Here is an approach how I would do it.

     

    In this case I would create a fact table with granularity item/date and then calculate the duration per item per day (see below)

     

     

    BAsed on a table like this you can easily build a column, line-chart or matrix with the actual downtime by quarter and by month.

     

    Best regards

    Michael

    -----------------------------------------------------

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

    @ me in replies or I'll lose your thread.