Mode Analytics's reports | Mode

MA

@modeanalytics

Mode Analytics

Published ✔️✔️Example - Pivoting with Parameters

Simple example for pivoting with parameters.
Published Example (py) - Plotly Bar Chart

SELECT CASE WHEN quarter = '1' THEN '1st'...benn.nfl_touchdowns GROUP BY 1 ORDER BY 1
Published Example (py) - Python Big Number

SELECT 1
Published Word Cloud

For more information on creating a word cloud visit https://community.modeanalytics.com...
Published Retention Cohorts with Seaborn version

This report looks into how well users retain depending on the day of the week that they...
Published Reordering dataframe columns example

SELECT county, uninsured_rate,... WHERE state = 'Minnesota' ORDER BY 2 DESC
Published Google Map with Markers

Simple example showing In-N-Out restaurant locations (2007).
Published Line + Bar Charts!

SELECT DATE_TRUNC('month',date::TIMESTAMP) AS...istorical_stock_price GROUP BY 1 ORDER BY 1
Published EXAMPLE (SQL) - Pie Chart Reorder Hack

SELECT CASE WHEN team = 'MIA' THEN '1....', 'NYG', 'MIA', 'PIT') GROUP BY 1 ORDER BY 2
Published Example (py) - Plotly Area Chart

WITH total AS( SELECT season::integer, ...HERE total.season > 2008 ORDER BY 1 ASC,2
Published Example (py) - Plotly line chart

SELECT TO_CHAR(DATE_TRUNC('day',start_dat....sf_bike_share_trip GROUP BY 1 ORDER BY 1
Published EXAMPLE (SQL) - Dynamic Select Parameter Report

SELECT team, COUNT(touchdown_id) AS total...chdowns WHERE team = '{{team}}' GROUP BY 1
Published Customize Chart Colors

For more information on how to customize chart colors, visit https://community.modeanal...
Published Scatter Plot Opacity

SELECT season, team, COUNT(touchdown_id...('SFO', 'MIA', 'PIT') GROUP BY 1,2 ORDER BY 1
Published Pareto Chart example

SELECT issue, COUNT(DISTINCT c...mer_complaints GROUP BY 1 ORDER BY 2 DESC
Published Test Report

SELECT * FROM benn.nfl_touchdowns WHERE ...: type: date default: today {% endform %}
Published Example - y-axis annotation

SELECT TO_CHAR(DATE_TRUNC('week',start_da...ke_share_trip GROUP BY 1,2 ORDER BY 1
Published WHERE YOU

SELECT 1
Published Example (py) - matplotlib reverse y-axis

SELECT TO_CHAR(start_date,'HH24') as hour....sf_bike_share_trip GROUP BY 1 ORDER BY 1
Published Sample report - easy charts

SELECT COUNT(*) FROM modeanalytics....events WHERE occurred_at >= '2016-01-01'