How to get tech.jvm.threads.totalCpuTime metric for 2 management zones in data explorer?

[Arunkumarbnp]

How to get tech.jvm.threads.totalCpuTime metric for 2 management zones in data explorer?

eg query

builtin:tech.jvm.threads.totalCpuTime

:filter(and(or(in("dt.entity.process_group_instance",entitySelector("type(process_group_instance),mzname(~"mz1~",~"mz2~")")))))
:splitBy():sort(value(auto,descending)):limit(20)

error:Metric data is missing from the result! For the dimension 'Thread group' the query was limited to the top 100 dimension values with the most data points.

[marco_irmer · Accepted solution]

You will have to alter the expression to properly make use of the or() logic. The format (with line breaks added to enhance readability) is as follows

or(
in("<entity_type>",<entitySelector expression for MZ1>),
in("<entity_type>",<entitySelector expression for MZ2>)
)

I believe this is similar to your question about synthetic tests from two management zones, where a similar approach was suggested.

[Arunkumarbnp]

ty Marco