Hi everyone,
I have a question regarding how we can add a filter on a dashboard with multiple trend filters.
Those filters are based on a fact table, so based on year/month/first day of the month. Each trend is represented for the last month on my table (now it's November 2024), plus also versus last month (October 2024) and versus 12 months ago (November 2023).
Let's say want to focus the last month on a specific month like September 2024. If I put a filter on year/month I will be able to have the main indicator of the card working but not the previous month/year.
Did you know a way to solve this? Also to mention that I need this for request done by using the wizard.