In my events, there is a field called "is_interactive" which has value of either 0 or 1.
Now the thing is, not all of my events has the field "is_interactive" in them.
How to do I know, how much of of my events have this field in them ?
stats count(is_interactive)
| makeresults count=20
| eval is_interactive=random()%2
| eval is_interactive=if(random()%2 == 0,null(),is_interactive)
``` the lines above generate some random dummy data ```
| stats count count(is_interactive) as interactive sum(is_interactive) as total
This show total count, those events where is_interactive is not null, and the sum of the is_interactive to show that some of the is_interactive values are zero