Calculating BILLING_USAGE_EVENT data to currency

[janne-olkoniemi]

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

[AntonPineiro]

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

[janne-olkoniemi]

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