Hello, I want to count the number of pipeline names partitioned by pipeline type. I have used a table calculation to obtain my expected result. However, for months where there are no pipeline types, the result is blank. runningSum( count(name), [{created_month} ASC], [pipeline] ) [image] For ins…

At AWS, our roadmap is primarily driven by our customers. Your feedback helps us build a better service. I have tagged this as a feature request.

Table calculations return blank result

riletan August 28, 2023, 2:54am 7

Hi @Xing .
Thank you, I already tried this, the value is still empty on the new calculated field.
I did some more research and found this post:

It seems a runningSum (or table calculations in general) limitation.

Topic		Replies	Views
runningSum - how to avoid NULL values Q&A	3	875	February 13, 2024
runningSum also return NULL on NULL value Q&A calculations , Business-Intelligence-Engineer	2	209	October 7, 2023
When using running sum, how do you fill in the values for missing dates? Q&A analysis , feature-request , calculations	3	654	June 19, 2023
Runningsum results appear blank Q&A calculations	6	1798	November 7, 2022
Running sum gaps Q&A feature-request , calculations , Business-Intelligence-Engineer	3	70	October 27, 2025