SumOver within WindowSum

[MKuhns01]

You can’t achieve your expected results by filtering on {order_time}

What you need to do is create a new calculated field like so:

minOver(min({order_time}), [{order_time}])

And then use the calculate field within your visual.

This pushes Quicksight to first calculate the window sum, and then apply the filtering for the visual after the sum is calculated.

You can read more about it 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?

We conceptually need to ‘hide’ those values and not filter them. To do this we will manipulate where this filter happens in the query pipeline, and by using a Table Calculation, we can make it happen all the way at the end, after the YoY calcs have already been computed. Write a calc like this: minOver(min({order date}), [{order date}]) And then put your filter on that. Should work! Before: [image] After: [image]