@evaS: thanks @jornh! As soon as I find some time I might start with describing how filters work as I think this is something a lot of new users struggle with.

@jornh: OK cool don’t forget to point to that people should also Read The Fine Manual where appropriate. But I guess if you feel like sharing and adding more tutorial style or tips&tricks info a lot of peeps would appreciate that very much. (Myself as a relative SQL noob including) … and remember do it on your own time - as you feel like it - don’t feel pressure - ever!

The totally awesome beginners guide to how filters in Metabase work

TODO

apart from the info on filters in the user guide … here are a few things that we learned the hard way over time worth sharing …

it might be obvious but there is a different syntax you need to use depending on what filter you want to create:
Field filters: AND {{variable}}
Text filters: AND field_name = {{variable}}

SQL tips&tricks solutions to overcome or work around current limitations:

In a dashboard there is a question that returns a tabular view of users. I would like to be able to click a row of this and for it to take the ID and load up the single user dashboard with that ID.
Is this possible - if not is this a feature that is being worked on because it would be great.
(Also as a side note - can we expect the ability to create questions with python/javascript/java etc for more complex questions in the future?)

When using filed filters in a sql query with joined tables, you can´t use table aliases:

Hi, I’ve this query:
SELECT c.business_name,b.lastname, b.firstname,(a.tot_time*b.costo_orario_ordi) as Costo FROM db_summary_syn a
LEFT join users b ON a.codfis=b.codfis
LEFT join db_companies c ON a.idcompany=c.id
WHERE b.onoff=1
[[ AND {{v_lastname}}]]
[[ AND {{v_firstname}}]]
[[ AND a.dataora={{v_dataora}}]]
ORDER BY c.business_name,b.lastname, a.dataora
v_lastname and v_firstname are linked to users.firstname and users.lastname.
When I select a value from this two value and run qu…

Hi Jarry, I might not understand your question right - what are you trying to do exactly? With the SQL editor you are able to do flexible dates like And str_to_date(concat(date_format(table.created_At, ‘%Y-%m’), ‘-01’), ‘%Y-%m-%d’) BETWEEN str_to_date(concat(date_format(date_add(now(), INTERVAL -12 month), ‘%Y-%m’), ‘-01’), ‘%Y-%m-%d’) AND str_to_date(concat(date_format(date_add(now(), INTERVAL -1 month), ‘%Y-%m’), ‘-01’), ‘%Y-%m-%d’) what gives you always (as an example) the last 12 months …

How can I compare my this month's transactions with the last month's transactions? I've created 2 questions to get the number of transactions this month and last month, when putting then together in my dashboard, I was expecting to see the bars for July 1st and August 1st (and all the other days) beside to each other, for comparison. This is the result I got, the whole July's transactions in green and this month's transactions in blue.
This is essential in many reporting when comparing week on…

I’ve been meaning to test this idea for a while, finally found the time today. If there’s enough interest and people struggle with this, I’ll do a proper ‘How To’.
First the bad news (for some of you). You need Windows. Get over it! :stuck_out_tongue_winking_eye:
I’m not including details of any security settings to keep stuff clearer.
Install SQL Server Express (2016 or 2017). This is the free edition, only limitation is the database size of 10GB. As we’re not storing any data, that’s not a …

I’ve found that in 0.28 I’m limited when I use SQL Queries as it prevents me using multiple values in a filter. My solution so far has been to just use a view.
Then I realised that the customer I’m working for is one of the few who would allow me to create views on their database, so had to come up with a new solution for future use.
Answer is to use SQL Server Express with linked servers. I can then create views of the ‘proper’ database within a new database in Expess. On top of that, I then …