How to create new text column in pivot table?

Q&A
, ,
1

Greetings,

I want to a create separate column in pivot table named as “product family” which is not already in my dataset. But I have “product” column in dataset.

Let’s say,
13.3" MacBook Air (2019) → This is in “product” column
MacBook Air should be in “product family”.

When I used the calculated field using the following syntax, the changes are not getting reflected:

ifelse(contains(Product, “MacBook Air”), “MacBook Air”, “Other”)

Could you please let me know how should I do it properly?

Is it possible to create new column named “product family” and have text based on “product” in AWS Quick Sight?

2

Hi @Viji
What do you mean by

Your approach looks right to me but I guess you will have more then one product family and you have do to the ifelse for each product and update it for every new product. Any chance to prepare a mapping outside of Quick Sight?
BR

3

@Viji-
Did you solve your issue? If not, please provide additional details so we can help. Are you getting an error? There will not be changes to an existing column, you will be creating a new calculated field - Product Family.

4

Hi @Kellie_Burton,

I wanted to let you know that I successfully resolved my query. It turns out, when I was dragging the calculated field to the values section, it wasn’t reflecting on the chart. However, when I dragged it to the dimension section, it worked seamlessly.