Properties - Dimensions

Vizlib Pivot Table supports an unlimited number of Dimensions.

This topic contains the following sections:

Adding Dimensions

  1. Click the Pivot Table to select and view its properties.

  2. Click the Data section of the property panel to view the Dimensions and Measures.

  3. To add a dimension, click Add or Add Alternative to add alternative dimensions that offer users different views of the data in one chart (Figure 1).

  4. To select a field for your dimension, click inside the expression field and either scroll down through the list or start to type the name of the field, as it features predictive search and will suggest field names as you type.

Figure 1: Selecting and adding Dimensions

When you add a dimension, click the arrow ( >) on the right of the dimension field name to view the dimension settings (Figure 2).

Applying Dimension Settings

Dimension settings include:

  • Entering a dimension Label for the Field.

  • Check the box to Include Null Values in the chart.

  • Set a Limitation on your chart data, choosing from a Fixed number (e.g. the top 10 values), the Exact value, or a Relative value (e.g. only showing values above 50%).

  • Set a Calculation condition using an expression to determine whether the dimension is displayed in the pivot table.

  • Set the Dimension Visibility.

Figure 2: Applying Dimension Settings

Setting the Dimension Position - Rows

The Dimension Position can be set to Rows (left) or Columns (top).

If you choose rows (Figure 3) to set the dimension to the left of the pivot table, you can customize the Styling by setting the Background Color, the Font Color, and the Left Column Width.

Figure 3: Setting the Dimension position - Rows

Setting the Dimension Position - Columns

If you choose to set the dimension position to Columns (Figure 4), this sets the dimension at the top of the pivot table. Other settings include:

  • Setting the Header Label Position.

  • Specifying Row Height.

  • Customizing the Background Color and the Font Color. Use the option for Dynamic Styling to apply different colors to dimension values.

Figure 4: Settings for using Dimensions position - Columns

Enabling Tooltips

Choose whether to enable Tooltips settings (Figure 5) for both columns and rows. Settings include:

  • Choosing to use Tooltip Content, set to Auto (displays field value as a Tooltip), or enter a custom Tooltip Value. In the example below, the tooltip value is set to 'Hi there,' which displays as a Tooltip.

  • Select the Tooltip Color for the background to the text color.

  • Enabling a Search Icon.

Figure 5: Enabling Tooltips and applying settings

Applying Dynamic Styling

Dynamic Styling allows you to apply a custom style to rows or cells within the pivot table using an expression.

At the top of this section, the expression from the field List value(s), displays as its name. Click the arrow ( >) on the right to view the Dynamic Styling settings (Figure 6). Click Add Condition to apply further conditional coloring based on other criteria.

Figure 6: Applying Dynamic Styling to your pivot table

Adding an Expression or List of Values

You can apply Dynamic Styling with a defined Field expression or add a List of Values... separated by a specific sign (the default is a comma). The sign that acts as the separator for your list of values is defined in the next field, Separator.

The full name for the list of values field is List of value(s), separated by a specific sign; the default is a comma. Click the expression button to view or edit the expression (Figure 7).

Although the default separator is a comma, you can use semi-colons, pipe ( | ), the back ( \ ) or forward ( / ) slash, and hyphens ( - ).

  • Example of an expression: =Concat(aggr(if(SalesOffice='Lund',OrderID),OrderID),',')

  • Example of a list of values: ='Total EBITDA,Total OpEx,Indirect OpEx,Direct EBITDA,Direct OpEx'

Dynamic Styling Settings

Style settings include customizing the Background Color, Font Color, Font Size, Font Style, and Border (Font Color and Border Size).

Figure 7: Applying Dynamic Styling settings

Totals and Formatted Export Settings

  • Slide the toggle to hide or display Totals (Figure 8); set the Total label if you display the totals.

  • In the Formatted Export Settings slide, the toggle to automatically Export to Excel.

  • Click the Delete button to remove the dimension from the pivot table.

Figure 8: Totals and Formatted Export Settings

With Vizlib Pivot Table v3.13.0, you can turn a dimension defined as URL into a clickable link. Previously, the software displayed the dimension URL as a plain text. If users wanted to open the URL, they needed to copy and paste the text from the app into a browser. With Vizlib Pivot Table 3.13.0 you can transform a plain text into a clickable link using the Cell text is URL option in the Dimension settings. When you enable the Cell text is URL option, you can further define the Link label by inserting a custom text that's displayed instead of the URL.

Note: If the Pivot Table is in the Indent Mode and the URL dimension is presented inside a tree of dimensions on the left, a link is clickable only if the last dimension of this tree is a URL.