Mode connects the world’s data and the people who analyze it.
Joined on November 14, 2013
Stacked bar + line with pivot
SELECT season, team, COUNT(*) ...SFO','GNB','NYG') GROUP BY 1,2 ORDER BY 1,2
How to style tables using CSS.
SELECT DATE_TRUNC ('day', ye.occurred_at) AS ... AND ye.event_name = 'login' GROUP BY 1,2,3
Retention and churn rates by user cohort. For details, see: https://help.modeanalytics....
For more information on how to build a sunburst chart, visit https://community.modeanal...
Last Week on Hacker News
Shows the current top Hacker news posts. Data provided via Kimono Labs, updated once an...
Measuring Feature Use
Feature use over time, by the number of times the feature has been used and by how many...
Full Screen View
SELECT DATE_TRUNC('year',date) AS year, ...am IN ('CAR','SFO','SEA') GROUP BY 1,2,3,4,5
Retention drill-down dashboard
Metrics to help you better understand your retention rate.
Retention Cohort - User Device
User cohorts by signup device.
Retention Cohort - User Language
User cohorts by user language.
Google Map with Markers
Simple example showing In-N-Out restaurant locations (2007).
Stacked bar + line
SELECT LEFT(DATE_TRUNC('day',occurred_at)::VA...rial.playbook_events GROUP BY 1 ORDER BY 1
Activities at State and National Parks
An interactive map exploring the activities at all state and national parks in the Unit...
Line + Bar Charts!
SELECT DATE_TRUNC('month',date::TIMESTAMP) AS...istorical_stock_price GROUP BY 1 ORDER BY 1
Area chart bug
SELECT * FROM emily.burritos_round1
Metrics that Matter - Part I
-- For details on how to use this report, vis...ctivated_at + INTERVAL '14 DAY' GROUP BY 1,2
Mapping Home Runs
A graphic exploring the flights of 40,000 home runs over the last 7 years. Source: ESPN...
Showing Particular X-Axis Values
How to show all the x-axis values on a chart
Conditional Formatting with Cutoffs
How to add conditional formatting to your report, with thresholds for colors.