...ount by request.detail.Context
| fillnull value=0 request.detail.Contex
The problem I have is around the zero values and the 'fillnull'. It basically doesn't work.
I've tried shifting the p...
What is the best way to use fillnull for multiple fields? What is the best way to avoid it working for only the first field?
Some examples are:
| fillnull value=NULL field1 field2 field3
| fillnull...
Hi,
I'm trying to fill empty hours (without events) using makecontinuous.
The time column created in the query/
| tstats count(s_id) as C
FROM datamodel=Hs
by s_date s_hour
| eval date_hour ...
...ickets with no subsystem, but it has no label (because the subsystem is empty). The search I'm using is index=myIndex | fillnull value="Not Provided" subsystem | chart count(ticket) by subsystem . I h...
I am using | fillnull totalCount in my search so I get an 0 when there is no result.
The color range I use is from min to 0 is green, from 0 to max is red.
Somehow the '0' is still showing r...
This is my code
index="google_apis" source="https://www.googleapis.com/youtube"
| timechart span=1h avg(subCount) by channel
the results looks something like this
Now, my proble...
Hi All,
I am trying to use the fillnull to populate empty values within the same field with unique values. For example, the first empty value found in field1, insert unknown1. The second empty v...
...ill in the null values in a results table with their previous event value as that would represent the state the field is in until it reflects the next change.
Any suggestions? I interpret fillnull to b...