https://community.dynatrace.com/t5/DQL/I-want-to-create-a-line-chart-that-displays-the-failed-request/m-p/277297#M2088 <P>I want to create a line chart that displays the failed request count for a selected service<BR />I able to achieve the builtin metrics however when i am trying to do same thing with DQL its not returning the result</P><P><STRONG>Able to get result:</STRONG><BR />builtin:service.errors.total.rate:filter(and(or(in("dt.entity.service",entitySelector("type(service),entityName.contains(~"(/sbmo-auditlogconsole)~")"))))):splitBy("dt.entity.service"):sort(value(auto,descending))<BR /><BR /><STRONG>No result with:</STRONG><BR />timeseries { count = sum(dt.service.request.count, filter: { failed == true }), count.0 = sum(dt.service.request.count) }, by: { dt.entity.service }, filter: { in(dt.entity.service, classicEntitySelector(concat("type(service),entityName.contains(\" (/sbmo-auditlogconsole)\")"))) }<BR />| fieldsAdd rate = count[] / count.0[]<BR />| sort arraySum(rate) desc<BR />| fieldsAdd entityName(dt.entity.service)<BR />| fieldsRemove count.0, count<BR /><BR /></P> Thu, 15 May 2025 12:26:14 GMT Ganeshmete77 2025-05-15T12:26:14Z https://community.dynatrace.com/t5/DQL/I-want-to-create-a-line-chart-that-displays-the-failed-request/m-p/277297#M2088 <P>I want to create a line chart that displays the failed request count for a selected service<BR />I able to achieve the builtin metrics however when i am trying to do same thing with DQL its not returning the result</P><P><STRONG>Able to get result:</STRONG><BR />builtin:service.errors.total.rate:filter(and(or(in("dt.entity.service",entitySelector("type(service),entityName.contains(~"(/sbmo-auditlogconsole)~")"))))):splitBy("dt.entity.service"):sort(value(auto,descending))<BR /><BR /><STRONG>No result with:</STRONG><BR />timeseries { count = sum(dt.service.request.count, filter: { failed == true }), count.0 = sum(dt.service.request.count) }, by: { dt.entity.service }, filter: { in(dt.entity.service, classicEntitySelector(concat("type(service),entityName.contains(\" (/sbmo-auditlogconsole)\")"))) }<BR />| fieldsAdd rate = count[] / count.0[]<BR />| sort arraySum(rate) desc<BR />| fieldsAdd entityName(dt.entity.service)<BR />| fieldsRemove count.0, count<BR /><BR /></P> Thu, 15 May 2025 12:26:14 GMT https://community.dynatrace.com/t5/DQL/I-want-to-create-a-line-chart-that-displays-the-failed-request/m-p/277297#M2088 Ganeshmete77 2025-05-15T12:26:14Z https://community.dynatrace.com/t5/DQL/I-want-to-create-a-line-chart-that-displays-the-failed-request/m-p/277454#M2097 <P>Please try this:</P><LI-CODE lang="markup">timeseries { count = sum(dt.service.request.count, filter: { failed == true }, default:0), count.0 = sum(dt.service.request.count) } , by: { dt.entity.service } , filter: { in(dt.entity.service, classicEntitySelector(concat("type(service),entityName.contains(\" (/sbmo-auditlogconsole)\")"))) } , union:true | fieldsAdd rate = count[] / count.0[] | sort arraySum(rate) desc | fieldsAdd entityName(dt.entity.service) | fieldsRemove count.0, count</LI-CODE><P>&nbsp;</P><P>Without <EM><STRONG>union:true</STRONG></EM> your query will not return where there was completely no data when condition "failed = true" is not fulfilled.&nbsp;</P><P>Additionally adding <EM><STRONG>default:0</STRONG></EM> will help getting correct result (0) instead of null when there are no failed requests for specific time slots.</P> Mon, 19 May 2025 06:54:22 GMT https://community.dynatrace.com/t5/DQL/I-want-to-create-a-line-chart-that-displays-the-failed-request/m-p/277454#M2097 krzysztof_hoja 2025-05-19T06:54:22Z https://community.dynatrace.com/t5/DQL/I-want-to-create-a-line-chart-that-displays-the-failed-request/m-p/277516#M2102 <P>Thanks, Its working now.</P> Mon, 19 May 2025 15:15:47 GMT https://community.dynatrace.com/t5/DQL/I-want-to-create-a-line-chart-that-displays-the-failed-request/m-p/277516#M2102 Ganeshmete77 2025-05-19T15:15:47Z