Report to show monthly uptime % over past 12 months

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



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


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

Martins / eazyBI team

1 Like