topic Re: Single value visualization showing output as "N/A" instead it should show 0 in Dashboards & Visualizations

Single value visualization showing output as "N/A" instead it should show 0

mprreddy51 — Tue, 31 May 2016 18:16:39 GMT

Hi,

I have single value visualization if i select for 24 hrs or any other time i am getting results example: 50
If i select for 15 min or less than a hour it is showing output as: "N/A". I want to show the output result as "0" if there are no results instead of N/A

Thanks,
PR

Re: Single value visualization showing output as "N/A" instead it should show 0

nswondem — Tue, 31 May 2016 18:27:57 GMT

Please see https://answers.splunk.com/answers/49559/single-value-return-n-a-instead-of-0.html.

Re: Single value visualization showing output as "N/A" instead it should show 0

shaskell_splunk — Tue, 31 May 2016 18:28:12 GMT

What does your search look like? If you're doing a simple '| stats count' it should return 0 if you have no results during the selected time period.

Re: Single value visualization showing output as "N/A" instead it should show 0

mprreddy51 — Tue, 31 May 2016 19:42:09 GMT

Hi,

My query ends with "| search STATUS = D OR STATUS = A| stats sum(STATUS_COUNT)

but no luck

Re: Single value visualization showing output as "N/A" instead it should show 0

somesoni2 — Tue, 31 May 2016 20:29:44 GMT

Try like this

your base search | search STATUS = D OR STATUS = A| stats sum(STATUS_COUNT) as count | appendpipe [| stats count | where count=0]

Re: Single value visualization showing output as "N/A" instead it should show 0

mprreddy51 — Tue, 31 May 2016 21:39:35 GMT

Thanks Somesh.

|rename STATUS_COUNT as sumation |appendpipe [ stats count | eval sumation=if(count==0,0,NULL)|fields - count] this i used working fine