https://community.dynatrace.com/t5/DQL/How-to-filter-top-Davis-forecast-values/m-p/285224#M2546 <P>hey&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/47129">@jegron</a>&nbsp;. So are you looking to keep the limit of 100? If you want to target the top X hosts, I recommend reducing your Limit, and then adding in:&nbsp;</P><LI-CODE lang="markup">| sort `avg(dt.host.disk.used.percent)` desc</LI-CODE><P>This will allow you to sort the values so the most used is on top and descends from there. You can keep the limit of 100 but it might get a tad bit messy. You can then add in the Davis forecaster via the options.&nbsp;</P><P>Here is an example:&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ChadTurner_0-1756817900757.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/29917i0CEED5160926E56B/image-size/medium?v=v2&amp;px=400" role="button" title="ChadTurner_0-1756817900757.png" alt="ChadTurner_0-1756817900757.png" /></span></P><P>&nbsp;</P> Tue, 02 Sep 2025 12:59:36 GMT ChadTurner 2025-09-02T12:59:36Z https://community.dynatrace.com/t5/DQL/How-to-filter-top-Davis-forecast-values/m-p/248191#M978 <P>Hi,</P> <P>I would like to create a metrics timeseries and then filter out only the top dt.davis.forecast:point values.</P> <P>How can I do that?</P> <P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="jegron_1-1718213101125.png" style="width: 873px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/20517iED38F4912F453579/image-dimensions/873x452?v=v2" width="873" height="452" role="button" title="jegron_1-1718213101125.png" alt="jegron_1-1718213101125.png" /></span></P> <P>&nbsp;</P> <P>&nbsp;</P> Thu, 18 Dec 2025 14:22:23 GMT https://community.dynatrace.com/t5/DQL/How-to-filter-top-Davis-forecast-values/m-p/248191#M978 jegron 2025-12-18T14:22:23Z https://community.dynatrace.com/t5/DQL/How-to-filter-top-Davis-forecast-values/m-p/285224#M2546 <P>hey&nbsp;<a href="https://community.dynatrace.com/t5/user/viewprofilepage/user-id/47129">@jegron</a>&nbsp;. So are you looking to keep the limit of 100? If you want to target the top X hosts, I recommend reducing your Limit, and then adding in:&nbsp;</P><LI-CODE lang="markup">| sort `avg(dt.host.disk.used.percent)` desc</LI-CODE><P>This will allow you to sort the values so the most used is on top and descends from there. You can keep the limit of 100 but it might get a tad bit messy. You can then add in the Davis forecaster via the options.&nbsp;</P><P>Here is an example:&nbsp;</P><P><span class="lia-inline-image-display-wrapper lia-image-align-inline" image-alt="ChadTurner_0-1756817900757.png" style="width: 400px;"><img src="https://community.dynatrace.com/t5/image/serverpage/image-id/29917i0CEED5160926E56B/image-size/medium?v=v2&amp;px=400" role="button" title="ChadTurner_0-1756817900757.png" alt="ChadTurner_0-1756817900757.png" /></span></P><P>&nbsp;</P> Tue, 02 Sep 2025 12:59:36 GMT https://community.dynatrace.com/t5/DQL/How-to-filter-top-Davis-forecast-values/m-p/285224#M2546 ChadTurner 2025-09-02T12:59:36Z