Chart customization

Advanced analytics allows you to customize the display of the chart. The main ways of customization:

• adding grid lines
• adding borders
• axis labels customization
• axis names editing
• changing the axis scale to logarithmic
• displaying entire values in labels
• displaying values for series
• chart colors customization
• secondary axis adding
• displaying two chart types on one graph

• distinct-count measures adding

To customize your chart, click Edit in the top panel of the report and select the chart.

Adding grid lines

1. Go to the Style tab and select the axis:
   • Value Axis, to display horizontal grid lines.
   • Category Axis, to display vertical grid lines.
2. Change the line color, width, and style in sections:
   • Value Axis > Grid > Major Gridlines, to set the main horizontal grid lines.
   • Value Axis > Grid > Minor Gridlines, to set additional horizontal grid lines.
   • Category Axis > Gridlines, to set vertical grid lines.

Adding borders

You can add two types of borders to your chart:

• Inner border that frames individual graphic elements, for example, columns of a bar chart or sectors of a pie chart.

• Outer border that frames the entire chart along with the axis names and title.

To add an inner border:

1. Go to the Style > Plot Area tab

2. Specify the fill color, border color and line thickness in the Background and Border Style section.

To add an outer border:

1. Go to the Style > General tab.
2. In the Background and Border Style section, specify the fill color, border color, corner rounding, line thickness, and line style.

Axis labels customization

Axis labels are numbers located along the axes of the chart at an equal distance from each other and allow the user to navigate in the analyzed data. To add labels:

1. Go to the Style tab and select the Category Axis or Value Axis
2. Select the number format and the angle of the labels, change the font settings.

Axis names editing

You can edit the axis names in one of the following ways:

• change the name in settings

• change the name when adding a calculation

To change name in settings:

1. Go to Style tab > Category Axis or Style tab > Value Axis.
2. Check the Show Axis Name box in the Axis Name area.
3. Enter the axis name in the field that appears.
4. Change the font (optional).

To change the axis name using a calculation:

1. Select the chart and on the Data tab find the name of the axis you want to change.
2. Click the name and select Replace > Add Calculation from the menu.
3. Enter a new name in the top field and paste the previous measure name in the bottom field (no equal sign required).
4. Click Done.
5. Select the created calculation as a measure in the measure selection menu.

Changing the axis scale to logarithmic

1. Go to the Settings > Style > Value axis > Axis scale.
2. Check the Logarithmic scale box.

Displaying entire values in labels

You can round large numbers. For this:

1. Go to the Style > General tab.
2. From the Abbreviate Big Numbers drop-down list, select the type of abbreviation or disable this feature.

Displaying values for series

Value labels are numeric designations that correspond to the values of chart elements. They are needed to visually evaluate the metrics and compare them with each other. To add value labels:

1. Go to the Settings > Style tab.
2. In the Value Labels section, set the switch toggle to On. Labels will be added to each row in the chart.

Chart colors customisation

1. Go to the Data > Colors tab.
2. Choose a color setting option:
   • To color the chart with a single color, choose Color by > Single Color, then click Series Color and choose a color from the palette.
   • To color the data series in different colors, select Color by > Field, then select the measure and color palette in the Palette section.

Adding secondary axis

When displaying two different measures on the same graph, the numbers can vary greatly. At this scale, the difference between smaller values may not be visible on the graph. To better visualize the change in indicators, use an additional axis:

1. Go to the Style > Series tab and select the series you want to move to the secondary axis.
2. In the menu of the selected row, select To the secondary axis checkbox.

Display different types of charts on the same chart

1. Go to the Style tab > Series and select the chart you want to change the type of.
2. From the Show Series as drop-down list, select a new chart type.

Adding distinct-count measures

The Distinct count measure is useful when analyzing data sources where the number of distinct items in a dimension is important.

Example: You want to analyze data from an in-game store with a lot of purchases to find out how many of each item was sold. To do this, add a column with unique game item numbers as the measure and select the distinct-count as the aggregation type.

To add measure:

• Click the Edit button, select the chart and go to the Data tab.
• Click Add Measure and select the Distinct count aggregation type.

Last updated: January 22, 2024