3 Replies Latest reply on Dec 5, 2018 5:05 AM by Zhouyi Zhang

# Using Bin Values as a benchmark

I have tried to use LODs to get to the solution without any success.I want to use the values of a certain bin as a fixed benchmark to compare other values to.  I've attached a sample data set, and am specifically trying to accomplish the following.

The benchmark I want to capture is the Retention Rate (Number of Contracts WHERE Returned = 1 / Number of Contracts WHERE Returned = 1 OR 0) when the Change In Price is 0 for every Payment Amount Bin.

For example this would be the benchmark for Bin 0.

 Payment Amount (bin) Returned Number of Contracts Benchmark 0 0 2 0.333333 0 1 1 0.333333

It's the percentage of total contracts that returned. I am able to calculate this value and hide the Returned = 0 column. However, I am not able to set it as a fixed benchmark value. For example, I want to be able to change the Change In Price slider to 10 and compare the Retention Rate of those values to the benchmark of Change In Price = 0.

• ###### 1. Re: Using Bin Values as a benchmark

Hi, Alex

Is it something like this you expected? if yes, please find my solution attached.

Hope this helps

ZZ

• ###### 2. Re: Using Bin Values as a benchmark

Hi Zhouyi, thank you for your response.

To further clarify I want to be able to compare any Change In Price to the benchmarked 0 bin. For example, below are the correct benchmark values that I want to compare any Changes in Price to:

Below is currently what shows when I move the Change in Price slider to 10. Taking an example Payment Amount (bin) = 300: I would want to compare the return rate (19/29 = .65) to the benchmarked 0 Change in Price above (.525).

• ###### 3. Re: Using Bin Values as a benchmark

Hi, Alex

Is it something like this? If yes, please find my solution attached.

ZZ