I have a pivot table that has a null value for a few of the records in the "Date" column that is preventing me from sorting the table. How and with what do I replace the null value in the Date column?
You have 3 options:
... | eval Date = coalesce(Date, yourAlternateFieldHere, "Your Hard-Coded Default Value Here")
OR
... | fillnull value="Your Hard-Coded Default Value Here" Date
OR
... | filldown Date
I leave it as an exercise for the reader to figure our (or @DalJeanis to explain) the differences.
You need to populate the Date field.
Identify, on the records with no Date, what is a good candidate for substitution, then do something like
| eval Date = coalesce(Date,mySubstituteField)
@juzzbitzz,
Try adding |fillnull value="your value for date" Date
in the base search before aggregation/sort