Trouble Fixing Over function

[James Jones 2]

Hello

I have been trying to find a formula in SpotFire to properly calculate Column E below without any luck.

Would appreciate any help.

I tried this formula as a column but it didnt work:

Sum(Avg([units sold per Per Satation day]) over ([station]) over ([Date])).

If this cannot be achieved in a column, how can I achieve it in an expression

 

 

 

 

A

B

C

D

E

 

 

Station

Date

Shift

Units sold per shift

Units sold per Per Satation day

Units sold Per All Stations Per Day

 

 

A

5th Jan 2020

A

2

5

13

 

 

A

5th Jan 2020

B

1

5

13

 

 

A

5th Jan 2020

C

2

5

13

 

 

B

5th Jan 2020

A

2

8

13

 

 

B

5th Jan 2020

B

2

8

13

 

 

B

5th Jan 2020

C

4

8

13

[James Jones 2]

I want to plot Date VSUnits sold Per All Stations Per Day in a bar chart.

[Fabian Duerr]

There is no need for a calculated column if you just want to have it in a bar chart.

The value for the calculated column that you are looking for is basically just

Sum([units sold per shift]) over [Date]In a bar chart you would useSum([units sold per shift]) on Y axis and [Date] on X axis