Airbnb has an awesome open source data viz tool called superset.
I’ve been working on getting this deployed to heroku. Getting it deployed was easy by cloning this repo here.
After I deployed it an and started experimenting, a read the FAQ which had a bombshell that joins aren’t possible. Without joins, since my datasource is postgres, the utility of the tool is pretty low.
I dug through some issues, searching for joins and came across this issue. By adding a column and a subquery, you can achieve a join.
Here’s a screenshot of adding the column: