How to replace blank values with "0"?

[harshparikhxlrd]

Trying to replace the blank values on my dashboard with 0s. If table is empty, should display 0. On the logs data, it is simply blank.

[aberkow · Accepted solution]

Since you said you tried fillnull, I'm guessing they're being read in as empty strings. For that specific column, you can specifically try

| eval invalid=if(isnull(invalid) OR invalid="", 0, invalid)
Otherwise fillnull value=0 should fill any fields that are null. You can also check if the column is actually null or not by doing this:

| eval isInvalidNull=if(isnull(invalid), 1, 0)
and compute this column just to validate that theory

[TrangCIC81]

---

@aberkow wrote:

Otherwise fillnull value=0 should fill any fields that are null.

---

Works for me.