Arcadia Enterprise's 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.
To change the field type, follow these steps:
Under Field Properties, click to expand the Change Type menu.
Note that the Geo Types options only appear on Geo shelves of Map and Interactive Map visuals, to make the field usable in that context.
From the Change type menu, select one of these options:
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; that removes the check mark.
Timestamp casts data to TIMESTAMP
, cast([field] as TIMESTAMP)
of the form year-month-Date hour:minute:second
; for example: 2015-06-09 14:15:45
.
String casts data as STRING
, cast([field]as STRING)
.
Integer casts data to BIGINT
, cast([field]as BIGINT)
.
Real casts data to REAL
, cast([field]as REAL)
.
Note that REAL
is an alias for DOUBLE
.
Boolean casts data to BOOLEAN
, cast([field]as BOOLEAN)
.
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.