Mode Analytics's reports | Mode

MA

@modeanalytics

Mode Analytics

Published Geographic Heat Map

For more information on how to customize chart colors, visit https://community.modeanal...
Published Choropleth Map

For more information on how to create this map, visit https://community.modeanalytics.c...
Published Bullet Chart

For more information on how to customize chart colors, visit https://community.modeanal...
Published Big Value link

For more information on how to add a link to a Big Value chart, visit https://community...
Published Clone of Sample report - easy charts

SELECT COUNT(*) FROM modeanalytics.parch_and_posey_web_events
Published Area chart bug

SELECT * FROM emily.burritos_round1
Published App Logins

Shows sample logins by week, location, and device type.
Published Average Session Length

The average length of a session, in seconds.
Published EXAMPLE (SQL) - Comma Delimited Parameter

SELECT team, COUNT(touchdown_id) AS total...: text default: 'SFO,NYG,PIT' {% endform %}
Published ✔️✔️Measuring Feature Use

Feature use over time, by the number of times the feature has been used and by how many...
Published EXAMPLE (JS) - Scatter Plot Label Example

Analysis of the lof of commutes, both work and home bound
Published Liquid Ands and Ors

{% if param_1 == 'a' and param_2 == 'a' %} SE... default: b options: [a,b] {% endform %}
Published EXAMPLE (SQL) - Parameter Date Picker

SELECT * FROM benn.nfl_touchdowns WHERE ...1-01 end_date: type: date {% endform %}
Published Chart Height Example

Simple example for changing chart heights.
Published Example - Events by 15 min interval

SELECT to_timestamp(floor((extract('epoch...trip GROUP BY 1 ORDER BY 1 LIMIT 100
Published DATE_TRUNC() blog example part 5

And we can easily switch from daily to weekly aggregation.
Published DATE_TRUNC() blog example part 4

Now we can use time to aggregate new users.
Published DATE_TRUNC() blog example part 3

Timestamps trimmed to just indicate year, month and day.
Published DATE_TRUNC() blog example part 2

Data cannot be aggregated.
Published DATE_TRUNC() blog example part 1

Unprocessed data.