Your Privacy Matters: We use our own and third-party cookies to improve your experience on our website. By continuing to use the website we understand that you accept their use. Cookie Policy
3914
How is InterpolateSimple work if subsequent value is missing data
posted

Hi,

Since NullHandling is not available to all chartTypes I would like to simulate the behavior for other charts by passing in appropriate data.

Regarding this... how is a missing value determined for NullHandling.InterpolateSimple when subsequent value is missing data as well in the following formula

interpolatedValue = (precedingValue / 2) + (subsequentValue / 2)  // this is the formula Infragistics uses to calculate missing data

Thanks

Sangeetha

Parents
No Data
Reply
  • 26458
    Verified Answer
    Offline posted

    Hi,

    When the chart sees a null value it will see what the latest and the next available non-null values are. It will then replace each null value with an interpolated value based on the above formula. To make this clearer, I'll use an example. For the data values {10, 20, null, null, null, 40} interpolateSimple option will give you the following result: {10, 20, 30, 35, 37.5, 40}, so the first null is (20+40)/2, the second null is (30+40)/2, etc.

Children