with data as ( select date(created_at) as date, sum(if(app_promoting_co = 'Reby' and owner_co != 'Reby',1,0)) as hey, count(*) as all_ from `reby-cloud.analytics_reby_v1_eu.transactions_combined_reassigned_final` where type like 'ride%' and date(created_at) > current_date - 50 and service_area = 'Barcelona' group by 1 --order by 1 desc ) select hey / all_ from data order by 1 desc
Preview:
downloadDownload PNG
downloadDownload JPEG
downloadDownload SVG
Tip: You can change the style, width & colours of the snippet with the inspect tool before clicking Download!
Click to optimize width for Twitter