@Bujinlkham_Boldbaata - Thank you for posting your query. ifelse() should be the function that you would need to use here. Please go through the documentation which contains examples as well. Hope this helps!
Did my suggestion help you in resolving your query? If yes, would request you to mark the post as “Solution”. This will help the community to find guidance and answers to similar question. Thank you!
Can you please share the expression that you are using?
Hi @Bujinlkham_Boldbaata,
It’s been awhile since we last heard from you. Are you still having problems with your initial question or were you able to figure out a solution?
If we do not hear back from you in 3 business days, I’ll go ahead and archive this topic. If you have any further questions, feel free to create a new topic for discussion.
Thank you!
Hi @Bujinlkham_Boldbaata, I am marking this reply as, “Solution,” in case you need further assistance with your problem, please create a sample dashboard with sample dataset showing your problem state using Arena and please create a new post, so we can look at it from a fresh perspective. (Details on using Arena can be found here - Quick Sight Arena)
