27 Dec 2024 08:17 AM - last edited on 30 Dec 2024 08:26 AM by MaciejNeumann
Hi,
I applied the current consumption information of Dynatrace DEM with the formula I created from metrics. There are mobile, web and custom application types that consume DEM licenses in our environment. Taking this into account, I created a formula as follows. However, in this formula, the consumption value on the Data Explorer screen does not match the monthly and annual consumption values on the CMC screen. (The 1st of the month was taken as basis for monthly, and the beginning of the year was taken as basis for annual.) CMC screen value bigger than Data Explorer result value. What is the reason for this difference?
(((builtin:billing.apps.web.sessionsWithReplayByApplication:filter(and(eq(Type,Billed))):splitBy():sum:default(0):fold(sum))
+
(builtin:billing.apps.web.sessionsWithoutReplayByApplication:filter(and(eq(Type,Billed))):splitBy():sum:default(0):fold(sum) * 0.25)
+
(builtin:billing.apps.mobile.sessionsWithReplayByApplication:filter(and(eq(Type,Billed))):splitBy():sum:default(0):fold(sum))
+
(builtin:billing.apps.mobile.sessionsWithoutReplayByApplication:filter(and(eq(Type,Billed))):splitBy():sum:default(0):fold(sum) * 0.25)
+
(builtin:billing.apps.custom.sessionsWithoutReplayByApplication:filter(and(eq(Type,Billed))):splitBy():sum:default(0):fold(sum) * 0.25)
+
(builtin:billing.synthetic.actions:splitBy():sum:default(0):fold(sum))
+
(builtin:billing.synthetic.requests:splitBy():sum:default(0):fold(sum) * 0.1)
+
(builtin:billing.apps.mobile.userActionPropertiesByMobileApplication:splitBy():sum:default(0):fold(sum) * 0.01)
+
(builtin:billing.apps.custom.userActionPropertiesByDeviceApplication:splitBy():sum:default(0):fold(sum)* 0.01)
+
(builtin:billing.apps.web.userActionPropertiesByApplication:splitBy():sum:default(0):fold(sum) * 0.01)
+
(builtin:billing.synthetic.external:splitBy():sum:default(0):fold(sum) * 0.1)))
Thank you,
Seda.
27 Dec 2024 01:08 PM
I'm curious if there is an issue in the mathematical operators. Can you break them out as single tiles and see if manually adding the tiles up will result in a correct CMC Value representation?
30 Dec 2024 11:50 AM
Hi,
Yes when I separated them into individual tiles and added the tiles manually I got a correct CMC value. How can I overcome the mathematical operator?
Thank you.