Aggregating averages (Sum/Count)

[#1]

Hi all,

Please is there any reason why the following will not work? It works if I calculate the sales average (sum/count) of each product separately; however, it does not work if I try to aggregate the sales average of both products. Am I missing an aggregate function?

=Num(sum({<Sale_Date={">=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))"},ProductType={'Product 1'}>} Sales)/

Count({<Sale_Date={">=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))"},ProductType={'Product 1'}>} Sales

+

sum({<Sale_Date={">=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))"},ProductType={'Product 2'}>} Sales)/

Count({<Sale_Date={">=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))"},ProductType={'Product 2'}>} Sales),'##%')

Regards

[t_chetirbok]

Hi!

What dimension are you use?

Post some example qvw, please.

[#3]

Hi,

The dimension is Sales

Unfortunately, I can not post the qvw.

[Anonymous]

try this:

=Num(

((sum({<Sale_Date={'>=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))'}, ProductType={'Product 1'}>} Sales)

/

Count({<Sale_Date={'>=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))'},ProductType={'Product 1'}>} Sales))

+

(sum({<Sale_Date={'>=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))'},ProductType={'Product 2'}>} Sales)

/

Count({<Sale_Date={'>=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))'},ProductType={'Product 2'}>} Sales)))

,'#.##')&'%'

[Anonymous]

also make sure Format of your expression and SalesDate should be same...

[Kushal_Chawda · Accepted solution]

May be like below

Num(sum({<Sale_Date={">=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))"},ProductType={'Product 1','Product 2'}>} Sales)/

Count({<Sale_Date={">=$(=Max(Sale_Date)-30)<=$(=Max(Sale_Date))"},ProductType={'Product 1','Product 2'}>} Sales),'##%')

[t_chetirbok]

So, do you want to get a straingt table with Sales as dimension ans sum Sales as expresion?

[Anonymous]

Sales is your dimension???

Which chart you are using?

[#9]

This works perfectly well.

Thanks a lot

Regards to all.

[Kushal_Chawda]

I am glad that it is helpful.