https://community.qlik.com/t5/App-Development/QlikView-November-2017-Service-Release-7-now-available/m-p/1511593#M36479 Is your service availability different every month? And if so is it a field in your data model? Or do you know how to calculate your service availability?<BR /><BR />Whatever the case, as long as both values are properly formatted, you should just be able to divide downtime by service availability and set number presentation to %.<BR /><BR />So for a table with month as a dimension, your expression would be:<BR />Time(Sum(Downtime)) / [Service availability]<BR /><BR />Where [Service availability] should be:<BR />- A fixed number if it is the same every month: For example, Time('55:00') for 55 hours/month<BR />- A pick/match combo or lots of nested ifs (not recommended) for variable service availability<BR />- The average of the service availability if it is in a field in your data. This is assuming the service availability is the same for every record in the same month. Note that this does mess up your total<BR /><BR />If you need more help please post your application, if possible with sample data.<BR /><BR />Also, interesting title <span class="lia-unicode-emoji" title=":winking_face:">😉</span> Fri, 23 Nov 2018 14:04:02 GMT jensmunnichs 2018-11-23T14:04:02Z https://community.qlik.com/t5/App-Development/QlikView-November-2017-Service-Release-7-now-available/m-p/1511568#M36478 <P>Hello everyone,</P><P>Okay here is what I have been attempting to do, I have a field named Downtime which measures the time a service went down for - e.g 01:22&nbsp; (hh:mm) question is how to I convert this metric to an % of service availability per month.&nbsp;</P><P>Appreciate any help offered.</P><P>&nbsp;</P><P>Nev&nbsp;</P> Fri, 23 Nov 2018 13:33:07 GMT https://community.qlik.com/t5/App-Development/QlikView-November-2017-Service-Release-7-now-available/m-p/1511568#M36478 Anonymous 2018-11-23T13:33:07Z https://community.qlik.com/t5/App-Development/QlikView-November-2017-Service-Release-7-now-available/m-p/1511593#M36479 Is your service availability different every month? And if so is it a field in your data model? Or do you know how to calculate your service availability?<BR /><BR />Whatever the case, as long as both values are properly formatted, you should just be able to divide downtime by service availability and set number presentation to %.<BR /><BR />So for a table with month as a dimension, your expression would be:<BR />Time(Sum(Downtime)) / [Service availability]<BR /><BR />Where [Service availability] should be:<BR />- A fixed number if it is the same every month: For example, Time('55:00') for 55 hours/month<BR />- A pick/match combo or lots of nested ifs (not recommended) for variable service availability<BR />- The average of the service availability if it is in a field in your data. This is assuming the service availability is the same for every record in the same month. Note that this does mess up your total<BR /><BR />If you need more help please post your application, if possible with sample data.<BR /><BR />Also, interesting title <span class="lia-unicode-emoji" title=":winking_face:">😉</span> Fri, 23 Nov 2018 14:04:02 GMT https://community.qlik.com/t5/App-Development/QlikView-November-2017-Service-Release-7-now-available/m-p/1511593#M36479 jensmunnichs 2018-11-23T14:04:02Z