Bennett Stancil's reports | Mode

@benn

Bennett Stancil

Published Mode box plot

SELECT series, -1 AS minimum, q... max AS maximum FROM modeanalytics.boxplot
Published Pivots in SQL

How to do basic pivots in SQL.
Published Visualizing User Behavior

An graphic for understanding how your customers are using your product, and how differe...
Published Pivot Example 2

WITH teams AS ( SELECT DISTINCT team_id AS ...e" type: text default: SFO {% endform %}
Published Leaflet heatmap example

An example heatmap.
Published Word Cloud from Word Frequencies

How to make a word cloud given word or phrase frequency.
Published Simple HTML edits

SELECT * FROM benn.letter_frequency_example
Published Daily Messages Sent

Number of messages sent every day.
Published Sorting Tables

An example of how to sort tables by clicking on headers.
Published Creating a Box Plot

Creating a box plot of Olympic athlete ages. Shows ages for athletes in the 2014 Winter...
Published Creating a Box Plot (with Outliers!)

Creating a box plot of Olympic athlete ages. Shows ages for athletes in the 2014 Winter...
Published Median Age by Olympic Sport

Shows the median ages for athletes in the 2014 Winter Olympics.
Published Conditional Formatting

How to add conditional formatting to your report.
Published Parameter Label and Description

SELECT * FROM tutorial.playbook_users WHE...." type: text default: 1 {% endform %}
Published How Users Move Through Your Product (More steps)

A visual analysis of event sequences by session. For details, see: https://modeanalytic...
Published Showing Not All X-Axis Values

How to not show all the x-axis values on a chart.
Published Highcharts Example

SELECT DATE_TRUNC('day',occurred_at) AS day, ...ial.playbook_events GROUP BY 1 ORDER BY 1
Published Pivoting with Parameters

SELECT season, {{ pivot_by }} AS pivot...ter], [type,type]] {% endform %}
Published Weekly Logins by Language

Sample data showing weekly logins by language.
Published Referencing parameters in report HTML

You can create a dummy column that returns the value of your parameter, and then exclud...