Measures changed to dimension

Question & Answer
, ,
1

Hi

In my dataset, I have a field called ‘execution’ which is an integer data type (green hashtag icon). However, in analyses, it seems to have changed into a dimension (blue hashtag icon). Can someone please advise why quicksight changed the type?

image

Also, is there a guide showing what the data icons/sign represent (e.g. hashtag, datestamp, equal, etc)?

2

Hello Clee900,

First of all Welcome to the QuickSight Community !

In the old look, measure are shown as green # and Dimension/date are shown as blue#
In the new look, measure are shown as orange# and Dimension/date are shown as blue#
I
n 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.

For more info - Setting fields as a dimensions or measures - Amazon QuickSight

hope this helps.
Cheers,
Deep

3

Thanks so much, Deep. Is it right to assume in this case Quicksight interprets my measure field into a dimension?

Also, is there a guide showing what the data icons/sign represent (e.g. hashtag, datestamp, equal, etc)?

4

Hello Clee900,

Yes your assumption is right ,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 no worries.

As far as guide on showing the icon reference is concern, i could not find any explicit documents but you may follow link for more info shared in the previous reply.

hope this helps.
cheers,
Deep

5

Thanks @Deep - Appreciate your help :slight_smile: