topic Re: API Metrics Query - Can you filter by value? in Dynatrace API

API Metrics Query - Can you filter by value?

crabbylou — Fri, 03 Nov 2023 18:06:03 GMT

I am pulling back average CPU for a few thousand servers for 1 week. I basically get 1 entry and 1 value per server.

Can I filter out all entries below a certain value?

builtin:host.cpu.usage:names:splitBy("dt.entity.host.name"):avg:sort(value(avg,descending)):limit(10000)

I really only want anything above 80.

My reason is because Dynatrace is cutting me off with a warning:

dynatrace-warning: Metric data is missing from the result! The query was limited to 10 000 000 data points.

Any advice is appreciated.

Lou

Re: API Metrics Query - Can you filter by value?

victor_balbuena — Fri, 03 Nov 2023 18:32:37 GMT

You're looking at using the partition transformation on the metric selector. With this transformation, you create a new dimension for a datapoint, which can be something like cpuhigh that is "yes" when the value is above 80. The rest of the datapoints will be ignored by the metric selector.

See my example where any datapoint below 80 is discarded:

Re: API Metrics Query - Can you filter by value?

crabbylou — Fri, 03 Nov 2023 21:32:56 GMT

Thank you Victor, I will give this a try.