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 - Analytics+ will automatically plot a deviation
Click Customize 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 also display deviations with labels positioned either at the top or along the side. Select the Top view or Side view option then click the start and end bars to plot the 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.
Analytics+ plots Deviation lines based on their axis number order. If you apply filters on axis categories, this may lead to rendering unexpected deviations.
In the animation, notice how Analytics+ automatically re-renders the deviation based on the available axis categories:
Enable the Use id toggle if you do not want your deviation to change dynamically. The deviation line between February and September will be removed when you apply filters.
You can set the font color and font size. To set a custom font color, disable the Auto color toggle.
Plot the deviation label at the top or position it to the side of the deviation line.
You can plot a rectangular or elliptical border around the deviation.
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. You can customize the thickness of the lines.
Highlight the starting point of the deviation connector line.
Show in percentage points (pp)
Depict the deviation value in percentage points when the scaling for your data is set to percentage.
Show in basis points (bps)
Depict the deviation value in basis points when the scaling for your data is set to percentage.
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.
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.
Plotting the CAGR in charts helps gauge the growth of an investment or business over a year or over a period of time without being distracted by individual fluctuations.
Enable the toggle to plot CAGR. You can assign colors to represent positive and negative CAGR values.
You can plot CAGR between custom axis points by specifying the start and end index. Analytics+ plots CAGR between the first and last points by default.
Specify the time period for which to plot CAGR: Year/Quarter/Month/Day/Hour. For non-date dimensions, select Points.
Analytics+ plots CAGR lines based on their axis number order. If you apply filters on axis categories, this may lead to rendering unexpected CAGR lines. Enable the Use id toggle if you do not want your CAGR to change dynamically.
You can set the font color and font size. To set a custom font color, disable the Auto color toggle.
Set a rectangular or elliptical border for the CAGR value.
Choose between border only, background color only, or border + background color to highlight your CAGR values.
You can additionally set custom border and background colors and specify the opacity for the background color.
Use a solid, dotted, or dashed connector line between the first and last CAGR points. You can set the thickness of the line as well.
Specify an optional offset between the chart and the CAGR line for enhanced readability.
Enable number formatting to specify a custom precision.
