topic Re: Create a Metric from a value other than DQL Matcher in DQL

Create a Metric from a value other than DQL Matcher

DanielS — Thu, 18 Dec 2025 14:25:55 GMT

Hello Community,

I need to create a metric from a value using the countDistinct function and to save that value over time, the DQL query is the following:

fetch logs | FILTER matchesValue(k8s.container.name, "onboarding-service") AND matchesPhrase(content, "\"result\":\"ok\",\"step\":\"cvu\"") AND matchesPhrase(content, "triggering next step with state machine") | summarize countDistinct(client.id), alias: CvuCreadoPorCliente

but metric extraction only supports https://docs.dynatrace.com/docs/shortlink/lma-log-processing-matcher

any other idea to do this?

Thanks

Re: Create a Metric from a value other than DQL Matcher

_r_k_ — Mon, 15 Jul 2024 08:37:58 GMT

any update please for this or any summarization in log processing (some example etc)?

Re: Create a Metric from a value other than DQL Matcher

krzysztof_hoja — Mon, 15 Jul 2024 19:48:36 GMT

I can imagine some possible solutions (or rather workarounds)....
What is the cardinality of client.id? How many of them are active in the same moment (e.g. in 1 minute)? What is the desired time resolution for this metric (does it have to be 1 minute or maybe 1h is good enough?)

Re: Create a Metric from a value other than DQL Matcher

_r_k_ — Tue, 16 Jul 2024 06:49:26 GMT

if you are thinking about recreating timestamps based on interval and timespan it is too crazy to be used for dynamic dashboards

Re: Create a Metric from a value other than DQL Matcher

krzysztof_hoja — Tue, 16 Jul 2024 16:05:08 GMT

Not thinking about it at all....

But answering your question regarding examples for summarization in log processing:
https://docs.dynatrace.com/docs/observe-and-explore/logs/lma-use-cases/lma-e2e-create-log-metric#lma-uc-create-connections-refused-metric

or if you use OpenPipeline already:

https://docs.dynatrace.com/docs/platform/openpipeline/use-cases/tutorial-log-processing-pipeline

My question was toward: how we can use supported summarizations (sum or count) to get data with reduced volume enough but still detailed enough to calculate countDistinct

Re: Create a Metric from a value other than DQL Matcher

ANLTH — Wed, 16 Oct 2024 12:50:31 GMT

I have a similar challenge. I would like to create a Metric for "SynchronizationTime" it is the sum of

(ResponseTimestamp - EventTimestamp)/1000

My DQL running directly on the Logs looks like this:

fetch logs
| filter query.name == "IntegrationLog"
| fieldsAdd Synctime = (c_ResponseTimestamp__c-c_EventTimestamp__c)/1000

Re: Create a Metric from a value other than DQL Matcher

wellpplava — Thu, 07 Aug 2025 03:25:57 GMT

Hi there!

We’re working on a metric to count distinct users per page. We initially tried using UserId and Page.name as dimensions, but ran into issues with high cardinality.

Would you be open to sharing any ideas or suggestions on how we might approach this more efficiently?

Re: Create a Metric from a value other than DQL Matcher

IzabelaRokita — Thu, 18 Dec 2025 14:25:15 GMT

Hey @DanielS @ANLTH ,
I just wanted to check in and see if you still need help with this. If so, I’d be happy to look into it for you! 😊
Please let me know what works best for you.

Re: Create a Metric from a value other than DQL Matcher

DanielS — Thu, 18 Dec 2025 18:03:04 GMT

Hi @IzabelaRokita I've created this idea