Mode Analytics's reports | Mode

MA

@modeanalytics

Mode Analytics

Published Sample report - parameters

SELECT TO_CHAR(DATE_TRUNC('{{ period }}',...,West], [All,All]] {% endform %}
Published Sample report - deliver data tables

SELECT a.name, 'https://' ||... BY 1
Published Example (py) - Plotly Line + Bar shared y-axis

SELECT TO_CHAR(DATE_TRUNC('month',start_d...t_station_id = s.id GROUP BY 1 ORDER BY 1
Published Example - pivoting with parameters

Simple example for pivoting with parameters.
Published Example (py) - Plotly multicolored line chart

SELECT season, CASE WHEN seaso....nfl_touchdowns GROUP BY 1,2 ORDER BY 1,2
Published Example (py) - Plotly multiseries line chart

SELECT season, team, ...N ('SFO','NYG') GROUP BY 1,2 ORDER BY 1,2
Published Example - cumulative event sum

SELECT date, sum(count(id)) OV....start_date GROUP BY 1 ORDER BY 1 ASC
Published Dot Plot Example

Simple example using Seaborn dot plot. https://stanford.edu/~mwaskom/software/seaborn/...
Published Google Maps with Markers

For more information on how to customize chart colors, visit https://community.modeanal...
Published Double Y-Axis Bar Plus Multi-Line Chart Example

SELECT destination_airport, first_clas...v)as total_rev FROM tutorial.flight_revenue
Published Geographic heat map with parameters

An example heat map showing Carl's Jr. vs Hardee's locations.
Published New Clone of Lego story

SELECT year::varchar as year, ...lytics.new_colors_for_lego_chart ORDER BY 1
Published Parameters with Multiple Options

For more information on how to customize chart colors, visit https://community.modeanal...
Published Clone of Lego story

SELECT year::varchar as year, ...ERE pieces >3 ORDER BY 1
Published Example (py) - Wooooosh CSS 3D Python

SELECT 1
Published Example (py) - Networkx Graph

SELECT 1
Published Test

SELECT row_number() OVER (ORDER BY team) AS...hdowns FROM benn.nfl_touchdowns GROUP BY 2
Published Melissa's [Redacted] Test 2

SELECT * FROM tutorial.watsi_events
Published Melissa's [Redacted] Test

Select * from tutorial.watsi_events
Published Making a Heatmap

An example heatmap.