Cloudera Docs

Table

A Table visual displays the fields of the underlying dataset. It may be sorted along any measure or dimension, and its cells can be formatted using format strings.

The following steps demonstrate how to create a new table visual representation on the World Life Expectancy dataset. For an overview of shelves that specify this visual, see Shelves for tables.

  1. Start a new visual based on the World Life Expectancy dataset.
    For instructions, see Creating a visual. By default, the table shows all fields in the dataset. If your starting point is another visual type, find and click Table in the VISUALS menu.

    The shelves of the Table visual are Dimensions, Measures, Tooltips, Filters, and Limit.

    There are no mandatory shelves. If you do not specify a value in any of the shelves, all columns appear in the visual.

  2. To show only specific items, populate the shelves from the fields available in the DATA menu.
    • Under Dimensions, select 'country' and drag it to the Dimensions shelf.
    • Under Measures, select 'life_expectancy' and drag it to the Measures shelf.
  3. Change the aggregate of the 'life_expectancy' field from 'sum(life_expectancy)' to 'avg(life_expectancy)'.
    1. On the Measures shelf of the visual, click the caret-right icon to the right of the 'sum(life_expectancy)' field.
    2. In the FIELD PROPERTIES menu, click the caret-right icon next to Aggregates to open a drop-down menu.
    3. From the list of aggregate functions, select Average.
    4. Click the x icon at the top of the FIELD PROPERTIES menu to close it.

    The shelf now contains the modified field with the avg() aggregation function.

    Alternatively, you can change the aggregation at the level of the dataset, as described in Changing field aggregation.

  4. Click REFRESH VISUAL.

    The updated Table visual appears.

  5. Optional: To improve the appearance of the visual, alias the 'country' field as 'Country' and the 'life_expectancy' field as 'Life Expectancy'.
    1. On the shelf of the visual, click the caret-right icon to the right of the field.
    2. In the FIELD PROPERTIES menu, click the caret-right icon next to Alias.
    3. In the text box below Alias, enter the alias name of the column, as it should appear in the visual.
    4. Click the x icon at the top of the FIELD PROPERTIES menu to close it.

    The shelves now show the columns with their alias names.

  6. Optional: On the Filters shelf, you can add several Dimensions and Measures from the DATA menu.

    This enables you to dynamically control the data input and discover the data at a more granular level.

    For example, from Dimensions, drag the 'un_region' and 'year' fields to the Filters shelf.

    In this example, 'un_region' is set to 'Americas'. It should appear as un_region in ('Americas') on the Filters shelf. 'year' is set to '2001 through 2010'. It should appear as year in (2001,2002,…,2010) on the Filters shelf.

  7. Change the value on the Limit shelf to another number.
    In this example, the new value is '12'.
  8. Click REFRESH VISUAL.

    The updated Table visual appears.

  9. Click the pencil/edit icon next to the title of the visualization to enter a name for the visual.

    In this example, the title is changed to 'World Population - Table'. You can also add a brief description of the visual as a subtitle below the title of the visualization.

  10. At the top left corner of the Visual Builder, click SAVE.