seakinshmm. I get what you mean.
If you want more customization, you could try using measured filter. For instance you could create a formula:
- (sum(revenue), date) with a filter on date for 2020 (or make it dynamic with this year)
- (sum(revenue), date) with a filter on date for 2019 (or make it dynamic with last year and 1 more for 2 years ago)
- (sum(revenue), date) / (sum(revenue), date) for a percentage
The only thing is that users cannot change these filters, so this could be an hassle.
![]()
However making it more dynamic / letting it have more user interaction, might be difficult. Atleast I would not know how. Perhaps there is someone here that can help you out 🙂
