Issue with average calculation in Window

Hi everyone,

As said in the title, I have an issue to get a calculation of average for the parameter "Spending" in a Window calculation.

It is an example of list of customers, with dates of visits and spending. I have previously calculated for each customer the visit number ordered in time ("Visit_number"), and binned this parameter with a width of 2 ("Visit_number_bin"). The dataset before the Window step looks as shown below :

With the Window calculation, I aim to calculate the average spending for a partition defined by Customer / Visit_number_bin.

The Window calculation is set as shown below :

But the result I get is a moving average of spending in each partition, rather than simply the spending, as illustrated below. For example, the lines 2 and 3 are one partition, and I would expect the spending average to be 6.5 for both these lines, but it is 9 on the first line, and 6.5 on the second line. I do not understand why I get a moving average in the results, as I set the "Window frame" to off.

Does anyone have an idea how to set the Window calculation to get the average for each group?

Thanks in advance for your help.

Olivier