I am trying to create a table with data set of test results. I need to add a column in the table to identify the particular suite id environment which i want to hard code in the table. I tried creating calculated-field using replace function, but it is allowing to add only one statement, with which i am not able to add env names for all the suite ids. I have added the screenshots for reference
Hi @cadit
Welcome to Quick Sight Community !!!.
Could you please try using SWITCH function as shown below.
switch({tim.suiteId},
‘25c…’, ‘beta’,
‘2e8…’, ‘gamma’,
‘others’)
Please find the documentation for detailed examples .
Thanks
Vinod
switch({tim.suiteId},
“25…”, “Beta”,
“11…”, “Gamma”,
“2e…”, “Prod”, “null”)