Need to calculate average

[bharatkishore]

Hi All,

I have a straight table chart and in the presentation tab i have given max number as 10 values.

I have campaign and email send date as dimension and my expression is

sum([Unique Clickthroughs])/sum([Total Sends]).

Now by doing this i have got some values.

Now i needed an expression to calculate the avg of those 10 values.

Attached excel for reference and how i am calculating  the values.

Thanks

Bharat

[vishsaggi]

May be try this: Change accordingly.

= Num(Avg(Total  [Unique Open Rate]), '#,##0.00%')

[bharatkishore]

Tried.. but no value is coming..

[vishsaggi]

Can you share your sample app if possible?

[bharatkishore]

please check the attached qvw and excel which values should come and for the calculation also.

[vishsaggi]

Bharat, I think the values from excel sheet you sent works fine with the initial expression i sent, but there are synthetic keys in your data model. Can you send the actual two excel files you are loading into this qvw file if possible ?

[bharatkishore]

You can remove the second tab in script.

I have tried with the same expression but it is not working for me.

If possible can u please send me the file. so tht i can check

[vishsaggi]

I have just used your excel sheet and the qvw file and it worked.

Please check and let me know.

[maheshkuttappa]

Below expression should work

Num(([Unique Open Rate]-Avg(TOTAL [Unique Open Rate]) )/Avg(TOTAL [Unique Open Rate]),'###.##%')

[Greg_Williams]

Does this address your request?

Perhaps, if not, consider AGGR function, or TOTAL added to your sum or avg function.

-gw