Delta column

Let us create a column of a “Delta” type. Choose the type and click an «ОК» button:

In a column field two new fields – “Actual” and “Target” appear. Let’s choose a “Reseller Internet Quantity” measure for real values (actual), and a “Reseller Order Quantity” measure will be a target. We will get a new column, which will show a delta value and its indicator:

A delta value type may be the following:

• Actual value – an actual measure value;
• Absolute variation – difference between an actual and a target;
• Percent variation – percent of difference between an actual and a target;
• Percent of target – percent of an actual and a target;
• Target value – a target measure value.

An indicator may have the following value:

• Greater is good – «good» a target is achieved (an actual is bigger than a target);
• Less is good – «bad» a goal is not achieved (an actual is less than a target);
• Warning if greater – a target is bigger than an actual;
• Warning if less – a target is less than an actual;
• No indication – indication is not displayed.

For the delta, you can set the threshold value, which will indicate the excess of the actual above the target.

The threshold can be of the following type:

Let’s get back to our grid and see if the target is achieved as a percentage. For this, let’s fill out the form as follows:

As a result, we will see a delta column in which all the values exceeding the target are highlighted with a green indicator, and the red values are those that have not reached a target:

Obviously, the target was achieved only for “Accessories” category. The delta value can be displayed not only as text, but also as a diagram: