Build and advanced report with simple components. Starting with a SQL query, add interactive charts and dashboard controls.

Ian Johnson

Observable

Which items are purchased together?

Co-occurrence SQL Query

Interactive filtering

Matrix visualization

Force layout visualization

Which items are purchased together

I think we should try some navigation components vs. adding the Part 1 in the title. We're working on that now in the prod ed style guide.

Paul Buffa

Let's remove the specific names of which databases we support. Just thinking this is the sort of thing that gets stale (we launch a new data connector!) and we then have to remember to update it here.

how about the change to (e.g. Postgres, MySQL, Snowflake, etc.).
i still want there to be familiar names that people recognize to make it more concrete that we support real databases

The a.name < b.name means a does not equal, right? Any reason to use instead of != ?

you need it to eliminate the symmetrical opposite that the join creates:
a, b
b, a,
a, a,
b, b