Hi, I am trying to create a dashboard that is looking at WTD (week to date), MTD (month to date) and YTD (year to date) for both this fiscal year but also for last fiscal year. For example: We are now in March fiscal month and it started 2nd March 2025. The fiscal year started with February and on 2nd February. I want to be able to see the data up until including yesterday (4th March). For last fiscal year: It started 4th February 2024 and ended 1st of March 2025. WTD this year is 2-4 March (and same for MTD) and YTD for this year is 2nd February - 4th March. WTD for last year is 3-5 March 2024 and YTD for last year is 4th February-5th March. I want this to automatically update everyday to include the next “yesterday”. I hope someone can help me with this. Thanks in advance.
Hi @TiredMia and welcome to the Quick Sight community!
What in particular about what you mentioned above are you having difficulty with?
What does your current dashboard look like and how is it not accomplishing what you’d like it to..that way we know where to start in assisting.
But to start, if you’re trying to limit the data being returned, I would suggest utilizing date parameters as those can help in limiting the returned data.
You can also explore this article, which talks about creating period comparisons.
Hi @TiredMia
It’s been a while since we last heard from you. If you have any further questions, please let us know how we can assist you.
If we don’t hear back within the next 3 business days, we’ll proceed with close/archive this topic.
Thank you!
Hi @TiredMia
Since we have not heard back from you, I’ll go ahead and close/archive this topic. However, if you have any additional questions, feel free to create a new topic in the community and link this discussion for relevant information.
Thank you!