Pivot table

    A pivot table displays data in tabular form, where rows and columns contain source values, and the cells at their intersections contain the resulting values.

    Pivot tables make it easier to work with large amounts of data and let you analyze the relationship between different measures.

    pivot_table

    For example, you can use this type of table to analyze accommodation type revenue by borough over a specific period.

    1. Open the All workbooks overview page and select your workbook.

    2. Open the dashboard to which you want to add a chart.

    3. In the upper-right corner, click Edit.

    4. Click AddChart (Wizard). You'll see the chart creation wizard.

    5. On the top left, select the Dataset you want to visualize.

    6. Click the chart type field on the right of the dataset section and select Pivot table from the drop-down menu.

    7. Drag and drop Measures and Dimensions to the appropriate sections of the chart (see the Data fields tab).

      Your chart creation wizard should look similar to the following:

      pivot_table-wizard

    8. Click Save in the upper-right corner of the page.

    9. Name your chart and click Done.

    10. Choose the appropriate location for your chart by dragging it around the dashboard and resize it by dragging the lower-right corner of its frame.

    11. Click Save in the upper-right corner of the page.

    Wizard slot Description
    Columns Dimensions that are used as columns. Field name is used as the column heading.
    Rows Dimensions that are used as rows.
    Measures Dimensions or Measures.
    If you add more than one field to this slot, a Measure Names field will appear in the Columns slot. It defines the position of the value headers.
    You can move the Measure Names field to the Rows slot.
    Colors Dimension or Measure. Affects the fill color of all the cells in a the table.
    Sorting Dimensions or Measures from the Columns slot. Multiple-field slot. Affects the sorting of the table fields.
    Chart filters Dimension or Measure. Used to filter values.

    To open chart settings, click to the right of the chart type above the wizard slot fields. You'll see a dialog window with the following controls:

    Control Default state Description
    Header Off Displays the specified text in the centered line above the chart.
    Totals Off Adds a row with total values of columns.
    Old pivot tables Off Allows you to use an obsolete logic of pivot tables, without coloring or in-chart calculations. Disables the Totals setting.

    After managing the controls, click Apply to see the results on the chart preview.

    To open slot settings, click in a row with the slot name.

    Color:

    On the left, you can select a line from a data source in the Colors slot of your chart.

    On the right, you can select a color scheme and a color for the line. Select AUTO to let Visualization do the coloring for you.

    • Limit the size of a table, or use filters or sorting. It's hard to read tables with a large number of rows or columns.

    • You can color table cells depending on the values of a measure. This will emphasize them.

    • This chart type can't display NULL or negative values.