@benn
Bennett Stancil
-
Published Untitled Report
SELECT DISTINCT event_name, event_type FROM tutorial.playbook_events -- GROUP BY 1 -
Published If/Else Statements with Parameters
How do use parameters to execute different SQL statements. -
Published Column Gradients
How to align columns in stock tables. -
Published Aligning Columns
How to align columns in stock tables. -
Published Retention Cohort - Diffs
User cohorts by signup date. -
Published Average Session Length
The average time on site per user, in seconds. -
Published Persistent Annotation Example
How to do annotations. -
Published U.S. State Map Example
A simple map of U.S. states. -
Published Changing Chart Colors
HTML for changing a chart's colors. -
Published Making Charts Bigger
SELECT DATE_TRUNC('day',occurred_at) AS day, ...orial.playbook_events GROUP BY 1 ORDER BY 1 -
Published Example2
SELECT *, store_count/total_stores::FL...nn.stores GROUP BY 1,2 ) x ) y -
Published String Parameter Example
SELECT * FROM benn.nfl_touchdowns WHERE te...m: type: text default: SFO {% endform %} -
Published Selecting Cells
SELECT season, team, 'https://w...M benn.nfl_touchdowns GROUP BY 1,2,3 -
Published Adding Links to Cells
SELECT season, team, 'https://w...M benn.nfl_touchdowns GROUP BY 1,2,3 -
Published Chart Colors
SELECT DATE_TRUNC('day',created_at) AS day, ...ammer_users GROUP BY 1 ORDER BY 1 LIMIT 40 -
Published Parameters of other parameters
It's parameters all the way down. -
Published World Map
A simple example of how to make a world map with dots. To add dots, return rows with ... -
Published Textures.js Example
A basic example of a Textures.js. Shades states by the number of letters in their name.... -
Published Testing
SELECT * from benn.nfl_touchdowns -
Published Simple Pivot
SELECT season, team, COUNT(*) FROM benn.nfl_touchdowns GROUP BY 1,2