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!