Mode connects the world’s data and the people who analyze it.
Learn More
Sign In
Sign Up
@benn
Bennett Stancil
443
Public Reports
195
Public Tables
Reports
Tables
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 ...
‹ Prev
1
2
3
4
5
6
…
24
Next ›