Adding categorical Values to data points

Question & Answer
,
1

Hello lovely community people,

I need some help/suggestion to see if the following is possible to visualize, and how could I do it.

I have a dataset which looks like the following:

Category 1:

Medium
A
B
C

Category 2:

Good
D
E
F

Category 3:

Best
G
H
I

Q: A-I being the data points is what I see in my data in quicksight. Currently there are no defined categories, but I want to ask if it is possible to do this at quicksight level where we could add categories for the above given datapoints?

Any help would be appreciated. Thanks in adv

2

Hello @mistryamit90 !

To make sure I understand, do you want to add numeric values to each of the of the string values in your fields? For example, Category 1, Medium, A = 1, etc…?. I’m also not sure I understand the schema of your dataset, could you provide a sort of table view?

It would be best to do this on your data source using SQL but you could try a conditional calculated field to return values like the one below:

ifelse(
{Medium} = 'A', 
1, 
{Medium} = 'B', 
2, 
etc....,
NULL)
2 Likes
3

Thanks duncan for the info. Found the same answer through an old dashboard too :wink:

1 Like