Hi Team,
We are trying to integrate dynatrace with power BI and for which we need query to be created in dynatrace and fed in to power BI.
We are trying to extract API-Gateway CC request count from "custom multidimensional page". While trying to build query using data explorer we are unable to build the exact relationship "from" and "to" due to which accurate data is not populating. So could you please share details on how to build relationship and get exact metrics. Below is the query we used in power BI but its fetching metrics for overall integration layer but we want it to be segregated (e.g: API-Gateway CC,API-Gateway SF,etc)
https://{environmentid}.live.dynatrace.com/api/v2/metrics/query?metricSelector=(calc:service.api_gateway_rquestcount_stats_cc:splitBy(Dimension):sort(value(auto,descending)):limit(20)):names:fold(value)&from=1683544560000&to=1683551760000&resolution=1h
Note 😞 hostname has been hidden in the above link )
