I have a CSV that I import daily and some values decide to not show as "0", and some do.

[agoktas]

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!

[HiroshiSatoh]

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.

[agoktas]

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.