"There are no records" to replace with Zero/0

[amrit3671]

In Case GRAIL gives "There are no records" in the tile output, is there any way to display it as 0 instead of this message?

[cesarsaravia · Accepted solution]

Hey @amrit3671 
If you are using a bucket like bizevents or logs, maybe you can use a summarize command to get a result.

-Cesar S.

[amrit3671]

Thanks for replying to my question, actually I am using summarize command, in my DQL I am doing group by with summarize because of which I am getting above message.

| summarize Count=count(),by:osType

is there any way we can show "0" in this case as well.