@gbaudart wrote:
@yuval1983
To use these 2 filters in the same query, you may test :
fetch dt.entity.service
| fields entity.name, managementZones, tags
| filter matchesValue(managementZones, "prod")
| expand tags
| filter contains(tags, "prod")

Ok, I want to filter the results based on services and tags and display them in a window (table). The filter will look like this: services:test, tags:test2. Also, the Zone:prod .
----------------------------------------------
What should I replace in this setting?
“Zone”: result.dimensionMap[“dt.entity.service”],
“Tag”: result.dimensionMap[“dt.entity.service”],
------------------------------
import { metricsClient } from ‘@dynatrace-sdk/client-classic-environment-v2’;
export default async function fetchMetricResults() {
const serviceSelection = $Service;
const metricKey = “builtin:service.errors.total.rate”;
const config = {
metricSelector: buildQuery(serviceSelection, metricKey),
resolution: “Inf”,
from: $dt_timeframe_from,
to: $dt_timeframe_to,
acceptType: “application/json; charset=utf-8”
};
if (config.metricSelector.length > 3500) {
return “Please select fewer services”;
}
const metricQuery = await metricsClient.query(config);
const processedResults: MetricResult[] = metricQuery.result[0].data.map(result => {
return {
“Service Name”: result.dimensionMap[“dt.entity.service.name”],
“Service ID”: result.dimensionMap[“dt.entity.service”],
“Zone”: result.dimensionMap[“dt.entity.service”],
“Tag”: result.dimensionMap[“dt.entity.service”],
“Failure Rate”: +result.values
};
});
return processedResults;
}
function buildQuery(inputs: string[], metricKey: string): string {
const filters = inputs.map(
input => `in(“dt.entity.service”, entitySelector(“type(service), entityName.equals(~”${input}~“)”))`
);
const filterString = filters.join(“,”);
return `${metricKey}:filter(or(${filterString})):splitBy(“dt.entity.service”):sort(value(auto, descending)):names`;
}