Timechart displaying undefined NaN in the left corner

[tkhatri]

I am creating a single series timechart that does a count of ids and then I am using | appendpipe [stats count | where count=0] to display 0 instead of 'No results found'.

The timechart shows up right but in addition also shows undefined NaN like shown below. Can anyone please help suggest why is it happening and how to get rid of it.

Thanks.

[renjith_nair · Accepted solution]

Does this work for you ?

your search |appendpipe [|makeresults]

[miguel1423]

Hi

I've the same issue, could you show me where do you place the "makeresult" please ?

 | appendpipe [stats count | where count=0]

Regards,

[tkhatri]

Try this: 

| appendpipe [|where count=0
| makeresults]|

[miguel1423]

thx 😃

[tkhatri]

It worked. Thank you Renjith.