how to compare two event.metric present in Bizzevents of Grail

[heramb_sawant]

Hi
I have 2 event metric ('jvm_thread_count_test001' and 'jvm_thread_count_test002') present in bizzevent. both event.metric has  many valuesin grail. these 2 metric presents metric values of 2 Test executions.

End Goal is to compare average of jvm_thread_count_test001 against jvm_thread_count_test002 using DQL

Can somebody please guide me how to do this???


Regards,
Heramb

[heramb_sawant]

Any thoughts on my concern??

[sinisa_zubic]

Hi @heramb_sawant 

I don't fully understand the structure of your bizevent data. Is this what you are looking for:

fetch bizevents
| filter in(event.metricKey, array("jvm_thread_count_test001","jvm_thread_count_test002 "))
| summarize `average thread count` = avg(event.metric), by:{accountId}

I am assuming the "jvm_thread_count_test001" is stored in field "event.metricKey" and the jvm thread count value in "event.metric"

If my understanding is not correct, can you maybe share how your thread count bizevents records look like?

Best,
Sini