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

[sunny_talwar · Accepted solution]

Got it

Try this:

If(Num(Rank(TOTAL If(Sum([Unique Clickthroughs]) > 0 and Sum([Total Sends]) > 0, [Email Sent Date]), 4, 1)) <= 10,

If(Change <= -0.10, 'qmem://<bundled>/BuiltIn/led_r.png',

If(Change <= 0.10, 'qmem://<bundled>/BuiltIn/led_y.png', 'qmem://<bundled>/BuiltIn/led_g.png')))

[bharatkishore]

Thank you genious.. Only one query i have i have 3 more expressions in this chart. Can i apply the same logic for the remaining 3 expressions.

[sunny_talwar]

I believe you should be able to use a similar logic for showing images. Give it a try and see what happens

[bharatkishore]

Sure and will let you know.. I thank u once again.. thank u so much.

[sunny_talwar]

No problem at all . 

I only ask for you to mark any helpful responses, as it might help other people in the future looking for answers. Make sure to mark only those responses as useful which were truly helpful.

Thanks,

Sunny

[bharatkishore]

Sure and will do it...

[bharatkishore]

HI Sunny,

I tried for all the expressions and all are working perfectly.

I thank you once again.

Thanks,

Bharat

[sunny_talwar]

Perfect, I am glad you tried and made it work

[bharatkishore]

Thanks Sunny but without you i cannot made to happen. Thank u genius once again.