Inappropriate Null Data Representation in Function Series
Posted: Wed Oct 25, 2006 5:46 am
Hi, supporters.
We are using TeeChart ActiveX v7.0.1.0 for our product, Report Designer.
We have encountered below three problems when using Exp.Moving Average Function Series with NULL values. We are posting this matter on the forum since we haven’t received any response form you although we already sent a Pro Priority Question email on 11th of Oct.
1. It appears null values are treated as if they have numeric values of 0 by Exp.Moving Average Function Series. We’d like to know whether a Function Series can be represented without being aversely affected by null data.
Symptom: When S0 Line Series represents the Source data whereas MA5 shows Exp.Moving Average Function Series, the MA5 Series graph drops dramatically when it deals with null data.
We know null values are received as null but represented as if they are 0 with invisible RGB value (assuming white).
FYI. The setting is as follows; Calculate using: Every number of points / Number of points:5 / Alignment: Center
2. Is it possible to have Min/Max scale of Left Axis without reflecting null values but effective values?
In fact, the minimum value of S0 Series should be set at about 350 instead of 0.
We assume that this is caused by assumed 0 numeric values when the values are, in fact, null.
3. Is there any readily available API function that refreshes the Function series after all the source data are properly loaded when a Function series is added beforehand?
Symptom: When a user opens the Editing dialog box after loading all the data to the Source series by using Add function, she can see the Function Series is stored but it is not updated according to the source data. The Function Series is refreshed only after a user changes the values of ‘Number of points’ in Data Source and clicks on the Apply button.
We believe there must be an API function that redraws all the Function series but haven’t found it yet. Is there?
Regard,
We are using TeeChart ActiveX v7.0.1.0 for our product, Report Designer.
We have encountered below three problems when using Exp.Moving Average Function Series with NULL values. We are posting this matter on the forum since we haven’t received any response form you although we already sent a Pro Priority Question email on 11th of Oct.
1. It appears null values are treated as if they have numeric values of 0 by Exp.Moving Average Function Series. We’d like to know whether a Function Series can be represented without being aversely affected by null data.
Symptom: When S0 Line Series represents the Source data whereas MA5 shows Exp.Moving Average Function Series, the MA5 Series graph drops dramatically when it deals with null data.
We know null values are received as null but represented as if they are 0 with invisible RGB value (assuming white).
FYI. The setting is as follows; Calculate using: Every number of points / Number of points:5 / Alignment: Center
2. Is it possible to have Min/Max scale of Left Axis without reflecting null values but effective values?
In fact, the minimum value of S0 Series should be set at about 350 instead of 0.
We assume that this is caused by assumed 0 numeric values when the values are, in fact, null.
3. Is there any readily available API function that refreshes the Function series after all the source data are properly loaded when a Function series is added beforehand?
Symptom: When a user opens the Editing dialog box after loading all the data to the Source series by using Add function, she can see the Function Series is stored but it is not updated according to the source data. The Function Series is refreshed only after a user changes the values of ‘Number of points’ in Data Source and clicks on the Apply button.
We believe there must be an API function that redraws all the Function series but haven’t found it yet. Is there?
Regard,
