@P3G4SUS - You can do that like this: ....
| eval empty_cells = case(isnull(A) AND isnull(B), 2, isnull(A), 1, isnull(B), 1, 1==1, 0)
| stats sum(empty_cells) as total_empty_cells I'm assuming y...
See more...
@P3G4SUS - You can do that like this: ....
| eval empty_cells = case(isnull(A) AND isnull(B), 2, isnull(A), 1, isnull(B), 1, 1==1, 0)
| stats sum(empty_cells) as total_empty_cells I'm assuming your two fields in the table is A and B, but you can replace that with what you have in above query and you should get your answer. I hope this helps!!!