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?
Also, is there a guide showing what the data icons/sign represent (e.g. hashtag, datestamp, equal, etc)?
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.
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.