Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi All
I and dimension called A have written an expression for calculating a metric called unique contact. The expression is
=(sum([Total Sends])-sum([Total Unsubscribes]))-sum([Total Bouncebacks])
By writing this i have got a value for example say 1799.
By doing avg of that whole 10 values i got 6003.
Now i need to calculate the avg which is like 1799/6003.=29.97
Can you please tell me how can i achive this.
Attached excel for more understanding
You have dimension limits. Try this
=((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))
/
Avg(TOTAL {<[Email Name] = {"=Rank(((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))) <= 10"}>} Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), [Email Name]))
May he this:
=(Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks])
/
Avg(TOTAL Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Name))
Hi Sunny,
Thanks for your reply.
Please find the attached screen shot. I m not getting the exact output.
Can you share the screenshot of expression you have used for the avg column?
try a expresion like
sum(value)
/
average(sum(total value))
Please find the attached screen shot..
Try this:
=((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]))
/
Avg(TOTAL Aggr((Sum([Total Sends]) - Sum([Total Unsubscribes])) - Sum([Total Bouncebacks]), Name))
Hi Sunny,
Please find the attached.. I am not getting the correct values. Don't know where i am missing
Are you using calculated dimension by any chance?
No No.. i m not using.. directly taken the field.