Dashboard: Star Wars Species Detail
This dashboard answers the following questions for each species:
- What is the classification of the species?
- What is the average height of the species in centimeters?
- What is the most common skin color of the species?
- What is the average lifespan of the species in years?
This dashboard contains 4 cards, 1 input and 3 tables.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/powerpipe-mod-starwarsStart the Powerpipe server:
powerpipe serverOpen http://localhost:9033 in your browser and select Star Wars Species Detail dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run starwars.dashboard.starwars_species_detail --shareQueries
This dashboard uses the the following queries:
select 'Average Height in cm' as label, avg(cast(nullif(average_height, 'NA') as float)) as valuefrom specieswhere name = $1;