This How-to Paper provides guidance on how to display a deviation in a table in the SAP Analytics Cloud in conformity with the International Business Communication Standards. This type of visualization is very useful because you can visualize a table together with a bar/column chart. The possibility of combining two different forms of data analysis/visualization in a table shows an enormous efficiency increase and simplification of the reporting itself.
1.Create a Table with at least one measure
2.Switch to fullscreen mode for a better overview of the table
3.Select all Measures and Dimensions you want to visualize in the Table
4.Select a Measure you want to Visualize as an In-Cell chart in the table
Right-click on the measure column or row header in the Table and Select the In-Cell chart option. Each cell in the table of the selected measure displays a bar and a value.
Now as you can see the measure is converted into Chart inside the Table.
If you want to hide the bar chart just repeat the 4th step à right-click the measure header again and click on In-Cell chart.
right-click on the In-Cell chart to access the context menu where you can do some more adjustments like inserting a filter, setting new thresholds, or sorting the chart
7.Changing bar chart to a variance chart
Click on the column which includes the bar chart and open the builder. Select “Comparison” under the “Chart Structure”-Menu and select “Variance Bar” or “Variance Pin”.
All in all, the possibility to visualize deviations within a table is a very useful tool which can also be implemented very easily and quickly. The biggest advantage is that the conventional view of a table can be upgraded by a graphical representation and thereby the data evaluation can be displayed more efficiently.
If there are any uncertainties on this topic, I would be glad to receive your questions in the comments.
Please leave a Like if you found this blog post helpful.