Distribution of Top Rated Players by Country

CONTENTS

Home

This visualization uses the CountryName dimension and Id measure from the Atp Players table. Filtering is based on the Ranking measure of the Atp Rankings Current table. The data is visualized as a gMap.

Add the Columns

  1. Expand the Atp Players table to view the columns.
  2. Click CountryName dimension. The column is added to the Table tab in the Visualization panel.
    Column adding to the Table tab
  3. Click on the Id measure. Note it defaults to Sum, which is not useful for an identifier field.
  4. Change the Id measure in the Definition panel from Sum to Count:
    Column adding to the Table tab
  5. Click Fetch to see the data:
    fetch data

Add the Filter

The data needs to be filtered for only the 10 top-ranked players.

  1. Click the Filter tab in the Definition panel.
  2. Click + Add Custom Filter.
  3. Enter atp_rankings_Current.Ranking <= 10
    Filter the ranking
    Note an alert appears showing the number of unsaved filters.
  4. Click Fetch to see the filtered data:
    Fetch filtered data

Visualize the Data

The gMap option is a nice way to visualize this data.

  1. Click the gMap tab in the Visualization panel. If you do not see the gMap tab, check your Tenant Customization.
  2. Click the Settings tab in the Definition panel.
  3. Click drop down menu by CountryName and select Add as country.
    Add as country
  4. Click drop down menu by Count Id and select Add as measure.
    Add as measure
    Your visualization is displayed:
    Your visualization

Save your Sheet

  1. Click Save As.
  2. Enter a descriptive name.
    Save your Sheet
  3. Click Save.

You can see the new sheet when you open drop down menu My Space:

My Space