Aggregating multiple dimensions

simonv — Fri, 19 Nov 2021 11:16:45 GMT

Hi.

I'm quite new to Dynatrace so forgive me for asking noob questions.

When using below metrics query I get the metric values per Browser. I would like to aggregate this into 1 value (average for all browsers). Is this possible ?

curl -s --request GET --header "Authorization: Api-Token $apiToken" -H 'Accept: text/csv; header=present' --url "$apiUrl/v2/metrics/query?metricSelector=builtin:apps.web.speedIndex.load.browser:fold&entitySelector=type(dt.entity.application),entityId(APPLICATION-8DAF5E3E3658D63D)&from=now-5m"

metricId,dt.entity.application,dt.entity.browser,time,value
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-44C8EFE87C847CA6,2021-10-19 11:00:00,1373.3125
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-2D76AED137A69022,2021-10-19 11:00:00,1424.0
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-E79C34E9D4A9AFD6,2021-10-19 11:00:00,3194.3333333333335
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-1CFF5AB60CE3BBAF,2021-10-19 11:00:00,605.0
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-FF8EAE6885DE87B3,2021-10-19 11:00:00,1504.3333333333333
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-1D597E38A66F160E,2021-10-19 11:00:00,1695.6643356643356
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-EFB8A292CB368A8D,2021-10-19 11:00:00,1169.2
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-2C4D5E50F4C1AAB1,2021-10-19 11:00:00,1804.5
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-1ACF727C4A75B9CD,2021-10-19 11:00:00,1362.8030303030303
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-23799DD37B7F5A4F,2021-10-19 11:00:00,2121.288888888889
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-1C0C3858CD11FF0F,2021-10-19 11:00:00,1841.923076923077
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-B0720D8978B4939A,2021-10-19 11:00:00,1359.857142857143
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-2A6F794139C73155,2021-10-19 11:00:00,1204.5384615384614
builtin:apps.web.speedIndex.load.browser:fold,APPLICATION-8DAF5E3E3658D63D,BROWSER-170B1D2222BA4289,2021-10-19 11:00:00,605.0

Re: Aggregating multiple dimensions

simonv — Tue, 19 Oct 2021 14:46:43 GMT

Found it... splitBy is what I need

topic Re: Aggregating multiple dimensions in Dynatrace API

Aggregating multiple dimensions

Re: Aggregating multiple dimensions