Is it possible for Quicksight to allow user entered strings as variables for a calculated field? For example if i have the user enter value x in a filter list (or elsewhere), can I have Quicksight save that variable x so i can create a calculated field such as: ifelse(‘item’ = x, 1,0)?
@Skodati8 Yes, you can do this with Parameters. Create a parameter and choose the appropriate type (String, Integer, etc), then add a control for your filter and choose a Text Box input, and then you can reference that parameter in your calculated fields.
2 Likes
That worked! Thank you Jesse!
2 Likes
Please add union featurr for data… We sre not sbke to combine excel mannual and redshift data