4.4. Configure dimensions for charts

Analytics+ offers various options to plot your dimensional data. At the end of this section, you will be able to master the various configurations to calibrate your dimensions. Let’s dive in and add some visual parameters!

The Category tab of the pivot data window is where you can configure dimensions, we'll look at how to configure each section.

1. Convert measures into a category

When you have multiple measures in your report - each measure can be displayed in a separate pane by enabling this property. To see how this works, let's add 3 measures.

When we enable the Convert measures into a category option, a Measures Category is created in the Row bucket. The Combine row/column dimensions option is enabled default, let's disable it for now.

When we click Apply, each measure is displayed in a different row.

Let's see what happens when we drag the Measures Category into the Column or Legend buckets.

2. Combine row/column fields

When you have hierarchical dimensions, you can convert the Hierarchical trellis into a linear trellis by combining rows and columns.  Let's add the product and region hierarchies as shown. The region hierarchy is displayed as columns and the product hierarchy as rows.

When we enable the Combine row/column fields option, the hierarchies are flattened into a linear trellis.

3. Toggle Axis/Row/Column/Legend

4. Lock dimensions

5. Prompt on data assignment

Enable the Prompt on data assignment checkbox if you want the data configuration window to open automatically, each time you add a visual dimension.

6. Search and select

Analytics+ allows you to add a large number of dimensions to your visual. You have the flexibility to create ad-hoc reports from within the visual itself.

The Categories section enables you to manage multiple dimensions easily. You can

  • Select the dimensions to render using the checkboxes against each dimension.

  • Search for a specific dimension using the search bar.

Last updated