I’m new to metabase and i’m trying to setup some basic reporting for my team. I’m working with retail sales data and we constantly need to run reports like TY/LY comparisons or “next month, last year” . I’ve read a few tutorials about trends and smart numbers being a good way to do this, but so far have not had good results graphing, I always get stuck with a graph of a single period of time or a smart number telling me the difference.
I want to end up with a dashboard where users can select time periods for comparison. I’m comfortable writing the raw sql if needed, but I was hoping to get away from it by using metabase. Whats the best way for me to set this up?
Thanks in advance for any help !