I have a CSV that I import daily and some values decide to not show as "0", and some do.
Here's my search:
index="stockscreener_1d_ni"
| stats values(Change ), values(Vol), values(Price) by Symbol
| fillnull value=NULL
Some values under the "Vol" field show up blank, even though the CSV has "0" that should have been the value.
Example of CSV input:
AACS,AMER COMMERCE SOLTNS INC,OTC Pink No Information,0.001500,26.944200,0,Common Stock,USA,Florida
The Vol would be the zero value you see there after 26.944200,
Thanks!
I do not know the cause in the search sentence and the sample log.
Please identify the 0 event not displayed and investigate whether there is a format misalignment or the like.
Sorry, can you provide more detail in your reply?
Is my post wonky? (shows ok for me - with sample log & search syntax I used).
How do I determine if there is a format misalignment or "the like"?
Thanks.