Iu2019m struggling with the percentile calculation using simple interpolation.
I have following inputs:
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