Explore Data right where it lives. Connect and visualize your data in Data Studio

Connect - Visualize - Share

Open this Google Data Studio link in a new incognito browser tab.

On the Reports page, in the Start with a Template section, click the [+] Blank Report template.

If prompted with the Welcome to Google Studio window, click Get started.

Check the checkbox to acknowledge the Google Data Studio Additional Terms, and click Accept.

Select No thanks to all 4 questions, then click Done.

Click Explore Data > Explore with Data Studio in BigQuery page.

Click Get Started, then click Authorize.

Specify the below settings:
Chart type: Combo chart
Date range Dimension: dashboard_sort
Dimension: dashboard_sort
Drill Down: dashboard_sort (Make sure that Drill down option is turned ON)
Metric: SUM() total_rides, SUM() total_passengers, SUM() total_revenue
Sort: dashboard_sort, Ascending (latest rides first)