When you fill in a measurement, it is checked whether it falls within the bandwidth. This can help prevent mistakes. For example, this makes it easier to notice if you entered a zero too much or too little.
This bandwidth is determined as follows: over the past three years, the value you entered in the same period is checked. The highest and the lowest of these values are used to determine the bandwidth. The lowest value indicates the minimum of the bandwidth and the highest value the maximum. Both the minimum and the maximum are further relaxed with a percentage. This percentage is 50% by default and can be changed in the account settings.
An example
The gauge Fuel Consumption has the following measurements:
| S1 2016 | S2 2016 | S1 2017 | S2 2017 | S1 2018 | S2 2018 |
| 100 | 110 | 120 | 130 | 140 | 150 |
When you fill in the first semester of 2019, we use the first semester of the past 3 years, in this case: 100, 120 and 140. 100 will be used as minimum and 140 as maximum. When the percentage of 50% is applied on these values, we get a bandwidth of 50 (100 - 50%) to 210 (140 + 50%). If the value you enter is not between 50 and 210, you will see a warning:
You can choose to save the value anyway. If you do this, a warning will be shown on the validation pages. You will also be shown which values were outside the bandwidth in the consumption table of the reports.
In the example below you can see that the value 25,902 has more deviation then the values in the last three years.
0 Comments