Split requests from a built-in metric by request name

[Teddyl92]

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. 

[Ana_Kuzmenchuk · Accepted solution]

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

[jnernest]

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

[Mohamed_Hamdy]

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")

or 

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

[jnernest]

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

[Mohamed_Hamdy · Accepted solution]

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)