• Forums
• Home

Search Rate this topic:   Comments (optional) Sort Posts:  Oldest to newest Newest to oldest

01-18-2005, 5:28 PM Bart McEndree Joined on 12-11-2004 Posts 10 How do you handle missing data for Date axis? 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.    Report

01-19-2005, 5:11 AM Sergey Joined on 08-28-2004 Novosibirsk, Russia Posts 3,015 Re: How do you handle missing data for Date axis? Attachment: LineGraph.zip 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    Report

01-19-2005, 8:55 AM Bart McEndree Joined on 12-11-2004 Posts 10 Re: How do you handle missing data for Date axis? 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.    Report

01-19-2005, 9:20 AM Bart McEndree Joined on 12-11-2004 Posts 10 Re: How do you handle missing data for Date axis? Maybe this example is easier: 5 4 3                          X             XX 2      X 1    X    May1 May2 May3 May4 May5 May6    Report

01-19-2005, 10:43 AM mccune Joined on 08-28-2004 Columbus, Ohio Posts 29 Re: How do you handle missing data for Date axis? 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.    Report

01-19-2005, 1:13 PM Sergey Joined on 08-28-2004 Novosibirsk, Russia Posts 3,015 Re: How do you handle missing data for Date axis? Attachment: LineGraph.zip Take a look at another sample I created for you. I added comments to the code, hope this helps. Sergey Abakumoff GrapeCity    Report

03-01-2006, 3:15 PM mweaver Joined on 08-28-2004 Posts 42 Re: How do you handle missing data for Date axis? What is the status of this feature request (CR#  15763)?  It has been over a year since the request - is this functionality available yet?    Report

04-04-2006, 10:05 AM eyvindwa Joined on 01-17-2006 Posts 5 Re: How do you handle missing data for Date axis? I am very interested in this functionality as well - any news? Eyvind.    Report

02-15-2008, 11:55 AM mweaver Joined on 08-28-2004 Posts 42 Re: How do you handle missing data for Date axis? 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.    Report

02-15-2008, 1:29 PM ericc Joined on 03-01-2005 Posts 1,857 Re: How do you handle missing data for Date axis? 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    Report

07-23-2008, 8:30 PM tpenniman Joined on 07-24-2008 Posts 5 Re: How do you handle missing data for Date axis? 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          Report

07-25-2008, 1:11 PM tpenniman Joined on 07-24-2008 Posts 5 Re: How do you handle missing data for Date axis? Attachment: infra.JPG Infragistics chart control, can be embedded into an active report    Report

04-08-2010, 5:53 PM mweaver Joined on 08-28-2004 Posts 42 Re: How do you handle missing data for Date axis? Has this been fixed in ActiveReports 6?    Report

GrapeCity » Product Support » SharpGraph for ... » How do you handle missing data for Date axis?

(please select) Forums Home |- Search Forums |- Active Topics |- Unanswered Posts User Options |- Sign In |- Join this community |- Forgot Password Announcements |- ActiveBar Announcements |- ActiveReports Announcements |- ActiveReports for .NET Announcements |- ActiveSizer Announcements |- Data Dynamics WebSite Announcements |- DynamiCube Announcements |- SharpGraph for .NET Announcements |- SharpGrid Announcements |- SharpUI for .NET Announcements |- Data Dynamics Reports Announcements |- GrapeCity ActiveAnalysis Announcements Frequently Asked Questions |- ActiveReports 2.0 FAQ |- ActiveSizer FAQ |- DynamiCube FAQ |- SharpGrid FAQ |- ActiveReports for .NET FAQ |- ActiveBar FAQ |- SharpUI for .NET FAQ Product Support |- ActiveBar Support |- Data Dynamics Analysis Support |- ActiveReports 6 Support |- GrapeCity ActiveAnalysis Support |- ActiveReports for .NET 3.0 Support |- ActiveReports for .NET 2.0 Support |- ActiveReports for .NET Support |- ActiveReports 2.0 (Visual Basic 6.0) Support |- ActiveSizer Support |- DynamiCube Support |- SharpGraph for .NET Support |- SharpGrid Support |- SharpUI for .NET Support |- Data Dynamics Reports Support Knowledge Base |- KnowledgeBase for SharpUI for .NET |- KnowledgeBase for ActiveCube |- KnowledgeBase for ActiveReports |- KnowledgeBase for ActiveBar |- KnowledgeBase for ActiveReports for .NET |- KnowledgeBase for SharpGrid |- KnowledgeBase for ActiveSizer |- KnowledgeBase for DynamiCube |- KnowledgeBase for SharpGraph for .NET |- KnowledgeBase for Data Dynamics Reports Forum Archives |- ActiveReports for .NET 2.0 Visual Studio .NET 2005 Support |- ActiveBar 3.0 Beta Support |- support.activebar2.general |- support.activereports.general |- support.activereports.net |- support.activereports2.stdedition |- support.activereports2.proedition |- support.activesizer.general |- support.announcements |- support.dcube.c++ |- support.dcube.delphi |- support.dcube.ie |- support.dcube.misc |- support.dcube.vb |- support.dcube.vfp |- support.sharpgrid.general Product Downloads |- ActiveSizer Downloads |- SharpUI for .NET Downloads |- ActiveReports for .NET Downloads |- ActiveCube Downloads |- ActiveReports Downloads |- ActiveBar Downloads |- SharpGrid Downloads |- ActiveReports for .NET 2.0 Downloads |- SharpGraph for .NET Downloads |- DynamiCube Downloads |- ActiveReports for .NET 3.0 Downloads |- ActiveReports 6 Downloads |- Data Dynamics Reports Downloads Web Site Feedback |- Web Site Feedback Employment Opportunities |- Employment Opportunities