Search fillnull=0 doesn't work

[jadengoho]

i have a query like this:

|makeresults
|eval trail1="0.00"
|table trail1, trail2
|fillnull value="0.00"

i just want to have the trail2 to have a value of "0.00" but it doesn't shot any

[p_gurav · Accepted solution]

You can try specifying field:

|makeresults
 |eval trail1="0.00"
 |table trail1, trail2
 |fillnull trail2 value="0.00"

[jadengoho]

this is great , thank you very much