Mode Analytics's reports | Mode

MA

@modeanalytics

Mode Analytics

Published EXAMPLE (SQL) - Big Value Chart

SELECT team, COUNT(touchdown_id) AS total...', 'NYG', 'OAK', 'PIT') GROUP BY 1 ORDER BY 2
Published EXAMPLE (SQL) - (Parameter in Title Example) Touchdowns by

Formatting report and chart titles with parameters
Published EXAMPLE (py) - Python Version

SELECT * FROM benn.nfl_touchdowns
Published EXAMPLE (JS) - Overwrite Chart Error

SELECT team, COUNT(touchdown_id) AS total...n: type: text default: 1960 {% endform %}
Published EXAMPLE (py) - Python Error Bar

SELECT season, AVG(yards) AS average, ...touchdowns GROUP BY 1 ORDER BY 1 LIMIT 100
Published EXAMPLE (PY) - Plotly Categorical Bubble Chart

This report features a categorical bubble chart from Plotly's offline plots for Python....
Published Bar Chart Funnel Example

A simple funnel visualization
Published ✔️✔️Describing Retention

Retention and churn rates by user cohort. For details, see: https://help.modeanalytics....
Published ✔️✔️Metrics that Matter - Part I

-- For details on how to use this report, vis...ctivated_at + INTERVAL '14 DAY' GROUP BY 1,2
Published ✔️✔️Metrics that Matter - Part II

Shows retention rates by how often a user takes an action in their first week. Red user...
Published ✔️✔️Retention Cohorts

This report looks into how well users retain depending on the day of the week that they...
Published ✔️✔️When Do Users Slip Away?

The table shows the percentage of users who take a certain action after having not havi...
Published EXAMPLE (py) - Exporting Pandas pivot table

SELECT start_station.city as start_city, ...nd_station_id = end_station.id GROUP BY 1,2
Published Using if statements to change queries

How to use an if statement to change queries.
Published EXAMPLE (PY) (SQL) - Plotly Bar Chart with Parameters Example

SELECT * from benn.nfl_touchdowns
Published EXAMPLE (HTML/CSS) - Parameters in HTML

Formatting report and chart titles with parameters
Published Funnel chart

For more information on how to create a funnel chart, visit https://community.modeanaly...
Published Heat Map

For more information on how to customize chart colors, visit https://community.modeanal...
Published Report Layout + HTML

With just a bit of HTML you can turn a series of charts into a story.
Published ✔️✔️Sunburst chart

For more information on how to build a sunburst chart, visit https://community.modeanal...