Subscribe Bookmark RSS Feed

How to Cum Mean Row by Row

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Hi all,

I have a column which displays the satisfaction percentage and I would like to have another column which takes the Cumulative Mean row by row. What is the script for it?

Many thanks in advance

8828_2015-05-23_14-12-23.png

1 ACCEPTED SOLUTION

Accepted Solutions
Solution

New Column("Moving Average",

    Numeric,

    Formula(

        If(Row() == 1,

            :CUSTOMER SATISFACTION INDEX,

            (:Moving Average[Row() - 1] * (Row() - 1) + :CUSTOMER SATISFACTION INDEX) / Row()

        )

    )

);

3 REPLIES
Solution

New Column("Moving Average",

    Numeric,

    Formula(

        If(Row() == 1,

            :CUSTOMER SATISFACTION INDEX,

            (:Moving Average[Row() - 1] * (Row() - 1) + :CUSTOMER SATISFACTION INDEX) / Row()

        )

    )

);

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Thank you!

saitcopuroglu

Community Trekker

Joined:

Sep 29, 2014

Hi MS,

Would you please show me how to add "by variable" to the script above?

CSI by Year,

CSI by Year by Agency

CSI By Year by Agency by Month...

Many thanks in advance