How to perform "Group By" function in CJA similar to sql

[RaymondDeng]

I want to calculate the bounce rate of our websites in the CJA;

I have the following data submited when user navigating the page each time it trigger pageview.(Please see the pic for more info)

EventType: PageView

ECID: xxx

Session ID: xxx

The session ID logic is control by our own website.

I want to create a metrics to calculate how many unique sessions that has less than 2 pageveiw events.

Love to hear you back!

[abhinavbalooni]

Hi @RaymondDeng

I dont have access to CJA currently to try it out but I think the below should work .

I am assuming you have defined session settings in the CJA data view. You can try using DISTINCT Count Operator on the pagename value in a session container and check if it is equal to 1. That should give you the session which has bounced. 

Distinct operator: https://experienceleague.adobe.com/docs/analytics-platform/using/cja-components/cja-filters/operator...

Havent tried it yet but should work. Do let me know how it goes.

Cheers,

Abhinav