Hi Team,
I’m facing an issue with an ifelse calculated field in QuickSight where overlapping conditions are preventing certain categories from showing up in my filter. Here’s my logic:
ifelse
(
in({mapping_studio},[‘JFK13’,‘SDF8’,‘MEX3’,‘GRU5’,‘YYZ4’,‘BCN13’,‘HND14’,‘DEL19’,‘CA14’,‘DXB21’,‘LHR17’,‘IST13’]),‘2D Internal Studios’,
in({mapping_studio},[‘BLR22’,‘HYD11’,‘MAA15’]),‘3D Internal Studios’,
in({mapping_studio},[‘JFK13’,‘SDF8’,‘MEX3’,‘GRU5’,‘YYZ4’,‘BCN13’,‘HND14’,‘DEL19’,‘CA14’,‘DXB21’,‘LHR17’,‘IST13’,‘BLR22’,‘HYD11’,‘MAA15’]),‘VI Phygital Studios’,
‘External Studios’
)
I want:
“VI Phygital Studios” to cover both 2D and 3D studios,
“3D Internal Studios” and “2D Internal Studios” to show up separately,
“External Studios” for anything else.
Currently only 2D Internal Studios,3D Internal Studios and External Studios appear in the filter due to overlapping conditions.
Any tips on how to fix this?
Hi @tisakshi,
What type of visual are you trying to build for this instance?
You may need to create separate calculated fields; when grouping all together in one ifelse statement, you’re essentially determining what group a specific value should fall within, which does not include the ability to place in 2 locations.
Hi @tisakshi,
It’s been awhile since we last heard from you; checking in to see if you had any additional questions or if you were able to find a work around for your case?
If we do not hear back within the next 3 business days, I’ll go ahead and close out this topic.
Thank you!
Hi @tisakshi,
Since we haven’t heard back, I’ll go ahead and close out this topic. However, if you have any additional questions, feel free to create a new post in the community.
Thank you!