Calculating average of values of n periods

[Anonymous]

Hello,

i want to calculate the average of actual sales of products. The problem that the number of period changes from a product to another beacause it depends on its launch period. To explain more we take for example a product A, it is a new product and it was launched two months ago and a product B that has more values because it is older than the product A.

So i have products and their sales per month and i want to calculate the sales average.

Thank you,

Alâa Eddine.

[olivierrobin]

hello

maybe something like

load product,sum(sales)/count(distinct month) as average

group by product

[Anonymous]

Hello,

thank you but it does not work.

[olivierrobin]

what does it mean ?

no result ? wrong result ?

can you post your code ?

[Anonymous]

Hello,

this is what i have as datas.

I want to add a column to calculate the average for each SalesAggregatedBrand.

[Anonymous]

Hello,

you can notice here that for the product "ADVANCE" there is only five periods available so the average will be the sum of Actual Sales divided by 5 and for the product ANATEO i have to devide the sum of actual sales   by 15 because we have 15 periods.

How can I do that?

Thank you,

Alâa Eddine

[olivierrobin]

and what about

sum(Sales)/count(distinct YearMonth)

[Anonymous]

Hello,

i noticed that he devided the sale volume by 60 for all the products and for all periods.

Any ideas, please?

[olivierrobin]

did you use it as expression in your graph ?

[Anonymous]

Hello,

i show you where i used.