Using Case statement Quicksight

Q&A
,
1

I am trying to define a new field by grouping IDs in the DATA for eg:
If ID IN (‘101’,‘102’,103’,…,‘109’) then ‘Staff’
If ID IN (‘1003’,‘1004’) then ‘Leader’ else ‘Other’

I’m aware quicksight doesn’t support case statement and even if I use IFELSE I have to use an OR statement repeatedly which is cumbersome. meaning ifelse(ID=‘101’ OR ID=‘102’ OR ID=‘103’…) Is there a better way to do this?

2

Hello @Ops_Expert !

Have you used the in function in Quicksight and are still running into errors?

3

It works! I was not aware of this function until now.

Thanks

1 Like
4

No problem @Ops_Expert !

I think that it was added fairly recently. Our team was surprised to find it as well.