@benn
Bennett Stancil
-
Published Adding Dollar and Percent Signs
SELECT season AS year, COUNT(*) AS dol...fl_touchdowns GROUP BY 1 ORDER BY 1 -
Published Mapping every Event to a Session, with channel info!
Mapping every event in an event stream to a session, with an example for how to include... -
Published Bar Pinwheels of Overrepresented Category Colors (uses full hsl)
The height of the bar shows how many pictures are in the wedge of the color wheel. The ... -
Published Custom Chart Colors
HTML for changing a chart's colors. -
Published Bar Pinwheels of Overrepresented Colors (uses full hsl)
The height of the bar shows how many pictures are in the wedge of the color wheel. The ... -
Published When Do Users Slip Away? (Old)
The table shows the percentage of users who take a certain action after having not havi... -
Published Retention Cohorts (Old)
This report looks into how well users retain depending on the day of the week that they... -
Published Retention Cohort - Signup Date
User cohorts by signup date. -
Published Describing Retention (Old)
Retention and churn rates by user cohort. For details, see: https://modeanalytics.zende... -
Published Changing text in tables
How to add change table text. -
Published Parameter for Today
How to make a date filter that defaults to the current time. -
Published Adding Images to Tables
SELECT name, state, district, ...ge__image FROM benn.representative_stances -
Published Word Cloud from Blocks of Text
How to make a word cloud given blocks of text like email bodies or chat messages. -
Published Timestamp Parameters
Example of using timestamps in parameters. -
Published Changing Chart Colors
HTML for changing a chart's colors. -
Published Changing Line Weight and Styles
HTML for changing a line chart's weight and style. -
Published Dashboard Example
SELECT lat, long AS lng, RANDOM...ong IS NOT NULL ORDER BY RANDOM() LIMIT 100 -
Published Examples of All Charts, with charts of different sizes
SELECT * FROM benn.nfl_touchdowns ORDER BY random() limit 100 -
Published Variable Chart Heights
SELECT DATE_TRUNC('year',date) AS year, ...am IN ('CAR','SFO','SEA') GROUP BY 1,2,3,4,5 -
Published Bar Pinwheels
The height of the bar shows how many pictures are in the wedge of the color wheel. The ...