@benn
Bennett Stancil
-
Published Adding Shading to Charts
SELECT DATE_TRUNC('day',occurred_at) AS day, ...rial.playbook_events GROUP BY 1 ORDER BY 1 -
Published Multiple options in a Parameter dropdown
SELECT * FROM benn.fake_fact_events {% as...send_message']] {% endform %} -
Published All Example with Textbox
How to add an "all" parameter to a report with a blank textbox. -
Published Looping over items in a category
WITH category_table AS ( SELECT DISTINCT even...}}.item_rank = {{i}} {% endfor %} GROUP BY 1 -
Published Getting Visible Columns in HTML
SELECT * FROM benn.nfl_touchdowns -
Published Result Difference Example
An example for showing the difference between two query results. -
Published Movie Review Word Counts
Example of how to do word counts with Postgres. -
Published Finding Events By Session Referer
How to find an the number of events that occurred in sessions by the referer of the fir... -
Published Table Filter
An example of adding a filter to Mode reports. -
Published Looping Over Columns
Making a string of values in a single cell using Mode loops. -
Published Adding missing dates with SQL
SELECT dates.day, COALESCE(values.valu...es ON values.day = dates.day ORDER BY 1 -
Published Adding a Totals Row to the Bottom of the Table
How to add a totals row to the end of the table. Currently only does sums, but could do... -
Published Slack Alert Example
SELECT * FROM tutorial.playbook_users WHER...ed_at IS NOT NULL ORDER BY activated_at DESC -
Published Editing the Link Target with a Parameter
SELECT name, region, '{{search_...gle], [bing,bing]] {% endform %} -
Published Making Links without URLs
How to make results links without displaying the full URL. -
Published Links in Tables!
How to make links in Mode tables. -
Published Making URLs Links
How to make URLs links. -
Published Untitled Report
SELECT ( EXTRACT('year' FROM date)::VARCHAR ...s GROUP BY 1,2 ORDER BY 1 DESC,2 LIMIT 600 -
Published Adding Multiple Entries in a Query Parameter
How to add multiple entries to a query parameter. Each entry should be separated by a c... -
Published Device Drilldown
A report for seeing all the users of a particular device. An example for "How to..."