How to calculate an interpolation...

[Former Member]

Hi Everybody,

Iu2019m struggling with the percentile calculation using simple interpolation.

I have following inputs:

Table:

Day_bucket 1| 2| 3| 4

Responses 10| 20| 50| 20

Cumul_responses 10| 30| 80| 100

Percentile 0.1| 0.3| 0.8| 1

1. Day_bucket u2013 days from 1 to 100 (dimension)

2. Percentile u2013 percentile distribution u2013 how many % of all responses have been received in a particular day from Day_bucket dimension (measure)

3.Interpolation equation: d=d1 + ((g-g1)*(d2-d1)/(g2-g1))

g - percentile you are looking for (in my case 0.9)

g1 - MAX percentile < 0.90 (in my case 0.8 )

g2 - MIN percentile > 0.90 (in my case 1)

d1 u2013 Day_bucket where percentile is equal to g1 (in my case 3)

d2 u2013 Day_bucket where percentile is equal to g1 (in my case 4)

d u2013 value Iu2019m looking for (in my case 3.5)

Now what I need to do is to get the result of above equation into one field. And my problem is that I not able to calculate g1, g2, d1, d2.

Can anybody help me? Is it actually possible to make such calculation in Business Object?

Edited by: gonosgon on Jul 20, 2010 2:46 PM

[Former Member · Accepted solution]

you can give a try to these formulas:

g1 = Max(Percentile) in Report Where (Percentile < g)

g2 = Min(Percentile) in Report Where (Percentile > g)

d1 = Day_Bucket where ( Percentile = g1)

d2 = Day_Bucket where ( Percentile = g2)

Regards,

Rohit

[Former Member · Accepted solution]

Hi Rohit,

Thank you very much for your help. It worked!

Gonosgon

[Former Member]

Hi gonosgon.

I do think this is possible in Web Intelligence. I think you would need to create some variables in order to do what you need. I am not 100% clear on what you need to do, but if you create some variables in your report, for instance, for g, g1, g2, d1, d2, etc. this may allow you to do what you need. These variables can then be built off other variables.

If you have access to your universe, then you can simply create the objects you need with these pre-calculated.

Hope that helps!

[Former Member]

Hi wavery,

Thanks a lot for your advice. I'll give it a try...