Report to show monthly uptime % over past 12 months

Questions & Answers
1

I’m trying to create a report which shows the monthly Uptime % over the past 12 months, using the correct number of minutes in each month. I’ve created 3 measures that calculate the Uptime based on a month with 28/30/31 days (i.e. ((43200-[Measures].[Downtime in Minutes])/43200)*100), but what I ideally want is a report that works out how many days there are in a given month and make the calculation on that basis for that month. This is what I’ve done, but obviously don’t want the report to show the Uptime % that is not relevant to that month

image

2

@dwightman

Try this code when creating a new user-defined calculated measure to return days in a displayed month for report rows

Datediffdays(
  [Time].CurrentHierarchyMember.StartDate,
  [Time].CurrentHierarchyMember.NextStartDate
)

I guess that would let you keep just one column in your report for Uptime calculations

Martins / eazyBI team

image
image1422×1194 148 KB

1 Like