Comparison with Last/Previous Year

[jayanthan]

Hi

is there any option to compare selected year values with previous year

Please advise

Regards
Jayanthan

[EvaS]

Hi, not when you use query builder (although you should vote for the github issue: How to do Month vs Month , Q1 of 2015 vs Q1 of 2016 comparisons ? · Issue #5606 · metabase/metabase · GitHub), but you can do it with a bit of SQL syntax - have a look at this discourse issue to find my code that solved it for me:

This month VS Last month graph?

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 …

Hope that helps!

[jayanthan]

Hi Eva

Noted. Thank you for the prompt reply

Regards
Jayanthan