https://community.dynatrace.com/t5/DQL/quot-There-are-no-records-quot-to-replace-with-Zero-0/m-p/233103#M488 <P>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.</P><P>&nbsp;</P><P>| summarize Count=count(),by:osType</P><P>&nbsp;</P><P>is there any way we can show "0" in this case as well.</P> Tue, 02 Jan 2024 04:54:05 GMT amrit3671 2024-01-02T04:54:05Z https://community.dynatrace.com/t5/DQL/quot-There-are-no-records-quot-to-replace-with-Zero-0/m-p/232656#M452 <P>In Case GRAIL gives "<SPAN><SPAN class="">There are no records</SPAN></SPAN>" in the tile output, is there any way to display it as 0 instead of this message?</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="amrit3671_0-1703232562236.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/16393i65394E624ABDE552/image-size/medium?v=v2&amp;px=400" role="button" title="amrit3671_0-1703232562236.png" alt="amrit3671_0-1703232562236.png" /></span></P><P>&nbsp;</P> Fri, 22 Dec 2023 08:10:35 GMT https://community.dynatrace.com/t5/DQL/quot-There-are-no-records-quot-to-replace-with-Zero-0/m-p/232656#M452 amrit3671 2023-12-22T08:10:35Z https://community.dynatrace.com/t5/DQL/quot-There-are-no-records-quot-to-replace-with-Zero-0/m-p/232759#M456 <P>Hey&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/64202">@amrit3671</a>&nbsp;<BR />If you are using a bucket like bizevents or logs, maybe you can use a <A href="https://docs.dynatrace.com/docs/platform/grail/dynatrace-query-language/commands/aggregation-commands#summarize" target="_self">summarize command</A> to get a result.</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="cesarsaravia_0-1703288456496.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/16442i4E80CC0114A28B6D/image-size/medium?v=v2&amp;px=400" role="button" title="cesarsaravia_0-1703288456496.png" alt="cesarsaravia_0-1703288456496.png" /></span></P><P>-Cesar S.</P><P>&nbsp;</P> Fri, 22 Dec 2023 23:45:01 GMT https://community.dynatrace.com/t5/DQL/quot-There-are-no-records-quot-to-replace-with-Zero-0/m-p/232759#M456 cesarsaravia 2023-12-22T23:45:01Z https://community.dynatrace.com/t5/DQL/quot-There-are-no-records-quot-to-replace-with-Zero-0/m-p/233103#M488 <P>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.</P><P>&nbsp;</P><P>| summarize Count=count(),by:osType</P><P>&nbsp;</P><P>is there any way we can show "0" in this case as well.</P> Tue, 02 Jan 2024 04:54:05 GMT https://community.dynatrace.com/t5/DQL/quot-There-are-no-records-quot-to-replace-with-Zero-0/m-p/233103#M488 amrit3671 2024-01-02T04:54:05Z