Here's a basic example: http://jsfiddle.net/2h7xhbcL/
Hopefully you'll be able to derive your specific solution from it. Good luck! On Thu, Apr 2, 2015 at 2:07 PM mariummalik22 <[email protected]> wrote: > If you could show the alternate option I would be very thankful. I am just > stuck with this thing from last 2 days. I can plot integers, float values > but not able to plot time at all. Don't know the reason, have tried all the > data types as well. > > > On Thursday, April 2, 2015 at 11:00:46 PM UTC+5, Sergey wrote: > >> You would need to execute that line for every item. Ideally, you would >> modify your getpiechartdata2.php file to do this on the server, but I don't >> really know the PHP syntax for the equivalent of that, so I'm afraid you're >> on your own there. Alternatively, you could use a DataView calc column to >> do this, and if you'd like to create an example jsfiddle with some data, I >> could even show you how. >> >> On Thu, Apr 2, 2015 at 1:48 PM mariummalik22 <[email protected]> wrote: >> >>> Thanks for the response. Where should this line be inserted? Where I am >>> defining my columns or somewhere else? >>> >>> >>> On Thursday, April 2, 2015 at 10:39:08 PM UTC+5, Sergey wrote: >>> >>>> It's a little difficult to give you advice without being able to run >>>> the code, but it sounds like you want to use the 'timeofday' type. I think >>>> you could do this trivially by doing a transform of your data, where for >>>> each string, you would do something like >>>> stringTimeRepresenation.split(':').map(function(s) >>>> { return parseInt(s.trim()); }) >>>> >>>> On Thu, Apr 2, 2015 at 1:33 PM mariummalik22 <[email protected]> >>>> wrote: >>>> >>> I am retrieving data from sql database. I have time field there where >>>>> time is in the format hh:mm:ss. I have used data type datetime, date, but >>>>> I >>>>> am not able to plot the graph. Can someone help me how to do so? I have >>>>> attached my both php files. >>>>> >>>>> -- >>>>> You received this message because you are subscribed to the Google >>>>> Groups "Google Visualization API" group. >>>>> To unsubscribe from this group and stop receiving emails from it, send >>>>> an email to [email protected]. >>>>> >>>> To post to this group, send email to [email protected]. >>>> >>>> >>>>> Visit this group at http://groups.google.com/group >>>>> /google-visualization-api. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> -- >>> You received this message because you are subscribed to the Google >>> Groups "Google Visualization API" group. >>> To unsubscribe from this group and stop receiving emails from it, send >>> an email to [email protected]. >>> To post to this group, send email to [email protected]. >>> Visit this group at http://groups.google.com/ >>> group/google-visualization-api. >>> For more options, visit https://groups.google.com/d/optout. >>> >> -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To unsubscribe from this group and stop receiving emails from it, send an > email to [email protected]. > To post to this group, send email to > [email protected]. > Visit this group at > http://groups.google.com/group/google-visualization-api. > For more options, visit https://groups.google.com/d/optout. > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
