cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Concatenate 2 columns in user sessions query

alexandre_benel
Newcomer

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

2 REPLIES 2

JamesKitson
Dynatrace Leader
Dynatrace Leader

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!