Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published New McKinsey Comparison - Rounds

WITH founders AS ( SELECT DISTINCT per... ON new.year = old.year ORDER BY 1
Published MK Summary

Summary of companies that are listed as having McKinsey founders in Crunchbase.
Published Yesterday Example

SELECT * FROM tutorial.yammer_events {% if ...e: text default: 'yesterday' {% endform %}
Published Do VCs Have an Age Bias?

What age founder do different VCs prefer?
Published Chart example 2

SELECT DATE_TRUNC('week',date) AS time, ...M benn.nfl_touchdowns GROUP BY 1 ORDER BY 1
Published McKinsey Rounds

SELECT f.funded_date, f....ounded_year,c.company_permalink,f.funded_date
Published McKinsey Founders - Total Funding

Average number of funding rounds for McKinsey alumns vs other founders.
Published All Parameter Example

SELECT event_name, COUNT(*) FROM tut...ike_message', 'like_message']] {% endform %}
Published Looping Over Strings

{% capture columns %} value1, value2, value...umns %} ,100 AS {{ column }} {% endfor %}
Published Loop example

SELECT fr.name {% for i in (start_year..end_... type: text default: 2014 {% endform %}
Published How Users Move Through Your Product

A visual analysis of event sequences by session. For details, see: https://modeanalytic...
Published Today Parameter Example

SELECT * FROM tutorial.playbook_events {% ... type: text default: today {% endform %}
Published Untitled Query

SELECT * FROM benn.nfl_touchdowns
Published json

SELECT season, team, COUNT(*) A...ards FROM benn.nfl_touchdowns GROUP BY 1,2
Published Untitled Query

SELECT * FROM benn.nfl_touchdowns
Published How Users Move Through Your Product - different colors

A visual analysis of event sequences by session. For details, see: https://modeanalytic...
Published Loop Parameter Example

{% assign yearList = years | strip_newlines |...e: text default: '2010,2011' {% endform %}
Published IF Parameter Example

SELECT team, {% if metric == 'average age' %...uchdowns','total touchdowns']] {% endform %}
Published Parameter Example

Example of how to use parameters in reports.
Published Parks Per person

SELECT pop.state, pop.population, ...parks.park_state = pop.state ORDER BY 3 DESC