We’re using Tableau to visualise Snowplow web data, and I want to create a simple visualisation of bounce rate.
Does anyone know how to create a calculated metric for the number of bounced sessions i.e. sessions with just a single event? I’ve read Yali’s article on SQL queries for Snowplow data, and the methodology does make sense, however I am not sure how to calculate the number of bounces. Once I have that, I think the calc will be very straight forward:
Where Sessions is a calculated metrics like the following:
COUNTD([Domain Userid]+"-"+STR([Domain Sessionidx]))
If anyone can help me crate a calc for bounces it’d be massively appreciated!