topic Re: DQL For Apdex in Dashboarding

DQL For Apdex

amita — Wed, 07 Feb 2024 12:29:47 GMT

Hello,

I want to create a visualization for our application platforms having apdex overview..

Is there any way to do it using grail or new functionality rather than configuring it in Data explorer.

Regards

Amita Chede

Re: DQL For Apdex

radek_jasinski — Wed, 07 Feb 2024 09:28:39 GMT

Hi @amita

I do not see a direct advantage of Grail over Data Explorer when building charts for Apdex.
You can think of your own application in Dynatrace built on AppEngine.

Radek

Re: DQL For Apdex

amita — Wed, 07 Feb 2024 09:45:37 GMT

Thanks for the quick response Radek.

Regards

Amita

Re: DQL For Apdex

Julius_Loman — Thu, 08 Feb 2024 22:24:28 GMT

I assume you want to show Apdex values for applications or user actions on a dashboard.

Currently (Feb 2024) Apdex metrics or user session data are not yet in Grail and you can't easily visualize it on the new dashboards or notebooks. For visualizing Apdex it's still recommended to use Data Explorer + Dashboard classic or USQL.
There are workarounds using JavaScript as the data source, but I highly discourage you from using them unless necessary.

Re: DQL For Apdex

amita — Fri, 09 Feb 2024 08:21:40 GMT

Understood.

Is there any chance Dynatrace is planning to get the user session data in grail in nearby future.

Re: DQL For Apdex

Julius_Loman — Fri, 09 Feb 2024 17:41:01 GMT

Yes, it will be available soon.

Re: DQL For Apdex

AgataWlodarczyk — Mon, 15 Apr 2024 11:47:24 GMT

Useful resources:
https://community.dynatrace.com/t5/Developer/ct-p/developers
https://community.dynatrace.com/t5/DQL/bd-p/dql
https://community.dynatrace.com/t5/Automations/bd-p/automations

Re: DQL For Apdex

andruccioli50 — Wed, 15 May 2024 15:24:27 GMT

Hi Julius, do you have any update on the release period of it?

Thanks in advance

Re: DQL For Apdex

apasoquen1 — Wed, 15 May 2024 15:47:40 GMT

Would you know if there are any target dates for metrics that are being moved over to grail?

Re: DQL For Apdex

Julius_Loman — Wed, 15 May 2024 20:04:16 GMT

Unfortunately not. But there was a session at Perform (recording is available at https://perform.dynatrace.com ) showing it in action.

Re: DQL For Apdex

Julius_Loman — Wed, 15 May 2024 20:05:36 GMT

No, I don't know. I believe the metrics in Grail will be available with the new frontend agents (see my post above) at least for web applications..

Re: DQL For Apdex

manos-saratsis — Wed, 19 Nov 2025 16:07:22 GMT

@amita I would suggest to have an apdex that signals good performance as a combination of Core Vitals and other metrics related to Web frontends and RUM on Grail. See below an example:

fetch user.events//|filter frontend.name ==| filter characteristics.has_page_summary == true| filter isNotNull(web_vitals.first_contentful_paint) and isNotNull(web_vitals.largest_contentful_paint) and isNotNull(web_vitals.cumulative_layout_shift) and isNotNull(web_vitals.interaction_to_next_paint)| fieldsAdd fcp_apdex = if(web_vitals.first_contentful_paint <= 1800ms, "satisfied", else: if(web_vitals.first_contentful_paint <= 3000ms, "tolerating", else: "frustrated"))| fieldsAdd lcp_apdex = if(web_vitals.largest_contentful_paint <= 2500ms, "satisfied", else: if(web_vitals.largest_contentful_paint <= 4000ms, "tolerating", else: "frustrated"))| fieldsAdd cls_apdex = if(web_vitals.cumulative_layout_shift < 0.1, "satisfied", else: if(web_vitals.cumulative_layout_shift < 0.25, "tolerating", else: "frustrated"))| fieldsAdd inp_apdex = if(web_vitals.interaction_to_next_paint <= 200ms, "satisfied", else: if(web_vitals.interaction_to_next_paint <= 500ms, "tolerating", else: "frustrated"))| fieldsAdd apdex_score = ( 0.25 * (if(fcp_apdex == "satisfied", 1, else: if(fcp_apdex == "tolerating", 0.5, else: 0))) + 0.25 * (if(lcp_apdex == "satisfied", 1, else: if(lcp_apdex == "tolerating", 0.5, else: 0))) + 0.25 * (if(cls_apdex == "satisfied", 1, else: if(cls_apdex == "tolerating", 0.5, else: 0))) + 0.25 * (if(inp_apdex == "satisfied", 1, else: if(inp_apdex == "tolerating", 0.5, else: 0))))| summarize score = avg(apdex_score)

Re: DQL For Apdex

manos-saratsis — Wed, 19 Nov 2025 16:09:06 GMT

@apasoquen1 offering an apdex metric is on our plans, I cannot give an accurate estimation but I see it in the 2nd half of 26

Re: DQL For Apdex

Mateusbmo1 — Tue, 10 Feb 2026 14:19:35 GMT

@manos-saratsis

Guys, I’m trying to use this DQL and I’m not getting any results:

fetch user.events | filter frontend.name = "Portal Bra" | filter characteristics.has_page_summary == true | filter isNotNull(web_vitals.first_contentful_paint) and isNotNull(web_vitals.largest_contentful_paint) and isNotNull(web_vitals.cumulative_layout_shift) and isNotNull(web_vitals.interaction_to_next_paint) | fieldsAdd fcp_apdex = if(web_vitals.first_contentful_paint <= 1800ms, "satisfied", else: if(web_vitals.first_contentful_paint <= 3000ms, "tolerating", else: "frustrated")) | fieldsAdd lcp_apdex = if(web_vitals.largest_contentful_paint <= 2500ms, "satisfied", else: if(web_vitals.largest_contentful_paint <= 4000ms, "tolerating", else: "frustrated")) | fieldsAdd cls_apdex = if(web_vitals.cumulative_layout_shift < 0.1, "satisfied", else: if(web_vitals.cumulative_layout_shift < 0.25, "tolerating", else: "frustrated")) | fieldsAdd inp_apdex = if(web_vitals.interaction_to_next_paint <= 200ms, "satisfied", else: if(web_vitals.interaction_to_next_paint <= 500ms, "tolerating", else: "frustrated")) | fieldsAdd apdex_score = ( 0.25 * (if(fcp_apdex == "satisfied", 1, else: if(fcp_apdex == "tolerating", 0.5, else: 0))) + 0.25 * (if(lcp_apdex == "satisfied", 1, else: if(lcp_apdex == "tolerating", 0.5, else: 0))) + 0.25 * (if(cls_apdex == "satisfied", 1, else: if(cls_apdex == "tolerating", 0.5, else: 0))) + 0.25 * (if(inp_apdex == "satisfied", 1, else: if(inp_apdex == "tolerating", 0.5, else: 0))) ) | summarize score = avg(apdex_score)

When i use:

| filter dt.entity.application == "APPLICATION-F928FCDC7F9E61E8"

i also don’t get any results, other than null