Dashboard: Hacker News Dashboard
This dashboard answers the following questions:
- What are the max and average scores of recent stories?
- How many Ask and Show HNs are there?
- What are the average scores of Ask and Show HNs?
- Which companies, languages, operating systems, clouds and DBs have been mentioned in recent stories?
This dashboard contains 6 cards and 1 input.
Usage
Install the mod:
mkdir dashboardscd dashboardspowerpipe mod initpowerpipe mod install github.com/turbot/steampipe-mod-hackernews-insights
Start the Powerpipe server:
steampipe service startpowerpipe server
Open http://localhost:9033 in your browser and select Hacker News Dashboard dashboard.
You could also snapshot and share results via Turbot Pipes:
powerpipe loginpowerpipe dashboard run hackernews_insights.dashboard.hackernews_dashboard --share
Queries
The dashboard uses the named queries:
- hackernews_dashboard_ask_and_show_by_hour
- hackernews_dashboard_ask_count
- hackernews_dashboard_avg_ask_score
- hackernews_dashboard_avg_score
- hackernews_dashboard_avg_show_score
- hackernews_dashboard_max_score
- hackernews_dashboard_mentions
- hackernews_dashboard_show_count
- hackernews_dashboard_stories_by_hour
- hackernews_dashboard_user_with_greater_than_50_score
- hackernews_dashboard_user_with_greater_than_5_post