Integer field marked as dimension (instead of measure)

Q&A
, ,
1

Hi,

I have two datasets; Dataset A and Dataset B. Dataset A has a field called daily_count, and Dataset B has a field called monthly_count. Both are integers. However, in my analysis, daily_count is a measure (which I prefer) and monthly_count a dimension (even though they are the same data type + contains similar data).

How come daily_count is interpreted as a measure, and monthly_count is interpreted as a dimension - despite them both being Integers / containing similar data?

Daily Count
Dataset: image
Analysis: image

Monthly Count
Dataset: image
Analysis: image

I know that this can be changed manually, but since have a large amount of datasets (as well as different _counts) it will require a lot of effort to change this manually for every field in every dataset.

Example Data

image

image

2

Hello @emmaeriksson , welcome to the Quicksight community!

I believe you will have to manually update this unfortunately.

My guess is that when the data was ingested and Quick Sight read a sample of rows it found blanks in the fields you described above which Quick Sight interpreted as strings.
Changing a field data type - Amazon QuickSight Sight%20reads%20a,to%20learn%20how

2 Likes
3

Thanks for the reply @duncan! Got it, will do it manually :slight_smile:

1 Like