Table Visuals

A new table visual in Arcadia Enterprise displays the fields of the underlying dataset. A table may be sorted along any measure or dimension, and its cells may be formatted using format strings.

Tips:

The default table visual request selects only columns from the first table in a dataset with a join, up to the maximum number of columns specified in Table Style menu.

  • To change the maximum number of columns, see Specifying Maximum Number of Columns.
  • To show columns from other tables of the dataset, add them to the shelves of visual from the Dimensions and Measures of the Data menu.

The following steps demonstrate how to create a new table visual representation on a dataset World Life Expectancy [data source samples.world_life_expectancy]. For an overview of shelves that specify this visual, see Shelves for Table Visuals.

  1. Start a new visual based on dataset World Life Expectancy [data source samples.world_life_expectancy]; see Creating Visuals.
  2. Note that by default, the table shows all fields in the dataset.

    If your starting point is another visual type, then in the visuals menu find and click Table.

    selecting table chart type
  3. The shelves of the table visual are Dimensions, Measures, Tooltips, Filters, and Limit.

    There are no mandatory shelves; if nothing is specified on the shelves, all the columns appear in the visual.

    shelves of table visual type
  4. To show only specific items, populate the shelves from the available fields (Dimensions, Measures, and so on) in the Data menu.

    • Under Dimensions, select country and drag it over Dimensions shelf on the main part of the screen. Drop to add it to the shelf.
    • Under Measures, select life_expectancy and drag it over Dimensions shelf on the main part of the screen. Drop to add it to the shelf.
  5. Change the aggregate of the life_expectancy field from sum(life_expectancy) to avg(life_expectancy):

    • On the shelf of the visual, click the icon to the right of the field.

    • In the Column Properties menu, click the icon next to Aggregates.

    • From the list of aggregate functions, select Average.

      changing the aggregation to average
    • Click icon at the top of the Column Properties menu to close it.

    • Note that the shelf now contains the modified field with avg() aggregation function.

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

  6. Click Refresh Visual.

    The default table visual appears.

  7. Alias the country field as Country, and the life_expectancy field as Life Expectancy:

    • On the shelf of the visual, click the icon to the right of the field.

    • In the Field Properties menu, click the icon next to Alias.

    • In the text box under Alias, enter the alias name of column, as it should appear in the visual.

    • Click icon at the top of the Field Properties menu to close it.

    • Note that the shelf now shows the column with its alias name.

  8. On the Filters shelf, 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 un_region and year fields onto the Filters shelf.

    Set un_region to Americas; it should appear as un_region in ('Americas') on the Filters shelf.

    Set year to 2001 through 2010; it should appear as year in (2001,2002,…,2010) on the Filters shelf.

  9. [Optional] Change the value on the Limit shelf to another number, such as 12.

  10. Change the title to World Population - Table.

    • Click (pencil icon) next to the title of the visualization to edit it, and enter the new name.

    • [Optional] Click (pencil icon) under the title of the visualization to add a brief description of the visual.

  11. At the top left corner of the Visual Designer, click Save.

    clicking to save
  12. At the top left corner of the Visual Designer, click Close.

Your visual should look something like this:

table visual