Bennett Stancil's reports | Mode

@benn

Bennett Stancil

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.