I have 25 different flags, all responding with either ‘1’ or ‘0’, (true / false). I have tried to create loads of ifelse statements to have all the flags in one fields, instead of having to put 25 flags into a table. But this didn’t work for me.
I guess my main question is how can i incorporate 25 different flags into one field, so it will look into these flags, if it = 1, it will add 1 to a count, if it = ‘0’ it will look at the next one.
The end goal is that i drop this one field into a bar chart, and it will show 25 bars with the count for each one.
Hi @HarveyB-B ,
could it be an option to switch from the true/false to 25 different keys (e.g. A,B,C…).
You could then use the new field in x-axis and value (as count)
Yes, which i can go back to (A-N, X1-X10), but how would i show all 25 in only one field? So it would look like what you posted, however with the other 24?
For reference, flag name would be flagA flagB flagC up to N, and another set of flagX1 FlagX2 flagX3 up to X10
Thanks for the fast response, hopefully we can get this solved.
Hi @HarveyB-B -
Did @ErikG 's suggestion help solve your issue? If so, please mark as a solution. If not, please let us know what additional assistance you need. Thanks.
