Carry Over Sum by Date in Line Charts

Hi folks, looking for some help with line charts. I want to display the sum of data points up to a date, by date. So let’s say I have one data point with date 2021-12-09 and two data points with date 2021-12-10 , my chart should display the value 1 for the first date and 3 for the second date. I am achieving this by using window functions in my query, however this won’t allow me to filter by other fields in quicksight. I am sure I am overthinking it and there should be an easier approach. Any thoughts?

It looks like you are trying to do a running sum. If yes, then you could try the RunningSum function which will allow the filters to be passed