[btown]

My startup seriously evaluated Metabase, but inevitably you'll want joins, and Metabase is fundamentally opposed to the idea: https://metabase.com/blog/Joins/ ... and if you're writing SQL for your views, you might as well be writing SQL.

We ended up shelling out for Tableau - it's pricey at $840/yr, but it supports joins out of the box (it even has a drag-and-drop interface to set up joins!), has practically every bell and whistle you could ask for, and allows you to do "exploratory analysis over screenshare in realtime with non-technical colleagues, without context switching to a coding mindset or needing to look up field names you may never have used before." I think it's intuitive and worth every penny, but YMMV. Would recommend everyone try the public version to get a feel for it.

EDIT: as others have said, Ananas is actually ETL + BI, whereas Metabase and Tableau are BI on top of a database. Tableau can stand in for good ETL due to its join support in certain scenarios. It's better than Metabase, but not necessarily comparable to Ananas.

[getsauce]

Metabase added joins to query builder in a recent release: https://github.com/metabase/metabase/releases/tag/v0.33.0-pr...

[tlrobinson]

(I work at Metabase, and am working on the joins feature as we speak)

As getsauce mentioned, we're adding joins to the next release, as well as essentially subqueries in what we're calling the "notebook". That should unlock a lot of power.

AMA.

[fegul]

Big fan of Metabase, thanks for all your work!

I've always been curious if there is a feature in the works for charting or displaying comparisons across defined timespans (e.g. total page views this week vs. last week)

[tlrobinson]

Thanks!

We have a "trend" visualization: https://www.dropbox.com/s/qg54b6owdatznmm/Screenshot%202019-... Is that like what you're looking for?

[fegul]

That certainly looks like it's in the right direction, I'll re-familiarize myself with the docs again since it's been a little while