topic Re: Calculating BILLING_USAGE_EVENT data to currency in DQL

Calculating BILLING_USAGE_EVENT data to currency

janne-olkoniemi — Wed, 31 Dec 2025 12:00:12 GMT

Hello,

Could someone help me a bit with DQL queries since I'm feeling quite rusty with it currently 🙂
I would need to calculate the billing usage data on actual currency and not sure what could be the most feasible way to archive it.

I would appreciate if someone could make some example with Full-Stack Monitoring data that how to calculate and show the timeseries data in euros. How to example translate this on to currency if we would say that the cost is example 1000 € Per 100,000 memory-gibibyte-hours?

fetch dt.system.events
| filter event.kind == "BILLING_USAGE_EVENT" and event.type == "Full-Stack Monitoring"
| dedup event.id
| makeTimeseries total_billed_usage = sum(billed_gibibyte_hours), interval: 24h, time: usage.start

Re: Calculating BILLING_USAGE_EVENT data to currency

AntonPineiro — Wed, 31 Dec 2025 13:47:26 GMT

Hi,

Maybe you can follow Allocate your DPS costs.

Dynatrace already provide a dashboard about it but you need to follow some tagging / properties rules. You have more details in this thread.

Best regards

Re: Calculating BILLING_USAGE_EVENT data to currency

janne-olkoniemi — Wed, 31 Dec 2025 14:16:13 GMT

Hi Anton,

Thanks for your suggestion and yep, the cost allocation is my long term plan but I will take some time before we would get the base ready for it since it also need some contribution from our customer side.

Currently I'm trying to find some easy way to calculate the top level prices on dashboards and I will allocate some more time for DQL now so that maybe in some point I can figure out this quite of questions ny myself 🙂

We have old style of dashboard for the cost calculation since it's quite straightforward with Data Explorer but would be nice to archive something similar with the new dashboards.

Best Regards,

Janne

Re: Calculating BILLING_USAGE_EVENT data to currency

AntonPineiro — Fri, 02 Jan 2026 07:37:31 GMT

Hi,

Since you have already something in dashboard classic. That metrics can be showed in new dashboards as well.

Best regards

Re: Calculating BILLING_USAGE_EVENT data to currency

janne-olkoniemi — Fri, 02 Jan 2026 08:52:41 GMT

I found some way eventually which seems to suit my needs for now and I save the prices as variables and make the calculation like this. Maybe not the best way to achieve what I need but it was we first way to get the data I need.

| fieldsAdd Euro = (total_billed_usage[]*toDouble($FullStackPrice))

Full query:

fetch dt.system.events
| filter event.kind == "BILLING_USAGE_EVENT" and event.type == "Full-Stack Monitoring"
| dedup event.id
| makeTimeseries total_billed_usage = sum(billed_gibibyte_hours), interval: 24h, time: usage.start
| fieldsAdd Euro = (total_billed_usage[]*toDouble($FullStackPrice))
| fieldsRemove total_billed_usage