# \#data-explorer **URL:** https://community.dynatrace.com/tag/data-explorer/71.md [Latest](https://community.dynatrace.com/latest.md) · [Categories](https://community.dynatrace.com/categories.md) · [Tags](https://community.dynatrace.com/tags.md) --- ## [how to create dql to check database failed connection](https://community.dynatrace.com/t/how-to-create-dql-to-check-database-failed-connection/51041)
**Author:** [@heramb\_sawant](https://community.dynatrace.com/u/heramb_sawant)\ **Replies:** 3\ **Last updated:** [October 13, 2026, 7:12am UTC](https://community.dynatrace.com/t/how-to-create-dql-to-check-database-failed-connection/51041 "2026-10-13T07:12:12Z")
Hi have created dashboard tile using builtin:service.dbconnections.failure, this shows failed connection count. I want to imeplement the same using DQL , how I can do that. I did not find matching key in grail metric … --- ## [Data Explorer vs. Host Overview – Difference in Host Availability % for AIX Servers](https://community.dynatrace.com/t/data-explorer-vs-host-overview-difference-in-host-availability-for-aix-servers/57087)
**Author:** [@Sohel\_Rashid](https://community.dynatrace.com/u/Sohel_Rashid)\ **Replies:** 1\ **Last updated:** [October 7, 2026, 10:38pm UTC](https://community.dynatrace.com/t/data-explorer-vs-host-overview-difference-in-host-availability-for-aix-servers/57087 "2026-10-07T22:38:21Z")
Hi Dynatrace Community, We are observing a significant difference in the Host Availability % between Data Explorer and the Host Overview page for some AIX servers. Environment OS: AIX Hosts: UPI DB1 / UPI DB2 Time per… --- ## [Create a dashboard with 2 days timeframe, but users can on top of this restrict it to 30 minutes](https://community.dynatrace.com/t/create-a-dashboard-with-2-days-timeframe-but-users-can-on-top-of-this-restrict-it-to-30-minutes/56883)
**Author:** [@ArneV](https://community.dynatrace.com/u/ArneV)\ **Replies:** 3\ **Last updated:** [September 8, 2026, 11:36am UTC](https://community.dynatrace.com/t/create-a-dashboard-with-2-days-timeframe-but-users-can-on-top-of-this-restrict-it-to-30-minutes/56883 "2026-09-08T11:36:55Z")
This is a bit funny question. We want to enable a certain group of people to only view a limited amount of servers, this is the easy part. However we also want to ensure that this group only can watch data 2days back, … --- ## [Live sessions metric with sum aggregation](https://community.dynatrace.com/t/live-sessions-metric-with-sum-aggregation/56580)
**Author:** [@elenaperez](https://community.dynatrace.com/u/elenaperez)\ **Replies:** 0\ **Last updated:** [July 28, 2026, 8:46am UTC](https://community.dynatrace.com/t/live-sessions-metric-with-sum-aggregation/56580 "2026-07-28T08:46:56Z")
Hi team, When we go to a specific process and check the live sessions, we see 18 However, when we check with the data explorer we see different numbers (108 with Sum and 3.6 with Average) The only way we can … --- ## [k8s.workload.name not working in new explorer](https://community.dynatrace.com/t/k8s-workload-name-not-working-in-new-explorer/56522)
**Author:** [@kohls](https://community.dynatrace.com/u/kohls)\ **Replies:** 1\ **Last updated:** [July 22, 2026, 6:24am UTC](https://community.dynatrace.com/t/k8s-workload-name-not-working-in-new-explorer/56522 "2026-07-22T06:24:13Z")
In new Explorer under service I an not able to use the filter “k8s.workload.name”, is there any equivalent variable I should be using in this new explore --- ## [Memory (or what ever resource) used per Process Group](https://community.dynatrace.com/t/memory-or-what-ever-resource-used-per-process-group/56028)
**Author:** [@gilles\_tabary](https://community.dynatrace.com/u/gilles_tabary)\ **Replies:** 2\ **Last updated:** [June 3, 2026, 11:32am UTC](https://community.dynatrace.com/t/memory-or-what-ever-resource-used-per-process-group/56028 "2026-06-03T11:32:14Z")
Hello. I have a very simple question : what is my top Process Group memory consumers ? Yet, I must be missing something very obvious because I find no way to do it. It is easy to do it at Process Group Instance level. … --- ## [Data Explorer in new tenants?](https://community.dynatrace.com/t/data-explorer-in-new-tenants/55418)
**Author:** [@AntonioSousa](https://community.dynatrace.com/u/AntonioSousa)\ **Replies:** 10\ **Last updated:** [May 27, 2026, 5:59pm UTC](https://community.dynatrace.com/t/data-explorer-in-new-tenants/55418 "2026-05-27T17:59:37Z")
I have a new tenant, but with no Data Explorer. Even the graphs in Unified Analysis View show the Data Explorer type, and even if I put /ui/apps/dynatrace.classic.data.explorer/ui/data-explorer in the URL, it shows br… --- ## [Adding mssql server monitoring to dashboard](https://community.dynatrace.com/t/adding-mssql-server-monitoring-to-dashboard/36526)
**Author:** [@leonatay](https://community.dynatrace.com/u/leonatay)\ **Replies:** 5\ **Last updated:** [April 9, 2026, 12:46pm UTC](https://community.dynatrace.com/t/adding-mssql-server-monitoring-to-dashboard/36526 "2026-04-09T12:46:56Z")
I’ve already configured my monitoring endpoint for mssql server extension, how do I add them to dashboard? --- ## [Incorrect split of IBM MQ channel instances?](https://community.dynatrace.com/t/incorrect-split-of-ibm-mq-channel-instances/55488)
**Author:** [@leungw](https://community.dynatrace.com/u/leungw)\ **Replies:** 1\ **Last updated:** [April 7, 2026, 2:53pm UTC](https://community.dynatrace.com/t/incorrect-split-of-ibm-mq-channel-instances/55488 "2026-04-07T14:53:28Z")
Does the IBM MQ extension map count the channel instances per sub-state correctly? When have a rather strange “Data explorer” view when monitoring a certain MQ channel and amount if instances. Initially, we are \*only\* i… --- ## [Throughput: Understanding RPS/TPS Metrics](https://community.dynatrace.com/t/throughput-understanding-rps-tps-metrics/55211)
**Author:** [@zietho](https://community.dynatrace.com/u/zietho)\ **Replies:** 0\ **Last updated:** [March 9, 2026, 10:01am UTC](https://community.dynatrace.com/t/throughput-understanding-rps-tps-metrics/55211 "2026-03-09T10:01:07Z")
Learn how to calculate and visualize throughput (Requests per Second / Transactions per Second) using Dynatrace metrics. This article explains which metrics to use, how RPS is derived, and how to build clean throughput t… --- ## [Exploring data in Dynatrace: From metrics to dashboard tiles](https://community.dynatrace.com/t/exploring-data-in-dynatrace-from-metrics-to-dashboard-tiles/55200)
**Author:** [@zietho](https://community.dynatrace.com/u/zietho)\ **Replies:** 0\ **Last updated:** [March 6, 2026, 11:56am UTC](https://community.dynatrace.com/t/exploring-data-in-dynatrace-from-metrics-to-dashboard-tiles/55200 "2026-03-06T11:56:33Z")
This guide walks you through exploring and visualizing metrics in Dynatrace. From browsing metrics to narrowing your scope with filters, comparing entities with Split by, and keeping charts readable with limits and sort… --- ## [Issue with missing metric data in DataExplorer - "Metric data is missing from the result!"](https://community.dynatrace.com/t/issue-with-missing-metric-data-in-dataexplorer-metric-data-is-missing-from-the-result/50640)
**Author:** [@NicoleMT](https://community.dynatrace.com/u/NicoleMT)\ **Replies:** 3\ **Last updated:** [February 16, 2026, 8:01am UTC](https://community.dynatrace.com/t/issue-with-missing-metric-data-in-dataexplorer-metric-data-is-missing-from-the-result/50640 "2026-02-16T08:01:57Z")
Hello Dynatrace Community, I am encountering an issue when querying metrics in DataExplorer. When attempting to retrieve data for a specific metric, I receive the following error message: “Metric data is missing from t… --- ## [Understanding Dynatrace service.requestCount metrics (total vs client vs server)](https://community.dynatrace.com/t/understanding-dynatrace-service-requestcount-metrics-total-vs-client-vs-server/54946)
**Author:** [@R928492](https://community.dynatrace.com/u/R928492)\ **Replies:** 0\ **Last updated:** [February 10, 2026, 2:58pm UTC](https://community.dynatrace.com/t/understanding-dynatrace-service-requestcount-metrics-total-vs-client-vs-server/54946 "2026-02-10T14:58:39Z")
We would like to understand the difference between the below three query of DT inbuilt matrices : builtin:service.requestCount.total:filter(and(or(in(“dt.entity.service”,entitySelector(“type(service),entityName.equals(~… --- ## [Determine Separate Memory Usage of Processes](https://community.dynatrace.com/t/determine-separate-memory-usage-of-processes/54726)
**Author:** [@habib\_ali](https://community.dynatrace.com/u/habib_ali)\ **Replies:** 0\ **Last updated:** [January 23, 2026, 6:46am UTC](https://community.dynatrace.com/t/determine-separate-memory-usage-of-processes/54726 "2026-01-23T06:46:26Z")
Hi, On Exadata Node 1, we are observing that the reported process-level memory consumption appears to exceed the available physical memory on the host. While reviewing the Dynatrace metrics available to us, we found th… --- ## [No Prometheus histogram Metrics found](https://community.dynatrace.com/t/no-prometheus-histogram-metrics-found/47490)
**Author:** [@icarus](https://community.dynatrace.com/u/icarus)\ **Replies:** 2\ **Last updated:** [January 19, 2026, 6:17pm UTC](https://community.dynatrace.com/t/no-prometheus-histogram-metrics-found/47490 "2026-01-19T18:17:56Z")
I deployed the dynatrace-operator in my k8s cluster and use the annotations to monitor my workloads. However, I can’t found the prometheus histogram type metrics in the Data Explorer. Here’s my instance: “envoy\_http\_d… --- ## [Entity Selector - Service to Service Relationship](https://community.dynatrace.com/t/entity-selector-service-to-service-relationship/54488)
**Author:** [@Theodore\_x86](https://community.dynatrace.com/u/Theodore_x86)\ **Replies:** 8\ **Last updated:** [December 31, 2025, 8:18am UTC](https://community.dynatrace.com/t/entity-selector-service-to-service-relationship/54488 "2025-12-31T08:18:42Z")
Hello. I am struggling to create a REQUEST COUNT metric for the Services targeting, all Services that run on specific hosts (filter by hostname, eg. contains(“something”)). BR --- ## [Dashboard with problem notifications on Linux instances for Dynatrace Managed](https://community.dynatrace.com/t/dashboard-with-problem-notifications-on-linux-instances-for-dynatrace-managed/54463)
**Author:** [@skhamitkar](https://community.dynatrace.com/u/skhamitkar)\ **Replies:** 1\ **Last updated:** [December 22, 2025, 2:28pm UTC](https://community.dynatrace.com/t/dashboard-with-problem-notifications-on-linux-instances-for-dynatrace-managed/54463 "2025-12-22T14:28:13Z")
Dear Community, I need your help in creating dashboard for problem notification. Scenario: I have 2 Linux instances instance1 and instance2 I want to create a dashboard which will tell me how many problems were report… --- ## [Classic dashboard not showing the format as data explorer shows](https://community.dynatrace.com/t/classic-dashboard-not-showing-the-format-as-data-explorer-shows/47550)
**Author:** [@Yosi\_Neuman](https://community.dynatrace.com/u/Yosi_Neuman)\ **Replies:** 4\ **Last updated:** [December 20, 2025, 7:22am UTC](https://community.dynatrace.com/t/classic-dashboard-not-showing-the-format-as-data-explorer-shows/47550 "2025-12-20T07:22:40Z")
Hi guys, Customer asked to show metric that holds information in seconds in day:hours:minuts:secounds format We used toUnit format and with in the data explorer its look grate 🤗 However when saving it to tile on d… --- ## [Compatibility and Migration of Classic Dashboards to Grail](https://community.dynatrace.com/t/compatibility-and-migration-of-classic-dashboards-to-grail/51980)
**Author:** [@jorgecaetsilva](https://community.dynatrace.com/u/jorgecaetsilva)\ **Replies:** 1\ **Last updated:** [December 20, 2025, 7:15am UTC](https://community.dynatrace.com/t/compatibility-and-migration-of-classic-dashboards-to-grail/51980 "2025-12-20T07:15:00Z")
I would like to highlight an important concern related to the migration of dashboards from the classic version to the new version based on Grail. We currently have several dashboards built in the classic version, and we… --- ## [Entity Selector with Open Telemetry Metrics](https://community.dynatrace.com/t/entity-selector-with-open-telemetry-metrics/54347)
**Author:** [@prabalr](https://community.dynatrace.com/u/prabalr)\ **Replies:** 1\ **Last updated:** [December 10, 2025, 7:16am UTC](https://community.dynatrace.com/t/entity-selector-with-open-telemetry-metrics/54347 "2025-12-10T07:16:32Z")
Hello All, I am using the Dynatrace Data Explorer (and not DQL) to evaluate this expression bdc.fos.lcm.dataproduct.status.count.gauge:filter(eq(“status”, “PROVISIONING”)):splitBy(region, environment) + bdc.fos.lcm.d… --- ## [How to create a Dashboard for Process Group Instances of a Specific Service](https://community.dynatrace.com/t/how-to-create-a-dashboard-for-process-group-instances-of-a-specific-service/54012)
**Author:** [@AntonPineiro](https://community.dynatrace.com/u/AntonPineiro)\ **Replies:** 2\ **Last updated:** [November 7, 2025, 8:17am UTC](https://community.dynatrace.com/t/how-to-create-a-dashboard-for-process-group-instances-of-a-specific-service/54012 "2025-11-07T08:17:03Z")
Hi, Do I have an easy way to create a dashboard with how many process group instances a specific service has? It can be in Classic Data Explorer or new dashboards using Grail. Best regards --- ## [How can I see the count of running process and add a default value 0 if process is not running?](https://community.dynatrace.com/t/how-can-i-see-the-count-of-running-process-and-add-a-default-value-0-if-process-is-not-running/53886)
**Author:** [@Arunkumarbnp](https://community.dynatrace.com/u/Arunkumarbnp)\ **Replies:** 2\ **Last updated:** [October 28, 2025, 6:19am UTC](https://community.dynatrace.com/t/how-can-i-see-the-count-of-running-process-and-add-a-default-value-0-if-process-is-not-running/53886 "2025-10-28T06:19:03Z")
I’ve created a metric to display the count of process running in host builtin:pgi.availability.state:filter(and(or(in(“dt.entity.process\_group”,entitySelector(“type(process\_group),entityName(~“procesname~”)”))))):splitB… --- ## [Extract the total time that CPU was in saturation for Data Explorer](https://community.dynatrace.com/t/extract-the-total-time-that-cpu-was-in-saturation-for-data-explorer/53584)
**Author:** [@Taz](https://community.dynatrace.com/u/Taz)\ **Replies:** 2\ **Last updated:** [October 10, 2025, 10:12am UTC](https://community.dynatrace.com/t/extract-the-total-time-that-cpu-was-in-saturation-for-data-explorer/53584 "2025-10-10T10:12:37Z")
I am using the built in: builtin:host.cpu.usage:splitBy(“dt.entity.host”):sort(value(auto,descending)):limit(20) which give me when the CPU goes to 100% but I want to know the duration of the event. --- ## [Dashboard tile showing Hosts currently in an Unmonitored state](https://community.dynatrace.com/t/dashboard-tile-showing-hosts-currently-in-an-unmonitored-state/53374)
**Author:** [@Ronald](https://community.dynatrace.com/u/Ronald)\ **Replies:** 7\ **Last updated:** [September 24, 2025, 9:55am UTC](https://community.dynatrace.com/t/dashboard-tile-showing-hosts-currently-in-an-unmonitored-state/53374 "2025-09-24T09:55:30Z")
In Dynatrace Managed, I’m trying to use the Metric Host Availability State to show currently unmonitored hosts builtin:host.availability.state:filter(eq(“availability.state”,“unmonitored\_agent\_stopped”)):splitBy(“host.n… --- ## [How to filter built-in CPU usage metric by cluster and namespace and get max per workload?](https://community.dynatrace.com/t/how-to-filter-built-in-cpu-usage-metric-by-cluster-and-namespace-and-get-max-per-workload/53233)
**Author:** [@Aboud1](https://community.dynatrace.com/u/Aboud1)\ **Replies:** 4\ **Last updated:** [September 16, 2025, 5:12am UTC](https://community.dynatrace.com/t/how-to-filter-built-in-cpu-usage-metric-by-cluster-and-namespace-and-get-max-per-workload/53233 "2025-09-16T05:12:53Z")
Hi Community, I’m using the built-in metric query in Dynatrace for CPU usage per workload, for example: builtin:containers.cpu.usageMilliCores:filter(in(“dt.entity.container\_group\_instance”, entitySelector(“type(CONTAI… --- ## [Add custom dimension using partition](https://community.dynatrace.com/t/add-custom-dimension-using-partition/52870)
**Author:** [@Vijayt](https://community.dynatrace.com/u/Vijayt)\ **Replies:** 4\ **Last updated:** [August 18, 2025, 4:39pm UTC](https://community.dynatrace.com/t/add-custom-dimension-using-partition/52870 "2025-08-18T16:39:01Z")
we are using infrastructure mode and have only access to classic dashboard i am trying to group processes. and trying to find out unusual process to highlight for example. Tag OS process instance a tag , scanning p… --- ## [Dynatrace Costings Dashboard](https://community.dynatrace.com/t/dynatrace-costings-dashboard/52912)
**Author:** [@badgerfifteen](https://community.dynatrace.com/u/badgerfifteen)\ **Replies:** 2\ **Last updated:** [August 13, 2025, 4:39pm UTC](https://community.dynatrace.com/t/dynatrace-costings-dashboard/52912 "2025-08-13T16:39:09Z")
Hi all, Is there a dashboard which shows things like full-stack host usage, infrastructure monitoring and associated costs? --- ## [Metrics to show called services and called by request counts](https://community.dynatrace.com/t/metrics-to-show-called-services-and-called-by-request-counts/41401)
**Author:** [@jnernest](https://community.dynatrace.com/u/jnernest)\ **Replies:** 4\ **Last updated:** [August 4, 2025, 11:24am UTC](https://community.dynatrace.com/t/metrics-to-show-called-services-and-called-by-request-counts/41401 "2025-08-04T11:24:38Z")
Hi Team, Currently we have lot of services(consider A,B,C) calling a particular services(X) we want to know the request count made by each services(A to X like wise B to X so..on) to be displayed on dashboard. Can we u… --- ## [Moving average and referring previous value in Dashboard](https://community.dynatrace.com/t/moving-average-and-referring-previous-value-in-dashboard/52725)
**Author:** [@Vijayt](https://community.dynatrace.com/u/Vijayt)\ **Replies:** 2\ **Last updated:** [August 1, 2025, 9:33pm UTC](https://community.dynatrace.com/t/moving-average-and-referring-previous-value-in-dashboard/52725 "2025-08-01T21:33:57Z")
is there any option to calculate moving average \[avg transformation? \] and any option to compare with previous data points/aggregation values for example i want to compare last 1 max memory is greater than current ma… --- ## [How to display total problems with duration \>30 min on a Classic Dashboard?](https://community.dynatrace.com/t/how-to-display-total-problems-with-duration-30-min-on-a-classic-dashboard/52770)
**Author:** [@Ahmedrahbi](https://community.dynatrace.com/u/Ahmedrahbi)\ **Replies:** 1\ **Last updated:** [August 1, 2025, 8:46pm UTC](https://community.dynatrace.com/t/how-to-display-total-problems-with-duration-30-min-on-a-classic-dashboard/52770 "2025-08-01T20:46:55Z")
Hello community, I’d like to create a dashboard widget in the old Dynatrace version that shows the total number of problems where the duration is more than 30 minutes. Is there a built-in metric for this, or can it onl… [Next page](https://community.dynatrace.com/tag/data-explorer/71.md?match_all_tags=true&page=1&tags%5B%5D=data-explorer)