https://community.dynatrace.com/t5/Automations/Split-metrics-and-SLOs-by-tag/m-p/205068#M1122 <P>Hey Andrew,<BR />From what I've seen this will be possible once metrics on Grail rolls around allowing for DQL queries against metrics. I haven't found a workaround in the current metric selector.<BR /><BR />Looking at this blog post,&nbsp;<A href="https://www.dynatrace.com/news/blog/boundless-exploratory-observability-and-security-analytics/" target="_blank">Expanded Grail data lakehouse and new Dynatrace user experience unlock boundless analytics | Dynatrace news</A>, I reckon to do something like splitting by a parameter the DQL would look something like:</P> <LI-CODE lang="markup">fetch dt.entity.host | lookup [fetch metrics | filter metric.key == "dt.host.cpu.system" | summarize avg = avg(value), by:dt.entity.host], sourceField:entityId, lookupField:dt.entity.host | summarize avg(lookup.avg), by:{cpuCores}</LI-CODE> <P>The above example would splitBy core count.<BR /><BR /></P> Mon, 20 Feb 2023 04:43:51 GMT Fin_Ubels 2023-02-20T04:43:51Z https://community.dynatrace.com/t5/Automations/Split-metrics-and-SLOs-by-tag/m-p/205066#M1121 <DIV class="postcell post-layout--right"> <DIV class="s-prose js-post-body"> <P>I am looking to&nbsp;<A href="https://www.dynatrace.com/support/help/shortlink/api-metrics-v2-selector#splitby" target="_blank" rel="nofollow noopener noreferrer">splitBy</A>&nbsp;a tag for a metric expression to generate one SLO definition that covers all entities.</P> <P>The use-case is instead of having hundreds of metrics/SLOs defined per tag value (i.e. using a filter), to instead split by the tag.</P> <P>On the metricsSelector, I can only seem to splitBy an available dimension and tags is not one of these. Is this use-case possible, or are multiple entitySelectors with filters for each tagging value necessary?</P> <P>Did anyone have examples of how they solved this before?</P> <P>Management zone filters the SLO dashboard tiles by the selected data, so it seems this calculation is possible. But it would have to be beyond dashboards, such as SLO alerts, etc.</P> </DIV> </DIV> Mon, 20 Feb 2023 08:31:20 GMT https://community.dynatrace.com/t5/Automations/Split-metrics-and-SLOs-by-tag/m-p/205066#M1121 The_AM 2023-02-20T08:31:20Z https://community.dynatrace.com/t5/Automations/Split-metrics-and-SLOs-by-tag/m-p/205068#M1122 <P>Hey Andrew,<BR />From what I've seen this will be possible once metrics on Grail rolls around allowing for DQL queries against metrics. I haven't found a workaround in the current metric selector.<BR /><BR />Looking at this blog post,&nbsp;<A href="https://www.dynatrace.com/news/blog/boundless-exploratory-observability-and-security-analytics/" target="_blank">Expanded Grail data lakehouse and new Dynatrace user experience unlock boundless analytics | Dynatrace news</A>, I reckon to do something like splitting by a parameter the DQL would look something like:</P> <LI-CODE lang="markup">fetch dt.entity.host | lookup [fetch metrics | filter metric.key == "dt.host.cpu.system" | summarize avg = avg(value), by:dt.entity.host], sourceField:entityId, lookupField:dt.entity.host | summarize avg(lookup.avg), by:{cpuCores}</LI-CODE> <P>The above example would splitBy core count.<BR /><BR /></P> Mon, 20 Feb 2023 04:43:51 GMT https://community.dynatrace.com/t5/Automations/Split-metrics-and-SLOs-by-tag/m-p/205068#M1122 Fin_Ubels 2023-02-20T04:43:51Z https://community.dynatrace.com/t5/Automations/Split-metrics-and-SLOs-by-tag/m-p/205275#M1123 <P>Thanks Fin</P> Wed, 22 Feb 2023 00:03:22 GMT https://community.dynatrace.com/t5/Automations/Split-metrics-and-SLOs-by-tag/m-p/205275#M1123 The_AM 2023-02-22T00:03:22Z