I have a requirement, where i need to switch the fillnull value between Excluded and N/A.
So is there any way that i can use fillnull conditionally.
Eg: if (status == "EXCLUDED") then fillnull value="EXCLUDED"
OR
if (status == "N/A") then fillnull value="N/A"
Is this can be done ?
Please help me on this, i really need this kind of behavior in my dashboard.
Try this
| eval FIELD_NAME=if(isnull(status),"EXCLUDED",'status')
@Maniteja81,
How many fields are you trying to fill the null? If its one field, can't you use the conditional substitution using case or if ? Is it possible to share the search currently using ?