topic Split requests from a built-in metric by request name in Dashboarding

Split requests from a built-in metric by request name

Teddyl92 — Mon, 22 May 2023 14:20:25 GMT

Can we split requests from a built-in metric (builtin:service.requestCount.total) by request name in Data Explorer by using metric expressions or any other method?

We want to avoid using custom metrics.

Re: Split requests from a built-in metric by request name

Ana_Kuzmenchuk — Wed, 15 Feb 2023 10:25:47 GMT

Hi @Teddyl92, maybe this document can help. Cheers!

Re: Split requests from a built-in metric by request name

jnernest — Wed, 21 Jun 2023 05:12:51 GMT

Hi,

I would like to see below kind of split in data explorer, how to do it using advanced mode without custom metrics

thanks,

nathaniel

Re: Split requests from a built-in metric by request name

Mohamed_Hamdy — Thu, 22 Jun 2023 10:25:13 GMT

Hi @jnernest,

you can use the key requests metric which you can split by request name, but this will work only for requests that are marked as key requests (builtin:service.keyRequest.count.total:splitBy("dt.entity.service_method")

if you still need to use the same data for requests associated with specific management zone for instance you can create calculated service metrics then you can use it in the data explorer and split by dimension which in your case will be the request. note that the calculated service metrics will consume DDUs

Re: Split requests from a built-in metric by request name

jnernest — Mon, 26 Jun 2023 10:50:31 GMT

Hi @Mohamed_Hamdy

thanks for the information, I am trying to adapt the first solution.

One more query on this keyrequest topic, if we have two keyrequest on different services with same name how can i filter it out in dashboard?

for example : motor insurance service has calculate request which has been marked as key request same way life insurance service also has calculate request

thanks,

Nathaniel

Re: Split requests from a built-in metric by request name

Mohamed_Hamdy — Tue, 04 Jul 2023 08:24:40 GMT

Hi @jnernest,

sure, you can add multiple services, and you can use the following sample and replace service1, service2, service3 with your services and you can add more than that

builtin:service.keyRequest.count.total:filter(and(or(in("dt.entity.service_method",entitySelector("type(service_method),fromRelationship.isServiceMethodOfService(type(SERVICE),entityName.in(~"service1~",~"service2~",~"service3~"))"))))):splitBy("dt.entity.service_method"):sort(value(auto,descending)):limit(20)