5.7. Inline charts

Analytics+ provides data visualization at every step. You can insert inline charts in tables to visualize your measures. The data table supports win-loss charts, lollipop charts, and waterfall charts.

1. Inserting a chart

With Analytics+, you can insert a chart in a single click. All you need to do is, select the measure and choose the type of chart required for your data.

2. Configuring a chart

You can customize the chart by configuring the canvas and data labels. Select the column containing the chart - the configure button gets enabled.

2.1. Canvas

You can use the options in canvas settings to set the appearance and styling for the chart.

i) Fill pattern

You can set the fill pattern to any of the three IBCS notations: Solid, Hatched, or Outlined.

ii) Positive/Negative

You can set the color scheme for positive and negative values.

iii) Padding

You can adjust the spacing between bars by setting the padding - it is set to 0 by default. In the example, notice how the spacing between the bars has increased on increasing the padding.

v) Flip column

Enable the Flip column option to create a mirror image of the chart.

vi) Reset Canvas

You can click on this button if you want to remove all custom configurations and reset to default settings.

2.2. Data label

You can customize, enable, and disable data labels.

i) Data label

The data label checkbox needs to be ticked for data labels to be displayed. Uncheck to remove data labels.

ii) Bar overlap

When this property is enabled, the data labels will be superimposed on the bar. By default, this option is not enabled and the data labels are displayed next to the corresponding bar.

iii) Value display

You can choose to display the actual value, the percentage with respect to the total, or both.

3. Removing a chart

Click on the button with the 1.2 symbol to remove an inline chart.

Next, we'll look at manually setting the width for columns.