How to split a user session custom metric by city

[Doaa_Sobhy]

Dear All,

I want to display the user experience score in a dashboard and split the results by the city not by the region.

I created a custom user session metric with dimensions: region, useraction.application and userExperienceScore

and when I tried to add extra dimension: city, it gave me an error: [Filed is not a valid dimension, Only non-numeric fields with low cardinality are allowed as dimension]

please, help me

[Doaa_Sobhy · Accepted solution]

Create USQL custom metrics for web applications — Dynatrace Docs

regarding to DT document [city] can't use as a dimension for the user session custom metric

we can use USQL to get all information with [city] and pin the result as a table in a dashboard