How do you handle missing data for Date axis?

01-18-2005, 5:28 PM
I want to create a chart that looks like this:

4                X    X    X
3
2       X
1  X
  May1 May2     May4 May5 May6

Notice how the value for May3 is missing and the chart has provided space between May2 and May4.

I would also like to draw a line between the points in chronological order.

Re: How do you handle missing data for Date axis?

01-19-2005, 5:11 AM
Hello,
I attached sample that shows how to create similar chart.
The type of Chart is "Line", there is some additional code that creates DataSource and sets properties of Chart points.

Hope this helps.
Sergey Abakumoff
GrapeCity

Re: How do you handle missing data for Date axis?

01-19-2005, 8:55 AM
The user did not collect data on May 3rd so you must not provide a data point for may 3. Comment out these lines.

'dr = dt.NewRow'dr.Item(0) = New DateTime(today.Year, today.Month, today.Day + 2).ToShortDateString
'dr.Item(1) = DBNull.Value
'dt.Rows.Add(dr)

Also the data is collected at different times of day. Multiple readings maybe be taken on the same day. This is a medical chart that displays patient vital signs. The feature I am looking for automaticaly builds the X axis ticks using only the min and max dates within the data. The other points within the data are plotted against this X-axis. The variable X-axis space between points is important. 2 points collected within the same hour shoudl be close together. 2 points collected days apart should have a huge X-axis gap between them.

Re: How do you handle missing data for Date axis?

01-19-2005, 9:20 AM

Maybe this example is easier:

5
4
3                          X             XX
2      X
1    X
   May1 May2 May3 May4 May5 May6

Re: How do you handle missing data for Date axis?

01-19-2005, 10:43 AM
There may be a way in code to get this accomplished, but I don't think it will be a very convenient solution.  I went ahead and entered a feature suggestion CR for this for our developers, the CR# on that is 15763.

Sergey, if you are able to write up some code that may help then feel free.  I'd just also like to see if there is something that can be added to our control to get this accomplished automatically without having to write the extra code all the time.

Re: How do you handle missing data for Date axis?

01-19-2005, 1:13 PM

Take a look at another sample I created for you. I added comments to the code, hope this helps.

Sergey Abakumoff
GrapeCity

Re: How do you handle missing data for Date axis?

03-01-2006, 3:15 PM
What is the status of this feature request (CR#  15763)?  It has been over a year since the request - is this functionality available yet?

Re: How do you handle missing data for Date axis?

04-04-2006, 10:05 AM

I am very interested in this functionality as well - any news?

Eyvind.

Re: How do you handle missing data for Date axis?

02-15-2008, 11:55 AM
Can you let us know if/when you plan on implementing a true date axis? This issue was first brought to your attention over three years ago in this post and again over two years ago in a different post (http://www.datadynamics.com/forums/111084/ShowPost.aspx). In both cases you created CR numbers (CR# 15763 and CR# 19013). There have been several customers requesting this feature.

Your product page (http://www.datadynamics.com/Products/ProductFeatures.aspx?Product=SGRAPH&Topic=Graph%20Types) claims that both the Bezier and Line graphs will "compare trends over a period of time ". I would suggest that this is a false claim because the graph does not currently display the data over a period of time.

We cannot use the graph to do "trends over a period of time" until it correctly interprets date/time values and displays the data correctly.

I am not trying to be critical, I think your products are great and continually improving, but this is a crucial feature that appears to have been ignored.

Re: How do you handle missing data for Date axis?

02-15-2008, 1:29 PM
Thank you for your feedback. I have expressed your concerns to our project management team regarding case 26217 and ensured your email address has been linked to the case as an interested user. Currently the case is still open in our system and if you would like to be notified of future releases which may contain this feature, you can subscribe to our announcements forums here:

http://www.datadynamics.com/forums/65/ShowForum.aspx

Thanks,
    Eric

Re: How do you handle missing data for Date axis?

07-23-2008, 8:30 PM

Hello:

I would just like to add my voice to the chorus asking for this feature ASAP.  This is crucial for properly charting time-series data.  In the meantime, could a developer post some code that allows this to be done, even if it is a hack? For example, would it be possible for the user to convert the DateTime to an integer of seconds in order to set up the scale or MajorTick.Step, but then display the DateTime properly on the graph?  I am reaching for straws here.....

The problem of the missing data gap that was addressed is, in my opinion, not nearly as crucial as the ability for the X-Axis to be properly scaled based on time-whether this is through SmartLabels, or through allowing the scale to be controlled by the user, this really makes the graphing practically worthless when it comes to time series.  I am not trying to dramatize it, but honestly at this point we may have to switch vendors if I can't get this to work.

Thanks

tpenniman

 

 

 

Re: How do you handle missing data for Date axis?

07-25-2008, 1:11 PM
Infragistics chart control, can be embedded into an active report

Re: How do you handle missing data for Date axis?

04-08-2010, 5:53 PM
Has this been fixed in ActiveReports 6?

Re: How do you handle missing data for Date axis?

05-07-2012, 3:26 AM
any update?
________________
Visit Website