topic Re: Convert MDA into DQL in DQL

Convert MDA Queries into DQL for Advanced Analytics

Akhil-Jayendran — Thu, 18 Dec 2025 10:57:00 GMT

Hello Team,

Is there a way to convert an MDA query into DQL or plot a chart on the dashboard without creating custom metrics?

I’m looking to split metrics from dt.service.request.count by dt.entity.cloud_application_instance. Any insights or suggestions would be appreciated.

Regards,

Akhil Jayendran

Re: Convert MDA into DQL

p_devulapalli — Tue, 22 Apr 2025 01:25:39 GMT

@Akhil-Jayendran Can you please try the below?

timeseries sum(dt.service.request.count), by: { dt.entity.cloud_application } | fieldsAdd dt.entity.cloud_application.name = entityName(dt.entity.cloud_application)

Re: Convert MDA into DQL

Akhil-Jayendran — Tue, 22 Apr 2025 01:49:25 GMT

Hello @p_devulapalli ,

I would like to get the metrics split by pode level (dt.entity.cloud_application_instance) above one is only with workload level I think.

Re: Convert MDA into DQL

p_devulapalli — Tue, 22 Apr 2025 03:01:39 GMT

@Akhil-Jayendran I am bit doubtful if this metric can be split by pod, but I could be wrong .

Re: Convert MDA into DQL

Akhil-Jayendran — Tue, 22 Apr 2025 03:14:00 GMT

Hi @p_devulapalli Even I have the same feeling, but in the Dynatrace UI under MDA I can split this metric with pod name (service_instance) so I still have the hope we can do it same in the DQL with same metrics or any other metrics.

Re: Convert MDA into DQL

Akhil-Jayendran — Tue, 22 Apr 2025 16:53:27 GMT

Does anyone have any insights on this? Is it achievable using DQL?

Re: Convert MDA into DQL

IzabelaRokita — Thu, 18 Dec 2025 10:56:32 GMT

Hey @Akhil-Jayendran ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.

Re: Convert MDA Queries into DQL for Advanced Analytics

Akhil-Jayendran — Fri, 02 Jan 2026 02:59:08 GMT

Hi @IzabelaRokita ,
Not really, I think it is not supported

Re: Convert MDA Queries into DQL for Advanced Analytics

Julius_Loman — Fri, 02 Jan 2026 09:19:05 GMT

@Akhil-Jayendran not using built-in metics directly, as those do not contain this information. You can query it using spans (if you have Dynatrace SaaS with Traces in Grail), as this is a replacement for MDA in the Gen3. You just need to use a different ID - since service instance is not a common field in Grail.

For example:

fetch spans | filter request.is_root_span == true | makeTimeseries count(), by: { dt.entity.process_group_instance } | fieldsadd dt.entity.process_group_instance.name = entityName(dt.entity.process_group_instance)

See that in action in playground.