Im trying to show several usersession values grouped by country. I use next query to see values of one country:
select * from usersession where useraction.name like "loading of page /ewavweb/es/entrypoint.do"
where "es" refers to a country (Spain in this case).
I would like to show a chart with values for every country.
I could group by country for example:
select * from usersession where useraction.name like "loading of page /ewavweb/??/entrypoint.do" group by country,
but it is not possible because Dynatrace doesnt provide session country value ( when I do select * from usersession, country value is always null)
Does anybody know how to solve this issue?