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
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...
‹ Prev
1
2
3
4
5
…
24
Next ›