The scenario is this.
I have a two field name name joe and bob. if bob help a job it indicate yes as its field value
like this joe="y" and if bob help with a job it will have a value of bob="y" and "n" if they didnt help.
JOE BOB
Y N
Y N
Y N
N Y
N Y
now im trying to make a single field name "assistance" that counts if joe,bob or both of them help in the job
I use:
|eval assistance=if(joe="y" AND bob="y", "both",(if(joe="y", "JOE Only", "BOB Only")))
assistance COUNT
JOE Only - 3
BOB only - 2
both -------- 0
but if I evaluate it, and the result of BOTH is "0", the field "BOTH" never showed when i tabled "assistance". But I NEED the field BOTH to show up so i can show in data visualization that they didn't assist each other.
... View more