topic Re: Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps in Dynatrace tips

Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps

dawid_rampalski — Thu, 14 Mar 2024 11:04:14 GMT

Why do I see differences in metric data between grail based queries and Data explorer?

With grail we have changed the way the data is stored and displayed. DQL allows you to access raw metric data and perform your own transformations to achieve what you want. In case of Data explorer it already does some processing on the data in the background. When trying to play around with timeseries in our new platform you might notice that metric results that you get differ from what you can see in Data explorer - this is most likely due to different processing applied by your query and by Data explorer

How do I get the same results?

To make transition from our classic Data explorer charts easier we have built a tool that will allow you to create a traditional metric query and automatically generate equivalent DQL command.

In Data explorer build your metric query:

To transform it into dql, click on the "Open with" and select your application of choice:

Your query is generated in selected app together with a tile that runs it for you and presents results:

timeseries usage=sum(dt.process.cpu.usage, rollup: avg), filter: { in(dt.entity.process_group_instance, classicEntitySelector("type(process_group_instance),fromRelationship.isProcessOf(type(HOST),entityName.equals(\"cpu1-demo1\"))")) } | sort arraySum(usage) desc | limit 20 | append [timeseries usage=avg(dt.host.cpu.usage), filter: { in(dt.entity.host, classicEntitySelector("type(host),entityName.equals(\"cpu1-demo1\")")) } | sort arrayAvg(usage) desc | limit 20]

This query is designed to provide the same processing that is selected in Data explorer or get as close to it as possible within DQL

Re: Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps

dannemca — Wed, 07 Feb 2024 19:27:11 GMT

That's an interesting feature!!!

Re: Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps

DanielS — Tue, 27 Feb 2024 18:59:23 GMT

Great!!! Thanks. Very Useful

Re: Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps

sujit_k_singh — Wed, 28 Feb 2024 04:16:19 GMT

Ahh..thats awesome... very useful. Thanks for sharing this

Re: Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps

erh_inetum — Fri, 12 Apr 2024 05:25:35 GMT

Hi @dawid_rampalski ,

In several cases we find this message when we try to convert a query from Data Explorer to DQL:

Is it because there is not an equivalent metric for DQL?

The Data Explorer query that we can´t convert is using the following metrics:

builtin:apps.web.actionCount.load.browser
builtin:apps.web.actionCount.xhr.browse
builtin:apps.web.visuallyComplete.load.browse
builtin:apps.web.VisuallyComplete.xhr.browse

In these cases, how can we convert the DataExplorer query to DQL query?

Thanks in advance,

Elena.

Re: Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps

dawid_rampalski — Fri, 12 Apr 2024 05:38:04 GMT

Hi Elena,

that is exactly the reason why. We don't have metrics for applications enabled yet in Grail. You can check the list of currently available builtin metrics here: https://docs.dynatrace.com/docs/observe-and-explore/metrics/built-in-metrics-on-grail.

In the case of those there is at this point no way to use them from DQL. We are working on it though 🙂

Best Regards,
Dawid

Re: Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps

marina_pollehn — Fri, 12 Apr 2024 06:48:24 GMT

Thank you, this is a great help!

Re: Easily convert Data explorer queries to dql for Dashboards, Notebooks and other apps

cesarsaravia — Fri, 19 Apr 2024 17:51:34 GMT

Very useful tip!!