Forum Discussion
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 advi...
Shaurya
Memorable Member
Memorable MemberHi 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