Average number of SKU's day by day

[Rpxx]

Hi,

I have a table with ordered SKU's. One line is a one position on one order. In one order client can buy many different SKU's. I'd like to calculate and analize average number of SKUs day by day. Could you help me?

Date	| No of order	| SKU	| Volume
2022-12-01	| 001	| 02222	| 2
2022-12-01	| 001	| 01111	| 4
2022-12-01	| 002	| 02222	| 10
2022-12-01	| 003	| 02222	| 3
2022-12-01	| 003	| 04444	| 2
2022-12-01	| 003	| 06666	| 9
2022-12-01	| 003	| 01111	| 2
2022-12-02	| 004	| 02222	| 4
2022-12-02	| 005	| 03333	| 2
2022-12-02	| 005	| 04444	| 7
2022-12-02	| 005	| 01111	| 4
2022-12-02	| 006	| 05555	| 7

Date	| Avg no of SKU in order
2022-12-01	| ?
2022-12-02	| ?

[Rpxx]

average of count SKU per day

[Anonymous]

Hi @Rpxx ,

What is the expected result? Average of Volume per day or average of count SKU per day?

[Rpxx]

average of count SKU per day