Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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')))
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.
Sure and will let you know.. I thank u once again.. thank u so much.
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
Sure and will do it...
HI Sunny,
I tried for all the expressions and all are working perfectly.
I thank you once again.
Thanks,
Bharat
Perfect, I am glad you tried and made it work
Thanks Sunny but without you i cannot made to happen. Thank u genius once again.