Dashboard: Formula 1 Dashboard
This dashboard answers the following questions:
- How many Formula 1 races have been held?
- What is the total number of drivers?
- How many constructors are there in Formula 1?
- How many seasons of Formula 1 racing have occurred?
- What is the distribution of team standings by conference?
- How do points per race compare across teams?
This dashboard contains 4 cards.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/powerpipe-mod-formula1Start the Powerpipe server:
powerpipe serverOpen http://localhost:9033 in your browser and select Formula 1 Dashboard dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run formula1.dashboard.formula1_dashboard --shareQueries
This dashboard uses the the following queries:
select date as "game", avg(total_results) as "average_attendance"from ( select r.date, count(*) as total_results from races r join results rs on r.raceId = rs.raceId group by r.date) as attendance_countsgroup by date;