Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published Making a Heatmap

An example heatmap.
Published Nulls in Parameters

{% assign language_list = languages | strip_n...t default: 'english,spanish' {% endform %}
Published Annotation Example

How to do annotations.
Published Adding Space for X-Axis Labels

SELECT DATE_TRUNC('day',created_at) AS day, ...ammer_users GROUP BY 1 ORDER BY 1 LIMIT 40
Published Scenarios - Usage heatmap

A heatmap of every user's activity in their first 30 days.
Published [Automation] Bar Charts

SELECT series, value::FLOAT AS value ...b' AS series, 0.00009 AS value ) a
Published [Automation] Full List

SELECT series, value::FLOAT AS value ...b' AS series, 0.00009 AS value ) a
Published [Automation] Area Charts

SELECT series, value::FLOAT AS value ...b' AS series, 0.00009 AS value ) a
Published Clone of Chart hovers

SELECT DATE_TRUNC('day',created_at) AS day, ..._users GROUP BY 1,2 ORDER BY 1,2 LIMIT 120
Published [Automation] Line Charts

SELECT series, value::FLOAT AS value ...b' AS series, 0.00009 AS value ) a
Published Sales Dashboard

SELECT CASE WHEN event_name = 'create_user' T...plete_signup') GROUP BY 1,2 ORDER BY 3 DESC
Published Retention Heatmap Example

WITH users AS ( SELECT user_id, act... ) y WHERE period_age != 0 ORDER BY 1,2,3
Published Chart Colors for Multiple Charts

HTML for changing a chart's colors.
Published Date Parameter Example

Demonstrates parameter capability
Published Drilldown Pivot

SELECT DATE_TRUNC('year',date) AS year, ...ouchdowns GROUP BY 1,2,3,4 ORDER BY 1,2,3,4
Published Changing Chart Styling

HTML for changing a chart's colors.
Published Pie Chart Colors

HTML for changing a chart's colors.
Published Chart Data Point Limit

SELECT team, touchdown_id FROM benn.nfl_touchdowns LIMIT 3001
Published Ordering with a parameter

SELECT team, COUNT(*) AS values FROM...], ['Z-A','DESC']] {% endform %}
Published Parameter Example

Example query with a dropdown parameter to limit view of Crunchbase Acquisitions to a g...