In a tool that's all about creating sub-aggregations & re-aggregations (or slicing and dicing) of tables - it can be pretty important to understand how all the queries are related (if at all). While not something you'd have on in a production dashboard - I added

"User Params as Theme System" is actually working out well, I think people will enjoy being able to pull themes out of previously saved dashboards and swapping them around. ;) Check out the very short Twitter video at the bottom to see how they are applied... * Browse the existing

Quick update on a "Theme System" - I decided that it made more sense to have a scrubbable user parameter system and use that for theme parts instead. Not everyone likes my color palettes so its a win/win. "Scrubbable User Param System w/ Theme Hooks"

2 short videos where I import 2 CSV files, join them together - and create a simple map from the resulting table... ...and here is using the viz recommendations to draw a US county map based on the joined table. 2/2 pic.twitter.com/qYiqqWCU4n — Ryan Robitaille (@ryrobes) January

Added a pseudo "value" to be used in conditional formatting - select any colorbrewer scale and direction - or use the default "temperature" scale. It'll even respect conditional formatting logic - meaning if you don't want it to apply to all the

Quick video of how the suggestion system allows for pretty much arbitrary block views to be recommended and allows the users query data to be plugged in. It feels almost magical to be able to quickly place simple (and not so simple) viz on the canvas while browsing. Like I&

Something else I always wanted in a tool like this - easy (and flexible) conditional formatting (full row or specific fields) for my grids. Drag a selected value into a "highlight target" to create a quick (SQL based) rule and then customize it as needed (via code / scrubbers)

Define potential "Viz Shapes" in the backend config files - those will be compared to the live queries that you are slinging back and forth on the canvas. Matching ones will be draggable as pre-configured blocks that run downstream from the source query block. Not designed to be

More late-night canvas SQL fun. Not just UI candy. In a system about reactive SQL sub-queries - the "lineage" of a query/block and how it relates to the other blocks is huge. Upstream/downstream, how filters cascade, etc. A neat take on the old pivot table paradigm

Viz layers. Building things interactively using the canvas as a workspace surface to separate / examine / combine items. Instead of "query mode, then viz mode, then filter mode, then dashboard mode"... Why can't we do all at the same time?#sql #dataviz #clojure #nomodes pic.twitter.com/

Value scrubbers are done(ish)! The {unnamed} project is shaping up to be a solid UX for data views / pivots in a fluid & creative way - but in a way that retains "low level flexibility" (i.e. retaining full vega-lite, hiccup, re-com, & sql "hackability"