Hi, I am having some trouble with setting the time variable to a weekly format in Motion Charts. I have a dataset in the following format:
idvariable timevariable xvariable yvariable Mouse 2014W01 1 0 Mouse 2014W02 2 5 Mouse 2014W03 3 8 The entries "2014W01", "2014W02", are of mode "character". The relevant excerpt from the manual pages is copied below. However I receive the following error when running the MotionChart: "The timevar has to be of numeric or Date format. Currently it is factor". After extensive googling I am still unable to find an example of a Motion Chart which has its time expressed in either weekly or quarterly format. Can anyone give me the commands needed to format the timevariable column into a correct weekly format? Thanks, Oliver Stevenson >From the manual: https://developers.google.com/chart/interactive/docs/gallery/motionchart * The second column must contain time values. Time can be expressed in* * any of the following formats:* - Year - Column type: 'number'. Example: 2008. - Month, day and year - Column type: 'date'; values should be javascript Date instances. - Week number - Column type: 'string'; values should use the pattern YYYYWww, which conforms to ISO 8601 <http://en.wikipedia.org/wiki/ISO_8601>. Example: '2008W03'. - Quarter - Column type: 'string'; the values should have the pattern YYYYQq, which conforms to ISO 8601 <http://en.wikipedia.org/wiki/ISO_8601>. Example: '2008Q3' -- 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.
