topic Re: Concatenate 2 columns in user sessions query in Real User Monitoring

Concatenate 2 columns in user sessions query

alexandre_benel — Wed, 17 Jun 2020 20:36:14 GMT

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

Re: Concatenate 2 columns in user sessions query

JamesKitson — Wed, 17 Jun 2020 21:04:48 GMT

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(*)

Re: Concatenate 2 columns in user sessions query

alexandre_benel — Wed, 17 Jun 2020 21:26:32 GMT

Tks James!