topic Dashboard - service IDs instead of tag in DQL

Dashboard - service IDs instead of tag

sshinde_24 — Wed, 27 Aug 2025 06:22:36 GMT

Hi,

I want to use service IDs instead of tag, help replace tag(\"",$MyServices,"\") with ID.

timeseries count = sum(dt.service.request.count), by: { endpoint.name },
filter: { endpoint.name in[fetch dt.entity.service_method
| filter in(id, classicEntitySelector(concat("type(service_method),fromRelationship.isServiceMethodOfService(type(SERVICE),tag(\"",$MyServices,"\"))")))
| fields entity.name ] }
| sort arraySum(count) desc
| limit 20

Re: Dashboard

AntonPineiro — Tue, 26 Aug 2025 14:01:32 GMT

Hi,

Why do you prefer IDs? I think using tags would be more flexible.

Best regards

Re: Dashboard

dannemca — Tue, 26 Aug 2025 14:48:40 GMT

That would be like this:

timeseries count = sum(dt.service.request.count), by: { endpoint.name }, filter: { endpoint.name in[fetch dt.entity.service_method | filter in(id, classicEntitySelector(concat("type(service_method),fromRelationship.isServiceMethodOfService(type(SERVICE),entityID(\"",$MyIDs,"\"))")))| fields entity.name ] } | sort arraySum(count) desc | limit 20

Assuming you have a var called MyIDs with the ID list.
Try and let us know

Re: Dashboard - service IDs instead of tag

sshinde_24 — Thu, 28 Aug 2025 10:40:06 GMT

Thanks for the solution. Unfortunately, it didn’t work as expected — I’m not seeing any records in the output

Re: Dashboard - service IDs instead of tag

PacoPorro — Thu, 28 Aug 2025 10:53:15 GMT

Can I suggest a different approach?
Jump to notebooks/dashboard from the services app.

Select the service you need from the service app, and from the overview, throughput, 3 dots open with