Hi Jonathon, how many if can I concatenate in the same expression?jonathon wrote:hmm,
we've not encountered this sort of use case before. perhaps we need to consider it.
you'll need to use computed variables for this:
IF(CONTAINS('Dog', variableName), 1, IF(CONTAINS('Cat', variableName), 2, ... ))
jonathon
Search found 2 matches
- Thu Oct 06, 2022 9:53 pm
- Forum: General
- Topic: Transformed variable - if source contains
- Replies: 7
- Views: 11178
Re: Transformed variable - if source contains
- Thu Oct 06, 2022 9:47 pm
- Forum: General
- Topic: Problems with nominal variables
- Replies: 2
- Views: 7096
Problems with nominal variables
Hey guys I would like some advice, I have 14 nominal variables (yes or no questions) and I would like to plot all the YES's on a single bar chart. Any ideas? I have tried to filter, transform but have not managed to solve it.