Data Explorer - Metrics - default()

EvaWang — Thu, 16 May 2024 14:41:57 GMT

Good mroning,

I see the DT documentation and make a understanding of 'Default transformation' (https://docs.dynatrace.com/docs/dynatrace-api/environment-api/metric-v2/metric-selector), but I still have a question about the default(0) like below:

Same Metric except default(0):

1. without default (0) - builtin:billing.ddu.metrics.total:splitBy():sum:auto:sort(value(avg,descending))

2. with default (0) - builtin:billing.ddu.metrics.total:splitBy():sum:auto:sort(value(avg,descending)):default(0,always)

3. Compare with UI

I just want to aviod the no data situation and used default() in query, Why is there a diff in the result？Should I use it?

Re: Data Explorer - Metrics - default()

Eric_Yu — Fri, 17 May 2024 15:39:01 GMT

Can you change the fold transformation also to sum and show the result?

EvaWang — Tue, 21 May 2024 15:58:21 GMT

It works, thank you so much!