I’m trying to create a calculated field that shows the period to date sum over time but with: summing a field based on a condition using a more specific period (e.g. instead of WEEK or MONTH, I need 90 days) For part 1, I’ll give an example: field A is fruits, field B is quantity of fruits I’d …

Feature Request - Conditional periodToDateSumOverTime

duncan April 5, 2024, 8:10pm 2

Hello @oconnellpatrickc , welcome to the Quicksight community!

You should be able to achieve this using a conditional statement similar to this:

Could you share the calculated fields that have thrown that error?

1 Like

Topic		Replies	Views
runningSum however, the new calculated field will stop summing values after a defined period Q&A calculations , how-to	1	376	September 30, 2022
Pre-filter 30-day sum Q&A calculations	4	311	September 1, 2023
Make Filter not applicable for Running Sum Q&A calculations , how-to	5	2344	January 6, 2023
Showing year to date sum without showing all rows Q&A analysis , filters , calculations	5	707	May 9, 2023
Prevent runningSum/periodToDateSumOverTime values continuing into the future Q&A formatting , Business-Intelligence-Engineer	6	51	March 3, 2025