Mode connects the world’s data and the people who analyze it.
Learn More
Sign In
Sign Up
@benn
Bennett Stancil
443
Public Reports
195
Public Tables
Reports
Tables
Published
Overrepresented Colors by Day (using RGB, HSL, and LAB)
WITH global_rgb AS ( SELECT ROUND(red*25.5)...: type: text default: week {% endform %}
Published
Overrepresented Colors by Type (using RGB, HSL, and LAB)
WITH global_rgb AS ( SELECT ROUND(red*25.5)...ab.diff_rank <= 10 WHERE rgb.diff_rank <= 10
Published
Bar Pinwheels of Overrepresented Colors
The height of the bar shows how many pictures are in the wedge of the color wheel. The ...
Published
Overrepresented Colors by account (using RGB, HSL, and LAB)
WITH global_rgb AS ( SELECT ROUND(red*25.5)...ab.diff_rank <= 10 WHERE rgb.diff_rank <= 10
Published
Overrepresented Colors by account
WITH global_buckets AS ( SELECT ROUND(lab_l...ff_rank <= 10 ORDER BY username, diff_rank
Published
Overrepresented Colors by Date
WITH global_buckets AS ( SELECT ROUND(lab_l... '2014-10-01' ORDER BY username, diff_rank
Published
Pinwheels
SELECT account_type, hue_bucket, ..._2015 GROUP BY 1,2 ) a ORDER BY 1,2
Published
Color Wheel 2
The radius is determined by saturation (full color to a greyscale color). The opacity i...
Published
Color Wheel 1
The radius is determined by the luminance (black to white, passing with the primary col...
Published
Saturation by day, fixed width
WITH pics AS ( SELECT ROUND(date/86400) AS ...y = p.day ORDER BY r.day_sort, p.sort DESC
Published
Hue by day, fixed width
WITH pics AS ( SELECT ROUND(date/86400) AS ...y = p.day ORDER BY r.day_sort, p.sort DESC
Published
Luminance by day, fixed width
WITH pics AS ( SELECT ROUND(date/86400) AS ...y = p.day ORDER BY r.day_sort, p.sort DESC
Published
Aggregates
SELECT category, attribute, pic..._2015 GROUP BY 1,2 ) a ORDER BY 1,2
Published
Hue by Account, fixed width
SELECT username, hex, account_t...e, account_sort DESC, sort DESC LIMIT 100000
Published
Saturation by Account, fixed width
SELECT username, hex, account_t...e, account_sort DESC, sort DESC LIMIT 100000
Published
Luminance by Account, fixed width
SELECT username, hex, account_t...e, account_sort DESC, sort DESC LIMIT 100000
Published
Luminance by Account, semi-fixed width
SELECT username, hex, account_t...e, account_sort DESC, sort DESC LIMIT 100000
Published
Luminance by Account, fixed picture size
SELECT username, hex, account_t...e, account_sort DESC, sort DESC LIMIT 100000
Published
Changing Chart Colors and Sizes
SELECT DATE_TRUNC('day',created_at) AS day, ...ammer_users GROUP BY 1 ORDER BY 1 LIMIT 40
Published
Sales: User Activity Account Lookup
Type in Account Name to get overview of users' key activities.
‹ Prev
1
…
3
4
5
6
7
…
24
Next ›