<?xml version="1.0" encoding="UTF-8"?>
<rss xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:rdf="http://www.w3.org/1999/02/22-rdf-syntax-ns#" xmlns:taxo="http://purl.org/rss/1.0/modules/taxonomy/" version="2.0">
  <channel>
    <title>topic Re: adding a DQL filter in Dashboarding</title>
    <link>https://community.dynatrace.com/t5/Dashboarding/Adding-a-DQL-filter/m-p/223962#M3283</link>
    <description>&lt;P&gt;I think you're confusing terms here, what you're using in your screenshot is a&amp;nbsp;&lt;A title="metric selector URL" href="https://www.dynatrace.com/support/help/dynatrace-api/environment-api/metric-v2/metric-selector" target="_blank" rel="noopener"&gt;metric selector&lt;/A&gt;, which doesn't use DQL. Inside that metric selector, you're using a filter which follows the syntax &amp;lt;dimension, value&amp;gt; where dimension is the metric dimension to filter by and value if the value used to filter that dimension. The value seems to look fine, as it's an entity selector that selects some specific process group instances. However, the dimension is wrong as the metric &lt;STRONG&gt;builtin:tech.jvm.memory.gc.suspensionTime&lt;/STRONG&gt; does not have a dimension with value&amp;nbsp;&lt;STRONG&gt;builtin:tech.jvm.memory.gc.suspensionTime&lt;/STRONG&gt;. Instead, your filter should look like: filter(and(or(in(&lt;STRONG&gt;"dt.entity.process_group_instance"&lt;/STRONG&gt;,&amp;lt;value&amp;gt;), since&amp;nbsp;&lt;STRONG&gt;dt.entity.process_group_instance&lt;/STRONG&gt; is an actual dimension of the metric.&lt;/P&gt;</description>
    <pubDate>Wed, 27 Sep 2023 09:20:37 GMT</pubDate>
    <dc:creator>victor_balbuena</dc:creator>
    <dc:date>2023-09-27T09:20:37Z</dc:date>
    <item>
      <title>Adding a DQL filter</title>
      <link>https://community.dynatrace.com/t5/Dashboarding/Adding-a-DQL-filter/m-p/223961#M3282</link>
      <description>&lt;P&gt;I have JVM dashboard and I want to get rid of an extra GC process that shows in the dashboard,&amp;nbsp;&lt;/P&gt;
&lt;P&gt;I've created a filter using the DQL but I get a warning&lt;/P&gt;
&lt;P&gt;&amp;nbsp;&lt;/P&gt;
&lt;P&gt;&lt;span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="Jamz_0-1695806051427.png" style="width: 999px;"&gt;&lt;img src="https://community.dynatrace.com/t5/image/serverpage/image-id/14308iC9454A28FDAE916A/image-size/large?v=v2&amp;amp;px=999" role="button" title="Jamz_0-1695806051427.png" alt="Jamz_0-1695806051427.png" /&gt;&lt;/span&gt;&lt;/P&gt;
&lt;P&gt;Does anyone know what this is? &lt;BR /&gt;"dimension Key has been referenced, but the metric has no such key&lt;/P&gt;</description>
      <pubDate>Tue, 03 Oct 2023 18:19:32 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/Dashboarding/Adding-a-DQL-filter/m-p/223961#M3282</guid>
      <dc:creator>Jamz</dc:creator>
      <dc:date>2023-10-03T18:19:32Z</dc:date>
    </item>
    <item>
      <title>Re: adding a DQL filter</title>
      <link>https://community.dynatrace.com/t5/Dashboarding/Adding-a-DQL-filter/m-p/223962#M3283</link>
      <description>&lt;P&gt;I think you're confusing terms here, what you're using in your screenshot is a&amp;nbsp;&lt;A title="metric selector URL" href="https://www.dynatrace.com/support/help/dynatrace-api/environment-api/metric-v2/metric-selector" target="_blank" rel="noopener"&gt;metric selector&lt;/A&gt;, which doesn't use DQL. Inside that metric selector, you're using a filter which follows the syntax &amp;lt;dimension, value&amp;gt; where dimension is the metric dimension to filter by and value if the value used to filter that dimension. The value seems to look fine, as it's an entity selector that selects some specific process group instances. However, the dimension is wrong as the metric &lt;STRONG&gt;builtin:tech.jvm.memory.gc.suspensionTime&lt;/STRONG&gt; does not have a dimension with value&amp;nbsp;&lt;STRONG&gt;builtin:tech.jvm.memory.gc.suspensionTime&lt;/STRONG&gt;. Instead, your filter should look like: filter(and(or(in(&lt;STRONG&gt;"dt.entity.process_group_instance"&lt;/STRONG&gt;,&amp;lt;value&amp;gt;), since&amp;nbsp;&lt;STRONG&gt;dt.entity.process_group_instance&lt;/STRONG&gt; is an actual dimension of the metric.&lt;/P&gt;</description>
      <pubDate>Wed, 27 Sep 2023 09:20:37 GMT</pubDate>
      <guid>https://community.dynatrace.com/t5/Dashboarding/Adding-a-DQL-filter/m-p/223962#M3283</guid>
      <dc:creator>victor_balbuena</dc:creator>
      <dc:date>2023-09-27T09:20:37Z</dc:date>
    </item>
  </channel>
</rss>

