Calculate delta from top rank

[#1]

Hi,

The data I have a field already calculated in the script side called PERCENT_EMAIL. It relates to the % of customers with a completed email, my dimension is SALES_REGION.

The data I have only has 5 SALES_REGION and the rank(PERCENT_EMAIL) works fine.

Say UK has 80% PERCENT_EMAIL and is rank #1, I want to be able to calculate the delta from this for the other SALES_REGION. Say Europe has 79% we would want to show -1%. This would preferable be done as an expression.

Thanks

Stuart

[sunny_talwar · Accepted solution]

May be this:

Dimension: SALES_REGION

Expression:

Only(PERCENT_EMAIL) - Max(TOTAL PERCENT_EMAIL)

[#3]

hi - good idea but it gives answers as 0.00% for each region

[sunny_talwar]

Did you add the TOTAL qualifier within the Max function?

Only(PERCENT_EMAIL) - Max(TOTAL PERCENT_EMAIL)

[#5]

Sorry man I had not spotted the TOTAL part. Yep that worked, kudos to you.

thanks very much for your help

[sunny_talwar]

Awesome