Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published Sample

SELECT * FROM benn.nfl_touchdowns WHERE s...: type: text default: 1970 {% endform %}
Published Median Example

SELECT DATE_TRUNC('day',occurred_at) AS day, ...ed_at <= '2014-05-23' GROUP BY 1 ORDER BY 1
Published X-Axis Offset

SELECT DATE_TRUNC('day',occurred_at) AS hour,...mer_events GROUP BY 1 ORDER BY 1 LIMIT 20
Published X-Axis Offset with Hacky Fix

SELECT hour AT TIME ZONE 'PST8PDT' AT TIME ZO... GROUP BY 1 ) a ORDER BY 1 LIMIT 20
Published D3 U.S. Map

Simple example of United States choropleth using D3
Published Highchart Example

SELECT DATE_TRUNC('day',created_at) AS time, ...tutorial.yammer_users GROUP BY 1 ORDER BY 1
Published Daily Active Users

Chart of daily active users and
Published Cumulative Total Example

SELECT month, new_users, SUM(ne...GROUP BY 1 ) z ORDER BY month
Published Capital Letters

SELECT COUNT(*) AS without_quotes, COU...#*!%@! (╯°□°)╯" FROM tutorial.yammer_events
Published Immunization Map

SELECT * FROM ( SELECT 'school' AS locati...od_locations wf ) a ORDER BY pbe_rate
Published MKY - Companies with any funding

SELECT CASE WHEN a.mckinsey = 1 THEN 'At leas... GROUP BY 1,2,3,4,5 ) a GROUP BY 1
Published MKY - CB company list

SELECT DISTINCT c.founded_on, c.total_...d_on <= '2013-12-31' AND total_funding > 0
Published Multiple entries in a parameter field - strings

{% assign states = states_to_include | split:...xt default: 'active,pending' {% endform %}
Published Multiple entries in a parameter field - integers

SELECT * FROM tutorial.yammer_users WHERE ... type: text default: '1,2' {% endform %}
Published Crunchbase subquery

SELECT *, acquisitions_ipos/number_of_...Y 1 ORDER BY 2 DESC ) a LIMIT 100
Published Time After Signup Example

-- For details on how to use this report, vis...014-06-01' ) a GROUP BY 1 ORDER BY 1
Published Form Options

SELECT {{pick_number}} {% form %} pick_numb...8,498], [499,499], [500,500] ] {% endform %}
Published New McKinsey Comparison - Exits

where is this gonna go
Published New McKinsey Comparison - Amount Raised

WITH founders AS ( SELECT DISTINCT per...4 WHEN old.round_code = 'c' THEN 5 ELSE 6 END
Published New McKinsey Comparison - Acquisitions

WITH founders AS ( SELECT DISTINCT per...ded_on >= '2003-01-01' ) x GROUP BY 1