Pre-filter 30-day sum

Question & Answer
1

Is there a way to calculate the sum of a variable for past days, even if the past days are not within the data being filtered for visualization, but present in the dataset?

For instance, I tried using windowSum, but the issue is that the aggregation starts from the first date being visualized, which it’s not what I’m looking for.

If I’m visualizing total sales for filtered dates; let’s assume the last seven (7) days, and the first date in my table is 8/10/2023. I need a calculated field to display the total sales for that specific date, in addition to the past 29 days (even if the past 29 days are not in the table, but present in the dataset). Therefore, if the sales for the past 29 days were $90,000 and the sales for 8/10/2023, $5,000; the calculated field should display $95,000.

What would be the best way accomplish that?

2

hi @cbz,

Welcome to QuickSight Community. thank you for posing your inquiry!

the demo dashboard here at demo central might be able to help to accomplish. you can go into Analytics view by clicking the icon presented in left pain so that you can see the details of the implementation.

hope this helps.

kind regards,
Wakana

3

@cbz

We have not heard back from you regarding your question. We would still like to help. If we do not hear back in the next 3 days, we will archive the question.

4

Hello @cbz ! We have not heard back from you in a few days so this question will be archived. If you still need help please repost your question in the community.