Trellis Chart (Grid)

Web map backgrounds (e.g., Google Maps) cannot be used in Trellis-type charts.

In some cases you may want to create a grid of charts, where different charts represent different values of a particular dimension (‘Region’ and ‘Category’ in the chart below).

What is a dimension?

A dimension is used to break-down the dataset into multiple groups, often within a Crosstab, Chart, or Selection List. Adding a dimension to the ‘X’ region of a Chart distinguishes the different dimension groups by location on the X-axis. Adding a dimension to the ‘Y’ region distinguishes the different dimension groups by location on the Y-axis. You can add multiple dimensions into the ‘X’ or ‘Y’ regions of a Chart, or into the ‘Rows’ or ‘Columns’ regions of a Crosstab, to create multiple grouping levels. You can also distinguish groups in a dimension by using color, shape, size, or label in a Chart.

chart2 1

To create a grid of charts, simply add dimensions into the ‘X’ and ‘Y’ regions to create the desired arrangement. For example, to break out the ‘Region’ dimension on the X-axis and the ‘Category’ dimension on the Y-axis, place these fields as shown below in the Chart Editor.

If you are new to charting, see the following sections first:

Configure Your Data…​

The data source for the chart (data block or data model) should represent dimensions and measures as independent columns or fields, as shown below. See Prepare Your Data for information on how to manipulate your data, if it is not currently in this form. (Note: A properly designed data model will already have the correct structure.)

dataStructureCharts

In some cases (e.g., Pie Chart), you may want your data to provide just a single measure. In other cases (e.g., Line Chart), you may want the data to supply multiple measures. If the data does not provide the correct number of measures, you may be able to alter the number of measures to suit the needs of the chart by “pivoting” or “unpivoting” the data. See Pivot Data in Prepare Your Data for more information about this procedure.

Open a Chart for Editing…​
Watch Video: Create a Chart (Open the Chart Editor)

This video might show an earlier version of the feature or operation that differs in minor ways from the current version.

Follow the steps below to get started with a new Chart. See Basic Charting Steps for more details.

  1. If necessary, create a new Dashboard. (See Create a New Dashboard.)

  2. From the Toolbox panel, drag a Chart component into the Dashboard.

    addingChart

  3. Resize the Chart as desired by dragging the handles.

    resizeChartHandle 1

  4. Press the ’Edit’ button in the center of the Chart or press the ‘Edit’ button edit in the top-right corner.

    ChartEditButton

    This opens the same Visualization Recommender available for creating a new Dashboard. (See Create a New Dashboard.)

  5. To bypass the Recommender, press the ‘Full Editor’ button edit at the top right to open the Chart Editor.

    ChartEditorIntro

chart3 1

Explore More…​

The sample Mortality Analysis Dashboard provides an example of a grid of pie charts.

galleryGridOfPie2

To explore this sample Dashboard, download and import the Mortality Analysis Dashboard into your environment. (This requires access to Enterprise Manager.) See Import and Export Assets for instructions on how to import.

The sample Marketing Lead Trends Dashboard provides an example of a grid of line charts.

galleryMap2

To explore this sample Dashboard, download and import the Marketing Lead Trends Dashboard into your environment. (This requires access to Enterprise Manager.) See Import and Export Assets for instructions on how to import.