If my search give no results ...show in Single value...If results available... then show in table with values?

[priyansplunk]

If my search give no results ..I want to Display Single value chart with "All is Well".If my search query produce results i want to show the table with values..Is it possible?

[woodcock]

Just add this to the end of your search:

... | appendpipe [| stats count AS message | eval message=if(message==0, "ALL IS WELL", "There is trouble up above!")]