Create Metrics from Raw DQL (Not Logs or BizEvents)

[DanielS]

Hello Community,

From another post I was wondering if there is a possibility of create metrics from raw DQL.

What I call raw DQL?, well when logs or biz events is not in the source. I see that I can create metrics from a DQL where the use case is Logs or BizEvents applying metrics extraction. But what happens if I have a query like this?:

fetch dt.entity.service
| filter runs_on[dt.entity.process_group] == "PROCESS_GROUP-6E6F69FC1108F0E7"
|  summarize count()

Can I create a metric from a query where the fetch is not followed by logs or bizevents?

I couldn't find this case in the documentation. Is there a roadmap to add this in case it's not already possible? Or I can create an Idea.

Thanks,

[DanielS]

I leave the link to the Idea:

https://community.dynatrace.com/t5/Product-ideas/RFE-Create-Custom-Metrics-from-Raw-DQL/idi-p/233074

Thanks for your vote!!! 

[gbaudart]

I voted because it would be great 😉

[Delary]

Hey guys, hope you are good!!

@DanielS, have you figured out how to achieve this? I have a similar case where I have logs from two different sources and I can correlate these two log lines using DQL Lookup and I'd like to create a metric from the result of this DQL query to track this metric over time and use it in dashboards, etc.

I saw from your RFE, in this answer, that this is possible using Workflow and JS to call the ingest API, but I'm wondering if this is the best way to do this or if there is another OTB way.

Thanks for your help!! 🚀 😉