Chart customization

Xsolla Advanced Analytics provides a variety of ways to customize charts according to your needs. This manual describes the basic methods.

To customize your chart, click the Edit button on the top right of your report and then click on the chart.

Add gridlines

  1. Go to the Style tab and select the axis:
    • To display horizontal gridlines, select Value Axis.
    • To display vertical gridlines, select Category Axis.
  2. Change the line color, width, and style by clicking the corresponding option under Grid > Major Gridlines or Grid > Minor Gridlines.
Note
For the value axis, it is possible to set Major gridlines and Minor gridlines.

Add 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.
  1. Select the type of a border you want to add:
    • To add an inner border, go to the Style > Plot Area tab.
    • To add an outer border, go to the Style > General tab.
  2. To change the line thickness, select a value from the drop-down list in the Background and Border Style section.
  3. Change the background color of the chart and the line style in the Background and Border Style section.

Customize axis labels

Axis labels are numbers that are evenly spaced along the chart axes to help the user to navigate the analyzed data. To add labels:

  1. Go to the Style tab and select the axis:
    • Category Axis
    • Value Axis
  2. Select the number format and the angle of the labels and change the font settings in the corresponding drop-down lists.

Change axis names

There are two ways to change the name of the axes:

  • Set the name manually
  • Use calculation

To change the name manually:

  1. Click the Style tab > Category Axis (or 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 if necessary.

To change the axis name using a calculation:

  1. On the chart settings panel, when adding or replacing a metric, click Add Calculation.
  2. ​​Enter your desired title in the top box and paste the previous metric name in the bottom box (no equal sign required).
  3. Click Done.
  4. Select the created calculation as a measure from the measure selection menu.

Change the axis scale to logarithmic

  1. Go to the Settings > Style tab.
  2. Check the Logarithmic scale box.

Display entire values in labels

By default, values like 2,000 display as 2K. To change the display type:

  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.

Display 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. Under Value Labels, switch the toggle to On. Labels will be added to each row in the chart.

Customize chart colors

  1. Select a chart in the report by clicking on it.
  2. Click Series Color in the Data > Colors menu and select colors from the drop-down list or from the RGB palette.

Set series to the secondary axis

When displaying two different measures on the same graph, the numbers can vary greatly. If you use the same scale, the difference between the small values will not be visible on the graph. To visualize the change in indicators in a better way, use the secondary axis to display smaller values:

  1. Go to the Style tab > Series 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 two chart types on one graph

  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.

Add distinct-count measures

Distinct-count measures are helpful when analyzing a dataset where the number of distinct elements in a dimension plays a significant role.

For example, you want to analyze data from an in-game store with a lot of purchases in order to know how many specifications each item on sale has. Add a column with a unique game item numbers as the metric and select the distinct-count as the aggregation type.

To add such metric:

  • Click Data tab.
  • Click Add Measure and select the Distinct count aggregation type.
Was this article helpful?
Thank you!
Is there anything we can improve? Message
We’re sorry to hear that
Please explain why this article wasn’t helpful to you. Message
Thank you for your feedback!
We’ll review your message and use it to help us improve your experience.
Rate this page
Rate this page
Is there anything we can improve?

Don’t want to answer

Thank you for your feedback!
Last updated: October 20, 2021

Found a typo or other text error? Select the text and press Ctrl+Enter.

Report a problem
We always review our content. Your feedback helps us improve it.
Provide an email so we can follow up
Thank you for your feedback!