RE : Latest Week as filter

Question & Answer
, ,
1

Hi,
I currently have a sticker which has latest week filter based on snapshot day but the way I am showing is by filtering on previous 1 week but when the data doesn’t get updated then
I would previous week numbers as the week in the sticker in dash. Any insights would be great on this ?

image
image2263×305 44.1 KB

1 Like
2

Hello @parthprj, just to confirm, you want it to return data for the previous week related to the latest date ingested not the current date, is that correct?

I created a demonstration of this functionality in an Arena analysis. I split it up into a few calculated fields, but basically I found the max value for a truncated week date in the dataset (See Latest Week calculation). Then, using addDateTime I subtracted 1 week from that max date (see Previous Week). To make sure it was the Sunday date to notate the beginning of the previous week, I truncated the output date as well to the week (Truncated Previous Week).

Now, to filter the visual, I created a calculated field (Previous Week Filter) that will return a 1 if the date is greater than or equal to the Sunday of the previous week, otherwise it returns a 0. This is the field I applied as a filter, requiring the value to equal 1.

My dataset only goes until the end of 2024, so it will display the last 2 weeks of December. This should dynamically display the latest weeks in your data:
RE : Latest Week as filter

Let me know if you have any questions!

3

Hello @parthprj, did my previous response help you achieve your desired output? If so, please mark my reply as the solution. Otherwise, let me know what other questions you have on this topic and I can help guide you further.

If we do not hear back from you in 3 days, I will archive this topic. Thank you!

4

Hello @parthprj, since we have not heard back with any remaining questions, I will close out this topic. If you need further assistance, please post a new question and include a link to this topic to provide relevant information. That will ensure you are at the top of the priority list for a response from one of our QuickSight experts. Thank you!