Dashboard: Video Games Dashboard
This dashboard answers the following questions:
- How many video games are currently cataloged in the database?
- What is the total number of game developers?
- How many publishers are involved in the video games listed?
- Which are the top 10 video games rated by user score, and what scores did they achieve?
- What are the top 10 game genres by the number of games, and how many games are there in each genre?
This dashboard contains 4 cards.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/powerpipe-mod-video-gameStart the Powerpipe server:
powerpipe serverOpen http://localhost:9033 in your browser and select Video Games Dashboard dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run videogames.dashboard.videogames --shareQueries
The dashboard uses the named queries:
- videogames_average_platform_meta_score_per_genre
- videogames_top_10_by_user_ratings_count
- videogames_top_10_by_user_score
- videogames_top_10_developers_by_game_count
- videogames_top_10_genre_distribution
- videogames_top_10_publishers_by_game_count
- videogames_total
- videogames_total_developers
- videogames_total_platforms
- videogames_total_publishers