On Tue, Jun 22, 2010 at 7:16 PM, nlraley <[email protected]> wrote:
> Is it possible to use the AnnotatedTimeLine interactive chart to > display seconds? > Yes, using the dateFormat option. > > 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. > We have a Java library that can provide a GViz data source from an SQL database. See http://code.google.com/apis/visualization/documentation/dev/dsl_about.html If you're using C++, it's up to you to read from the database and convert to a GViz data table. > 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 > I think you got the possible values confused with the default values :) You can make it "HH:mm:ss 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]<google-visualization-api%[email protected]> > . > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- 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.
