Downtime Hours, Open/Close Dates Visualization

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.