Bounce rate per device
Bounce rate per device
From the sessions table, compute each device's bounce rate: the ratio of sessions with bounced = 1 to the total number of sessions. Group by device, round the ratio to 4 decimals, and return columns device and bounce_rate. Sort by device ascending. The count() denominator is always > 0 within a group.
Row order matters
Sign in to see submission history
Sign inSign in to use AI Mentor
Sign inFocus radio
Paused · SomaFM · Fluid