cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Sort by ascending Code Calculated Metric - Data explorer

mcabiya
Observer

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

4 REPLIES 4

Dallas
Dynatrace Mentor
Dynatrace Mentor

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:

Dallas_0-1643830636671.png

 

 

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.

Dallas_2-1643830992208.png

 

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

 

 

added last part to calculation and it worked. Thanks

 

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

 

mcabiya_0-1643834600313.png

 

Hello mcabiya,

 

could you share how did u make the metric calculation?

 

Thank you in advance.

 

Best Regards,

David

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

Featured Posts