3.7. Deviation
Last updated
Last updated
In data visualization, showing the deviation or the difference between two axis categories is essential in evaluating performance, identifying anomalies, and for subsequent planning. Analytics+ provides built-in options like First to Last, Min to Max, and Penultimate to Last which you can apply in a single click. You can also set a custom deviation and add more than one deviation line. Let's jump in.
You have two options to display the deviation:
Click the deviation button to show the deviation between the minimum and maximum values.
Click on Customize deviation to open Deviation settings and turn on the Show deviation toggle.
After plotting the first deviation line, you can use the Add deviation option to plot additional deviation lines. Click on the start category and end category bars to plot custom deviation lines.
You can choose the categories between which to display the deviation. You can also set the color for positive (default: green) and negative (default: red) deviation from the display section.
Analytics+ allows you to specify a custom deviation if the built-in options do not meet your requirements. You can specify the measure and indexes of the categories for which the deviation should be plotted. In the example, we have plotted a custom deviation line between the January and June bars.
You can also choose the Create your own display option to plot a custom deviation line. After choosing this option and clicking Apply, click on the start and end bar to plot the deviation line dynamically.
You can select the Deviation between groups option to show the deviation for measure groups within each category for cluster column charts.
The deviation can be displayed as a percentage or the actual difference in value. You can also opt to display both.
You can set the font color and font size. To set a custom font color, disable the Auto color toggle.
You can highlight the deviation by setting a border, background color, or both. If you are using a background color, you can also calibrate the transparency.
You can denote the ends of the deviation line with dots or a bar instead of the default arrow marker.
Choose between Solid, Dashed, and Dotted styles for the deviation line.
Value/Percentage
When number formatting is enabled, you can specify the decimal precision for the value and percentage. Additionally, you can set the scaling factor (thousands, millions, billions, etc) and provide an optional suffix/prefix.
Include signs at extreme
When this option is enabled, the sign of the deviation will be displayed before any prefixes. Notice how the positive sign is displayed before the dollar symbol after enabling the Include signs at extreme option. When this option is disabled, the positive sign will be positioned after the prefix.
