Changing field type
CDP Data Visualization visuals enable you to change the type of the field as a
cast operation of the form
cast(expr as type), directly on
the fields of the visual. Similarly, you can ensure that a field on a Geo shelf can be used even
if it does not automatically satisfy Geo naming conventions.
- Click the field you plan to modify, to open the Field Properties menu.
- Under Field Properties, click to expand the
Change Type menu.
- From the Change Type menu, select one of the options.
Timestamp casts data to
cast([field] as TIMESTAMP)of the form
String casts data as
Integer casts data to
Real casts data to
Boolean casts data to
- Geo Types
Geo Types is a grouping of types that make the field usable on the Geo shelf of Map and Interactive Map visuals.
Note that after a field becomes useable for geo visuals, it is marked on the shelf by the (globe) icon.
Alternatively, a user with sufficient privileges should declare the field a Geo Type at the level of the dataset. See Specifying Geographic Fields.
- Click Refresh Visual to see the changes.
Fields that carry a type change have a green dot on the Change Type menu.
To remove a type cast from a field, click on the selected type cast. It removes the check mark.