Calculated field that combines multiple fields

Q&A
, , ,
1

I have a dataset with multiple binary fields and I would like to create a calculated field to use as a control that looks through all binary fields.

Dataset Example

customer_id | A | B | C | D | E |
123 | 1 | 0 | 1 | 0 | 0
234 | 0 | 1 | 1 | 0 | 1
345 | 0 | 1 | 0 | 1 | 1
456 | 1 | 1 | 1 | 0 | 0
567 | 0 | 1 | 1 | 1 | 0

With the above dataset, I would like to create a filter with options ‘A’, ‘B’, ‘C’, ‘D’, ‘E’. When a user selects option ‘A’ they should see all CIDs that are flagged as 1 in column A and similarly for all other options. Since one CID could qualify for multiple options, I don’t think an ‘ifelse’ function would work here?

2

Hi,

Try this may help you

Regards,
Naveed Ali

3

Thanks Naveed!
I understand that using parameters can help in selecting a field, but how do I apply filters to each field when navigating between different options within those parameters?

4

Hi @mbeig, maybe by using the parameters inside the calculated fields. Besides using custom SQL or different data orientation – I’m out of ideas.

5

Hi @mbeig. Checking in. We have not heard back from you regarding your question. 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).