# Convert MDA Queries into DQL for Advanced Analytics

**URL:** <https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309>\
**Category:** DQL\
**Tags:** dql, dynatrace-managed, multidimensional-analysis\
**Created:** [April 21, 2025, 9:49pm UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309 "2025-04-21T21:49:47Z")\
**Posts on this page:** 9\
**Page:** 1

<div class="post-metadata">

**Author:** ![Akhil-Jayendran](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/akhil-jayendran/32/153_2.png) [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Post date:** [April 21, 2025, 9:49pm UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/1 "2025-04-21T21:49:47Z")

</div>

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&nbsp;_ **dt.service.request.count** _ by _ **dt.entity.cloud\_application\_instance** _. Any insights or suggestions would be appreciated.

 ![Screenshot 2025-04-21 at 4.35.39 PM.png](https://global.discourse-cdn.com/dynatrace/original/3X/2/3/2379ff88d81380f3e79ee7c1b2558ae682dd56a8.png)

Regards,

Akhil Jayendran

---

<div class="post-metadata">

**Author:** ![p\_devulapalli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/p_devulapalli/32/41590_2.png) [@p\_devulapalli](https://community.dynatrace.com/u/p_devulapalli)\
**Post date:** [April 22, 2025, 1:25am UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/2 "2025-04-22T01:25:39Z")

</div>

[@Akhil-Jayendran](https://community.dynatrace.com/user/52584)&nbsp;Can you please try the below?

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

```

---

<div class="post-metadata">

**Author:** ![Akhil-Jayendran](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/akhil-jayendran/32/153_2.png) [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Post date:** [April 22, 2025, 1:49am UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/3 "2025-04-22T01:49:25Z")

</div>

Hello&nbsp;[@p\_devulapalli](https://community.dynatrace.com/user/21657)&nbsp;,

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.

---

<div class="post-metadata">

**Author:** ![p\_devulapalli](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/p_devulapalli/32/41590_2.png) [@p\_devulapalli](https://community.dynatrace.com/u/p_devulapalli)\
**Post date:** [April 22, 2025, 3:01am UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/4 "2025-04-22T03:01:39Z")

</div>

[@Akhil-Jayendran](https://community.dynatrace.com/user/52584)&nbsp;I am bit doubtful if this metric can be split by pod, but I could be wrong .

---

<div class="post-metadata">

**Author:** ![Akhil-Jayendran](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/akhil-jayendran/32/153_2.png) [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Post date:** [April 22, 2025, 3:14am UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/5 "2025-04-22T03:14:00Z")

</div>

Hi&nbsp;[@p\_devulapalli](https://community.dynatrace.com/user/21657)&nbsp; Even&nbsp; I have the same feeling, but in the Dynatrace UI under MDA I can split this metric with pod name (service\_instance) so I&nbsp; still have the hope we can do it same&nbsp; in the DQL with same metrics or any other metrics.

---

<div class="post-metadata">

**Author:** ![Akhil-Jayendran](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/akhil-jayendran/32/153_2.png) [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Post date:** [April 22, 2025, 4:53pm UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/6 "2025-04-22T16:53:27Z")

</div>

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

---

<div class="post-metadata">

**Author:** ![izabelarokita](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/izabelarokita/32/41812_2.png) [@izabelarokita](https://community.dynatrace.com/u/izabelarokita)\
**Post date:** [December 18, 2025, 10:56am UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/7 "2025-12-18T10:56:32Z")

</div>

Hey&nbsp;[@Akhil-Jayendran](https://community.dynatrace.com/user/52584)&nbsp;,  
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!&nbsp;:blush:  
Please let me know what works best for you.

---

<div class="post-metadata">

**Author:** ![Akhil-Jayendran](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/akhil-jayendran/32/153_2.png) [@Akhil-Jayendran](https://community.dynatrace.com/u/Akhil-Jayendran)\
**Post date:** [January 2, 2026, 2:59am UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/8 "2026-01-02T02:59:08Z")

</div>

Hi&nbsp;[@IzabelaRokita](https://community.dynatrace.com/user/67399)&nbsp;,&nbsp;  
Not really, I think&nbsp; it is not supported

---

<div class="post-metadata">

**Author:** ![Julius\_Loman](https://dub1.discourse-cdn.com/dynatrace/user_avatar/community.dynatrace.com/julius_loman/32/51_2.png) [@Julius\_Loman](https://community.dynatrace.com/u/Julius_Loman)\
**Post date:** [January 2, 2026, 9:19am UTC](https://community.dynatrace.com/t/convert-mda-queries-into-dql-for-advanced-analytics/51309/9 "2026-01-02T09:19:05Z")

</div>

[@Akhil-Jayendran](https://community.dynatrace.com/user/52584)&nbsp;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:

```markup
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](https://wkf10640.apps.dynatrace.com/ui/intent/dynatrace.notebooks/view-query#%7B%22visualization%22%3A%22lineChart%22%2C%22visualizationSettings%22%3A%7B%22chartSettings%22%3A%7B%22gapPolicy%22%3A%22connect%22%7D%2C%22legend%22%3A%7B%22ratio%22%3A23%7D%2C%22autoSelectVisualization%22%3Afalse%2C%22thresholds%22%3A%5B%5D%7D%2C%22dt.timeframe%22%3A%7B%22from%22%3A%22now()-30m%22%2C%22to%22%3A%22now()%22%7D%2C%22dt.query%22%3A%22fetch%20spans%5Cn%7C%20filter%20request.is_root_span%20%3D%3D%20true%5Cn%7C%20makeTimeseries%20count()%2C%20by%3A%20%7B%20dt.entity.process_group_instance%20%7D%5Cn%7C%20fieldsadd%20dt.entity.process_group_instance.name%20%3D%20entityName(dt.entity.process_group_instance)%22%2C%22hideInput%22%3Afalse%2C%22sourceApplication%22%3A%22dynatrace.notebooks%22%7D).
