Is it possible to use the AnnotatedTimeLine interactive chart to display seconds?
I have data that I am wanting to plot that shows up and down time for a piece of equipment that I have been monitoring. I have my web page embedded in an html object in my c++ program atm and I am currently reading from a dataset in my c++ app that is accessing a SQL Server database for the information. I am then storing that information into arrays in my javascript and then creating the google data table. I could find any documentation on exactly how to set up a query and connection to an sql server, so I am currently forced to do is this way instead of doing a much quicker dip into the sql database. I guess my method I am using now is more secure so I guess I can live with it. However, I am running into a bit of a problem. A lot of my values have the same minutes and differ by seconds. I was trying to plot these changes so I didn't have any diagnols connecting the other values; however, it seems to be getting mixed up in the process of plotting my information for values with the same minutes. I read the documentation and it appears it only supports dates in the format of HH:mm MMMM dd, yyyy And I was unable to get the chart to generate information with any date not specified exactly like it is said there. My question is, is there any way to get it to the accuracy of these seconds so I can plot these points accordingly? Or how can I get rid of the diaganols between points? What I have is this: Dates in the format of 6/22/2010 11:11:11 AM Status which is either a 0 or 1 Basically I am reading the information from the c++ in the GetMapChartData function. I am storing it into arrays for an Intersection. Basically I have an array to keep track of my Intersections, one to keep track of how many rows of information each intersection has, and arrays for my dates and status values. This will eventually let me read multiple intersecions at once if I need to and tells me how much information each intersection has. Then I call my drawVisualization function to cycle through the arrays and create the google DataTable. It was the date field that was giving me issues as it didn't like any other format for datetime than what I described above. A link to the chart page is: http://www.suntransformer.com/peter/GoogleAPI3/test/charts2.html Although it doesn't have access to the datasource for the reasons I stated above. So if anyone has any suggestions as how to get it to read the seconds and any suggestions for the SQL query any suggestions or information would be greatly appreciated. Thanks -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
