If I understand correctly, the output is returning null values in your new field called nature because the lolo value is not 2? If so, easy fix. You lost the media field in line 2 on your stats so using this field on line 3 conditional logic will return null fields, but you also did a dc(media) AS lolo , so you gained a new field called lolo . Change line 3 to this
|eval nature = if(lolo=2,"all",lolo)
... View more