Using Date Hider

georgeAWS4 · March 25, 2025, 1:43am

Hi Guys,

I’m trying to show various metrics for the last four weeks in the table as below, but am struggling to make a previous year YTD calc work:

The value showing currently is just the total for the week referenced in that row (same as column 1 ‘Lbs’ in the table - no formula just sum(Total Quantity: AU = Received) for the week). This is the formula I’m using:

And I’m using the Date Hider filter @Jesse suggested here (How do I superimpose a period over period in a visual without having the period that I'm comparing it to in the visual?)

I’ve also tried getting the YTD difference in the table so I could calculate last year’s YTD value by subtracting that from this year’s. This is coming up as blank in the table though…

I’m wondering if I need to use the Date Hider differently, although I’ve seen what I’m trying to achieve work perfectly fine here (How do I superimpose a period over period in a visual without having the period that I'm comparing it to in the visual? - #14 by rusu2k)

Any help would be greatly appreciated!

Brett · March 27, 2025, 4:43pm

Hi @georgeAWS4,
Looking at the old community post for reference, did you setup the minOver calculation to use as a filter like the one that was shown in the previous example?

Additionally, this may be easier to assist further if you’re able to create a copy of your analysis and upload it to the QuickSight Arena view, that way we can test out solutions that may work for your case!

georgeAWS4 · March 31, 2025, 11:39pm

Hey Brett, thanks so much for the response. Let’s try work through a solution here: QS Community Weekly Volumes Dummy

georgeAWS4 · April 2, 2025, 12:04am

@Brett please see above arena analysis

Brett · April 11, 2025, 6:49pm

Hi @georgeAWS4,
Apologies for the delayed response, I saw that you created a new topic for this question so I provided a response on that post. I’ll close out this topic so there are not duplicate questions open!