Hi guys,
Is there a way to concatenate 2 or more columns/strings in user session query? Something like that:
select screenHeight || "x" || screenWidth from usersession
So the result would be: 1280 x 720
Tks
Solved! Go to Solution.
No, but if you're looking for resolution info I've done something like that previously. Might need to adjust it to fit your needs but the below gives top screen resolutions for mobile apps.
SELECT screenHeight as height, screenWidth as width, count(*) as "Session count" from usersession where applicationType = "MOBILE_APPLICATION" group by screenHeight, screenWidth ORDER BY count(*)
Tks James!