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