Trend data

Get Help
1

Hi there,
One good chart on a dashboard is the trend chart. Unfortunately, the trend chart only lets you compare current data with the data of the previous period.

Is there a way to compare say monthly sales with sales from the same period last year (or last quarter).

In cyclical businesses, this is far more important data compared with current month to previous month.

I tried to emulate such function with SQL but quickly becomes very heavy and partially impossible(labels cannot be customised then)

Thanks for the support
Peter

2

Hi @roestigraben
Think you are looking for this:
https://github.com/metabase/metabase/issues/5817 - upvote by clicking :+1: on the first post

It’s possible to do static time comparison with Custom Expressions:
https://www.metabase.com/learn/building-analytics/notebook-editor/time-series-comparisons.html

3

Thanks a lot, the 2nd link seems to me to go into the direction I want. Let me try this!

4

Hi flamber,

you mention up-vote. What is this? I will do it but pls let me know how :wink:

5

@roestigraben Click the :+1: icon in the bottom of the first post (the description) of the issue, where there’s currently 74 upvotes for this issue - you’ll need a GitHub account to do so.