25 Aug 2025 12:36 PM
I am trying to extract valuable metrics that are a similar view in the application problem summary but I do not know where to extract these info from (see the screen shot)
Any DQL (or typescript) or any hint how extract this is much appreciated.
Marwan...
25 Aug 2025 11:16 PM
Hi @MarwanC ,
I would suggest to start from here:
fetch dt.davis.problems
| join [
fetch events
], on: { left[event.id] == right[event.id]}
If you give some more concrete example on what final table you expect to see I can try to help more.
Regards, Deni
27 Aug 2025 11:01 AM
Thank you Deni, I meant the name of the column for the exact metrics shown in the problems application
29 Aug 2025 07:55 AM
Thanks Deni, thanks for filling in the blanks, this is indeed what I was looking for for linking problems with number of events, and this DQL does the job now (I added the latest obe below) Hoever, I need all other data, affect infra, affected, services , SLO (see screen shot I provided above) per problem and I must have all the data in order to build the relevance model to a particular problem. I will share my finding for other to benefit, but for now here the problem vs events relevance metric, fetch dt.davis.problems
| join [
fetch events
], on: { left[event.id] == right[event.id]}
| fields event.kind, right.affected_entity_types, display_id
| summarize count(), by: display_id