Adding field comments in dataset

When working with big data, it can be very helpful to have access to comprehensive field-level descriptions. In CDP Data Visualization, you can use field comments to provide the context and meaning of each dataset field.

The following steps demonstrate how to add description to a column of a dataset, as a 'comment'. In this example, we are using the column iso_cc (the ISO-compliant country code) in the dataset World Life Expectancy [data source samples.world_life_expectancy].

  1. On the main navigation bar, click Data.
    Click DATA on main nav

    The Data view appears, open on the Datasets tab.

    Main landing page of DATA
  2. In the left navigation menu, click samples.
  3. In the Datasets area, select World Life Expectancy (samples.world_life_expectancy).
    selecting a dataset
  4. In the Dataset Detail menu, select Fields.
    detail of 'World Life Expectancy'
  5. In the Fields interface, select Edit Field.
    Editing Fields of Dataset 'World Life Expectancy'
  6. Under Dimensions, find the field iso_cc, and click the (down arrow) icon on the right.
  7. From the menu, select Edit Fields.
    selecting edit field window

    The Edit Field Parameters window modal appears.

  8. Under Field Comment, add the following text:
    ISO 3166 Country Code Standard, Numeric, described in http://www.iso.org/iso/country_codes. Mappings are at https://www.iso.org/obp/ui/#search.
  9. Click Apply.
    adding comment to the field
  10. Under Dataset: World Life Expectancy, click Save.
  11. Click Show Comments. Notice that the comment appears with the field iso-cc.
    changing display name
  12. To hide column comments, click Hide Comments.