I found the problem. I was passing the date with a month base of 1 and it was supposed to be a month base of zero (January=0, not 1). I'm not sure how that would change anything, but once I fixed it, everything was correct.
Mike On Wednesday, April 1, 2015 at 9:19:52 AM UTC-4, Mike Dorfman wrote: > > Hi Daniel, > > Thank you for the suggestion! Unfortunately, that didn't change anything. > > Mike > > On Wednesday, April 1, 2015 at 8:56:39 AM UTC-4, Daniel LaLiberte wrote: >> >> Mike, >> >> I suspect, but I'm not 100% sure, that your "Date(...)" formatted dates >> are the problem because you 0s preceding many of the values, which when >> parsed as numbers, indicates they should be interpreted as octal values >> rather than decimal. So see what happens if you remove those leading 0s. >> >> On Wed, Apr 1, 2015 at 8:46 AM, Mike Dorfman <[email protected] >> > wrote: >> >>> Just as a heads up, I got the information on how to pass dates through >>> JSON here: >>> https://developers.google.com/chart/interactive/docs/dev/implementing_data_source?hl=pt-BR#jsondatatable >>> >>> under "JSON Modifications". >>> >>> Thanks, >>> Mike >>> >>> >>> On Wednesday, April 1, 2015 at 8:37:14 AM UTC-4, Mike Dorfman wrote: >>>> >>>> Hello, >>>> >>>> I've tried to figure this out on my own, and was wondering if anyone >>>> could shed any light on the bug that I'm seeing in my page. Last night >>>> when the month changed, something odd happened to all the continuous >>>> graphs >>>> on my page and I have a feeling it has to do with the date I'm passing to >>>> the graph. I'm passing 24 hours of temperature data via JSON and >>>> declaring >>>> a column of type "datetime" like so: >>>> >>>> "temperatureHistory": [ >>>> >>>> [ >>>> { >>>> "id": "Day", >>>> "type": "datetime" >>>> }, >>>> "T", >>>> { >>>> "role": "tooltip" >>>> }, >>>> "DP", >>>> { >>>> "role": "tooltip" >>>> }, >>>> "WC", >>>> { >>>> "role": "tooltip" >>>> } >>>> ], >>>> >>>> [ >>>> "Date(2015, 03, 31, 22, 00, 00)", >>>> 3.1, >>>> "22:00 Temperature: 3.1°F", >>>> -19.7, >>>> "22:00 Dew Point: -19.7°F", >>>> -23.6, >>>> "22:00 Wind Chill: -23.6°F" >>>> ], >>>> [ >>>> "Date(2015, 03, 31, 23, 00, 00)", >>>> 2.7, >>>> "23:00 Temperature: 2.7°F", >>>> -18, >>>> "23:00 Dew Point: -18°F", >>>> -24.3, >>>> "23:00 Wind Chill: -24.3°F" >>>> ], >>>> [ >>>> "Date(2015, 04, 01, 00, 00, 00)", >>>> 3.1, >>>> "00:00 Temperature: 3.1°F", >>>> -14.1, >>>> "00:00 Dew Point: -14.1°F", >>>> -23.6, >>>> "00:00 Wind Chill: -23.6°F" >>>> ], >>>> [ >>>> "Date(2015, 04, 01, 01, 00, 00)", >>>> 4, >>>> "01:00 Temperature: 4°F", >>>> -6.9, >>>> "01:00 Dew Point: -6.9°F", >>>> -22.3, >>>> "01:00 Wind Chill: -22.3°F" >>>> ], >>>> [ >>>> "Date(2015, 04, 01, 02, 00, 00)", >>>> 4.4, >>>> "02:00 Temperature: 4.4°F", >>>> -5.3, >>>> "02:00 Dew Point: -5.3°F", >>>> -21.9, >>>> "02:00 Wind Chill: -21.9°F" >>>> ], >>>> >>>> ... >>>> >>>> For some reason, my graph is not displaying properly. Since the data >>>> is 24 hours from start to end, I've had issues in the past with using a >>>> "time" instead of a "datetime" label for the x-axis, and this issue seems >>>> to be related. It seems like google visualization is ignoring the >>>> 'month' part of the date and only interpreting the hours part of the >>>> date. The data is currently displaying in such a way that everything >>>> before midnight is graphed immediately after midnight. See below to see >>>> what the graph looks like. The blue arrow represents that where that data >>>> should be located: >>>> >>>> >>>> <https://lh3.googleusercontent.com/-pDVSueyD5mA/VRvkI1IN0JI/AAAAAAAAABE/4qMud2Lx3Zw/s1600/Capture.PNG> >>>> You can find the graphs here: http://xmountwashington. >>>> appspot.com/csc.html >>>> and the data is located here: http://xmountwashington. >>>> appspot.com/csc.php?size=small >>>> >>>> Please note that that server has a viewWindow that cuts data off data ( >>>> eg the right axis is located) at the current time. The graph above is >>>> what >>>> is seen if I get rid of this viewWindow. >>>> >>>> Any thoughts on this? Have there been issues in the past with passing >>>> date() data over JSON that spans more than one month? Is this date() data >>>> being passed to the graphs correctly? >>>> >>> -- >>> 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. >>> >> >> >> >> -- >> Daniel LaLiberte <https://plus.google.com/100631381223468223275?prsrc=2> >> - 978-394-1058 >> [email protected] 5CC, Cambridge MA >> [email protected] 9 Juniper Ridge Road, Acton MA >> > -- 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.
