topic Re: Sort by ascending Code Calculated Metric - Data explorer in Open Q&A

Sort by ascending Code Calculated Metric - Data explorer

ca6iya — Wed, 02 Feb 2022 19:27:21 GMT

created free connection pool percentage on WebLogic process metrics. Cannot sort by highest percentage value. Trying to check if someone found way to resolve issue.

Metrics used for calculation

builtin:tech.weblogic.connectionPool.ActiveConnectionsCurrentCount

builtin:tech.weblogic.connectionPool.MaxCapacity

Re: Sort by ascending Code Calculated Metric - Data explorer

Dallas — Wed, 02 Feb 2022 19:43:45 GMT

Hello,

When using the data explorer you should see a "+" symbol in the UI which allows you to add the "Sort by" functionality seen here:

Once that is selected you will be able to choose Ascending or descending. I would also suggest using the "last value" selection if you are trying to see the current value being reported.

If you are trying to use the code tab then you can see under the "Sort" section there is the possibility to add "ascending" or "descending". Seen here in the metric selector documentation:

https://www.dynatrace.com/support/help/dynatrace-api/environment-api/metric-v2/metric-selector#sort

builtin:tech.weblogic.connectionPool.ActiveConnectionsCurrentCount:splitBy("dt.entity.process_group_instance"):avg:auto:sort(value(avg,descending))

Hope this helps.

Thanks

-Dallas

Re: Sort by ascending Code Calculated Metric - Data explorer

ca6iya — Wed, 02 Feb 2022 20:43:31 GMT

added last part to calculation and it worked. Thanks

:sort(value(avg,descending))*100

Re: Sort by ascending Code Calculated Metric - Data explorer

DavidB — Tue, 12 Apr 2022 16:29:36 GMT

Hello mcabiya,

could you share how did u make the metric calculation?

Thank you in advance.

Best Regards,

David

Re: Sort by ascending Code Calculated Metric - Data explorer

ca6iya — Tue, 12 Apr 2022 17:10:43 GMT

I used tag to filter process. Try adding tag or removing filter from metric.

(builtin:tech.jvm.memory.pool.used:filter(and(in("dt.entity.process_group_instance",entitySelector("type(process_group_instance),tag(~"TAG~")")))):splitBy("dt.entity.process_group_instance"))/(builtin:tech.jvm.memory.pool.max:filter(and(in("dt.entity.process_group_instance",entitySelector("type(process_group_instance),tag(~"TAG~")")))):splitBy("dt.entity.process_group_instance")):sort(value(avg,descending))*100