Customer create session property on RA of user gender 1-Female, 2-Male, 0-none.
There is no problem to split user actions by this session property and to show the information but the caption is 1,2.
Is there a way to add caption for gender instead of 1,2 for the follows USQL ?
SELECT count(name) as "Action count", usersession.stringProperties.gender AS "Gender" FROM useraction WHERE name = "click on icon loan-ask" and usersession.stringProperties.gender IN ("1", "2") GROUP BY usersession.stringProperties.gender
Thanks in advance
Solved! Go to Solution.