Cross Tabulation Visuals

The following steps demonstrate how to create a new cross-tabulation visual on a dataset World Life Expectancy [data source samples.world_life_expectancy].

1. Start a new visual based on dataset World Life Expectancy [data source samples.world_life_expectancy]; see Creating Visuals.

2. In the visuals menu, find and click cross-tabulation (row 1, column 2).

   

3. Note that the shelves of the visual changed. They are now X, Y, Measures, Tooltips, and Filters.

4. To show specific items, populate the shelves from the available Fields (Dimensions, Measures, and so on) listed in the left navigation menu.

   • Under Dimensions, select country and drag it over X shelf on the main part of the screen. Drop to add it to the shelf.
   • Under Dimensions, select year and drag it over Y shelf on the main part of the screen. Drop to add it to the shelf.

   • Under Measures, select life_expectancy and drag it over Measures shelf on the main part of the screen. Drop to add it to the shelf.

     Note that by default, the sum aggregate of the field appears on the shelf, as sum(life_expectancy).

   

5. On the shelf of the visual, on sum(life_expectancy) field, click the icon (down arrow), select Aggregates, and then select Average.

   

6. Note that the shelf now contains the modified field avg(life_expectancy).

   

7. Click Refresh Visual.

   The default cross-tabulation visual appears. As you can see, it shows life expectancy information for each row of the dataset.

   

8. [Optional] On the Filters shelf, add several fields from Dimensions and Measures.

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

   For example, from Dimensions, drag country, un_subregion, un_region, and year onto the Filters shelf. Note that the filter selection wizard appears each time you place a field on a Filters shelf; you can specify filter values at this time, or click Cancel and select them later.

9. On the Filters shelf, click (down arrow) on the un_subregion field, then click Select values.

   

10. In the Filter for un_subregion modal window, select Middle Africa, then click Apply.

    

11. On the Filters shelf, click (down arrow) on the year field, then click Select values.

12. In the Filter for year modal window, select 1900, 1910, 1920, 1930, 1940, 1950, 1960, 1970, 1970, 1980, 1990, 2000, and 2010, then click Apply.

    

13. On the Measures shelf, click (down arrow) on the avg(life_expectancy) field, and select Display Format.

14. In the Display Format modal window, select Category Number, and enter 2 under Decimal Places; click Save.

    

15. Click Refresh Visual.

    The new cross-tabulation visual appears. As you can see, it clearly demonstrates the relative size of populations by assigning a progressively more saturated color to represent increasingly larger values.

    

16. Click Edit next to the title of the visualization.

    

17. Change the title to World Life Expectancy - Cross Tabulation.

18. Above the left navigation bar, click Save.