Planned and Unplanned System Availability

Questions & Answers
,
1

Hey team,

I have been asked to see if we can measure planned and Unplanned availability using EAZYBI.

I came across this thread which indicates yes.

I have followed the tops from @daina.tupule but now need to show the result as a percentage to 3 points.

In Cell Formatting Custom Formula I have tried the following formula:

sum(720/(720+Duration(hours)0 *100

To make the number a percentage, but it’s not working.

Can this be done for both Planned and Unplanned as I would like to show them as Gauge results for a dashboard of sorts.

Thanks in advance for any advice.

Regards

Dave

2

Hi @David_Horne,
​
If you want to show the result as a percentage with the precision of three decimal places, you might apply the following formatting
#.###%
​Please see below a screenshot of what to put in for the measure formatting and how that looks in the report.
​

measure formatting
measure formatting894×616 47.9 KB

​Regards,
​Oskars / support@eazyBI.com

3

Hi @oskars.laganovskis ,

Thanks for responding. I do not seem to have that option in the Cell Formatting Custom Formula.

To do it as a Calculated Member, what formula would I use to achieve that result?

Thanks again.

Regards

Dave

4

Hi @David_Horne,

This option is available for the calculated member formatting.
If you need to change the formatting for the default measure - you might create a new calculated measure with a direct reference to the original measure.

Please see the screenshot below.

Change formatting 2
Change formatting 21220×1308 84.6 KB

Regards,
Oskars / support@eazyBI.com

1 Like
5

Thanks @oskars.laganovskis ,
Solved. I was making it all too complicated.

Thanks again for your help.

Have a great weekend.

Cheers

Dave