Data Explorer - Metrics - default()

[EvaWang]

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?

[Eric_Yu · Accepted solution]

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

[EvaWang]

It works, thank you so much!