Setting fields as a dimensions or measures
In the Field list pane, dimension fields have blue icons and measure fields have green icons. Dimensions are text or date fields that can be items, like products, or attributes that are related to measures. You can use dimensions to partition these items or attributes, like sales date for sales figures. Measures are numeric values that you use for measurement, comparison, and aggregation.
In some cases, Amazon QuickSight interprets a field as a measure that you want to use it as a dimension (or the other way around). If so, you can change the setting for that field.
Changing a field's measure or dimension setting changes it for all visuals in the analysis that use that dataset. However, it doesn't change it in the dataset itself.
Changing a field's dimension or measure setting
Use the following procedure to change a field's dimension or measure setting
To change a field's dimension or measure setting
-
In the Field list pane, hover over the field that you want to change.
-
Choose the selector icon to the right of the field name, and then choose Convert to dimension or Convert to measure as appropriate.