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?
If im following this issue correctly, it appears I am able to do this without issue.
can you share your string that your using?
When I do select * from usersession I get null value in country column
You might want to open a support ticket then, maybe a configuration step was missed. Have you defined IP ranges and such?