Convert MDA into DQL

[Akhil-Jayendran]

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

[p_devulapalli]

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

[Akhil-Jayendran]

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.

[p_devulapalli]

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

[Akhil-Jayendran]

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. 

[Akhil-Jayendran]

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