We use cookies on this website to give you the best possible experience. To find out more and to stop cookies please go to our cookie policy.

Search English Portugese French

Support Request

Thank you for your request. We will get back to you shortly.

Latest Articles

Setting Tolerance ranges

Posted 22nd January 2014. Last Updated 18th February 2015


This article will show you how to set 'Tolerance Ranges' for 'Forecast KPIs'.


Setting Tolerance Ranges

For Period KPIs, you need to define Tolerance 'Ranges' to define the point at which the result is acceptable.

This involves using the colour scale under 'Indicator Type'  

(This is different to Process KPIs where you define 'Upper and lower ranges' )



The Colour Scale

The left side of the scale is your 'Actual' against your 'Process Range'.

This is represented by the KPI Bubbles on the Dashboard.




The right side of the scale is your 'Forecast' against your 'Budget'

This is represented by the Client Range Boxes on the right of the Dashboard.




Variable - Forecasted 

'Variable - Forecasted' uses your forecast for the month to calculate the Tolerance range.

Using the scale below, if your forecast is 200 for the month, and the Actual is 194, the bubble will be green.

This is because the Actual is   >   Not more than 10% above the forecast to become blue. 

                                                       >   Not less than -5% to become yellow.



'Variable Forecasted' is particularly useful if the values are high because of its simplicity.

Tip : You do not need to a value in the 'Reference Value'



Variable - Minimum 

If your forecast is sometimes very low, the tolerance range will be very tight and therefore not be very meaningful.

Therefore to combat this, we can set a 'minimum' value.

For instance, if our forecast was 10, less than our Minimum of 90, the Minimum value will be used to calculate our Tolerance Ranges 

Using the example below, the 'blue tolerance' would be anything above 9. 



If our Forecast was 200 for the month (which would be higher than the minimum value) the Forecast would be used to calculate the Tolerance Range (Same as Variable-Forecasted)

Therefore, this is the recommended option to use.



Unlike 'Variable Forecasted' and 'Minimum', 'Fixed' does not use the forecast to calculate the Tolerance ranges.

Instead it uses the same 'Fixed' number each month.

To work out the ranges, you simply divide the Fixed value (which you insert in the 'Reference value' box) by the numbers in the colour scale.


For instance, if your Fixed Value is 80, any result will turn blue if the 'Actual' is 8% above your forecast.




If your Actual is 10, it will be more than -20% outside of your forecast and therefore it will turn red.

Fixed is particularly useful if your forecast does not fluctuate too much due to its simplicity.

Did this article solve your problem?

Related Articles

< Back