topic Re: How to exclude a range from calculated metric values in Dashboarding

How to exclude a range from calculated metric values

PaulE — Tue, 30 May 2023 06:26:32 GMT

I have a calculated metric for a series of nodes (in this case % memory used) - I would like to show a table of matching nodes where the calculated value is less than 20% or greater than 80%. I've got the first part working but I am unsure if filter will allow me to produce what's needed.

builtin:kubernetes.container.requests_memory:last:splitBy("dt.entity.kubernetes_container","dt.entity.kubernetes_cluster"):sum / builtin:kubernetes.container.memory_allocatable:last:splitBy("dt.entity.kubernetes_container","dt.entity.kubernetes_cluster"):sum*100):setUnit(Percent):sort(value(sum,descending))

Re: How to exclude a range from calculated metric values

Mizső — Wed, 10 May 2023 07:46:23 GMT

Hi @PaulE,

Could you please test this line in your metric expression:

:filter(or(series(avg,gt,80),series(avg,lt,20)))

Here is an example for nodes:

I hope it helps.

Best regards,

Mizső

Re: How to exclude a range from calculated metric values

PaulE — Wed, 10 May 2023 14:31:06 GMT

Thanks vary much , exactly what was needed