Data Studio
2.8K members online now
2.8K members online now
Ask questions about Data Studio
Guide Me
star_border
Reply

Funnel eCom in Calculated field

[ Edited ]
Visitor ✭ ✭ ✭
# 1
Visitor ✭ ✭ ✭

Hi

I want to present my website funnel in DS.

How can i achieve this?

For example the shopping behavior report in GA:

Sessions with CHECKOUT:

(COUNT(gaSmiley FrustratedhoppingStage = 'CHECKOUT") / COUNT(gaSmiley FrustratedhoppingStage = 'ALL_VISITS")

OR

COUNT(CASE WHEN Shopping Stage  IN ("PRODUCT_VIEW") THEN 1 ELSE 0 END )

BUT

How do i get to count the sessions?

My desired outcome is a percentage. 

Thanks!