@benn
Bennett Stancil
-
Published Line + Bar Charts!
SELECT DATE_TRUNC('month',date::TIMESTAMP) AS...istorical_stock_price GROUP BY 1 ORDER BY 1 -
Published Mapping Home Runs
A graphic exploring the flights of 40,000 home runs over the last 7 years. Source: ESPN... -
Published Showing Particular X-Axis Values
How to show all the x-axis values on a chart -
Published Conditional Formatting with Cutoffs
How to add conditional formatting to your report, with thresholds for colors. -
Published Scatter Plot Opacity
SELECT season, team, COUNT(touchdown_id...('SFO', 'MIA', 'PIT') GROUP BY 1,2 ORDER BY 1 -
Published [Automation] Big Numbers
SELECT team, SUM(age * 10000) AS age, ...yards FROM benn.nfl_touchdowns GROUP BY 1 -
Published WHERE YOU
SELECT 1 -
Published Exploring Events
How often certain events are recorded. -
Published All Example
How to add an "all" parameter to a report -
Published Text Color Column Gradients
How to change text colorts on a gradient in stock tables. -
Published Adding Images to Cells
SELECT name, state, district, ...t FROM benn.representative_stances LIMIT 10 -
Published Adding Links to Cells With Different Columns
SELECT name AS full_name, homepage_url...L ORDER BY funding_total_usd DESC LIMIT 100 -
Published Changing Chart Titles
HTML for changing a chart's title dynamically. -
Published The Software Ecosystem
Today's software ecosystem visualized. Dots represent software products, and the lines ... -
Published [Automation] Issues
SELECT season, CASE WHEN season > 1990...ouchdowns GROUP BY 1 ) a ORDER BY 1 -
Published Adjusting Python Chart Heights
How to make python charts taller. -
Published Big Number example
SELECT DATE_TRUNC('day',created_at) AS day, ....playbook_users GROUP BY 1 ORDER BY 1 DESC -
Published Making a Funnel
Making a funnel with Mode. -
Published Query with multiple entries
SELECT * FROM tutorial.yammer_users WHERE ...xt default: 'active,pending' {% endform %} -
Published Key Event Metrics
Key metrics about the chosen event.