Cumulative Average

Question & Answer
,
1

In excel, I have a column that is calculating a cumulative average of the average values in Column A using the formula =AVERAGE(A$2:A3) in column B.

The values in Column A correspond with my custom calculated field labeled Column A, but when I create a new calculated field for the cumulative average (column B) using the following (I tried runningSum and RunningAvg as I am not sure which I should use), I get an error that nesting aggregate function isn’t allowed:

runningSum 
(
  sum({Column A}),
  [truncDate("MM",{reporting_period}) ASC]
)

When I remove the brackets, I get zeros. Could someone help me figure out the right way to do this?

2

I tried a few different things and found that this matches my Excel sheet’s value so this is what I will use:

runningAvg
(
 {Column A},
  [truncDate("MM",{reporting_period}) ASC]
)
1 Like
3

Hi @bebkay - Welcome to AWS QuickSight community and thanks for posting the question. Since you explored and got the solution, please mark your answer as solution so that it can help wider community.

Keep exploring AWS QuickSight and help wider community.

Regards - Sanjeeb