Hi. Annotated time line currently ignores the formatted values of the data table as it has a parameter for formatting the numbers of each series named numberFormats (see http://code.google.com/apis/visualization/documentation/gallery/annotatedtimeline.html#Configuration_Optionsfor more details).
The API indeed separates the displayed values from the actual values by allowing the user to specify the formatted value for each cell. The predefined formatters cannot cover all possible formatting formats that users would need. A simple solution would be to implement your own formatter which simply goes over the column of numbers and set their formatted value to be of the format you prefer. Hope this helps, Viz Kid On Fri, Jan 1, 2010 at 11:15 PM, Budband <[email protected]> wrote: > I think the api should provide an option to separate the display value > from the actual value, or at least it should be easy to do so by > hacking the javascript code, something that I am not interested in :) > > I am leaning towards a solution to provide a field to DataTable as > 'DisplayValue' or applying a formula to NumberFormat, so It can be > dynamic representation of the Actual Value. > > > > On Jan 1, 8:12 am, c2billp <[email protected]> wrote: > > This is an issue that I'm struggling with as well. If you choose data > > type "timeofday" then sorting and display in datatables works ok but > > you can not chart values of that datatype > > > > my solution has been to add a col to the datatable that holds the > > second value and use that for charting while the timeofday col I use > > for display. > > > > I think (but have not tested yet) that another solution would be to > > produce the following (from server side) > > > > data.setCell(0,3,88.22,'1:22:34'',{'style': 'border: 3px solid > > deeppink) > > > > This will I hope result is the user seeing the 1:22:34 value in > > tooltip and yet having the chart plot the numerical value 88.22 > > > > bill > > On Jan 1, 4:45 am, Budband <[email protected]> wrote: > > > > > > > > > Is it possible to format the number(which is a time) from decimal to > > > minute:seconds.milliseconds and display it on the Chart ? > > > For example if the number is 88.22 seconds (1 min and 22.22 seconds) > > > the number should be displayed as 1:22.22 in the chart (tooltip). > > > > > I was almost able to do that in the LineChart using the following: > > > > > com.google.gwt.visualization.client.formatters.NumberFormat.Options > > > nOptions = > > > > com.google.gwt.visualization.client.formatters.NumberFormat.Options.create > > > (); > > > nOptions.setFractionDigits(2); > > > nOptions.setDecimalSymbol(":"); > > > nOptions.setPrefix("New Formatted Time is -> "); > > > nOptions.setSuffix(".22"); > > > NumberFormat formatter = NumberFormat.create(nOptions); > > > > > // Drop the decimal part from the number when populating the DataTable > > > DataTable data = getCompanyPerformance(); > > > formatter.format(data, 1); > > > > > Well, there are 2 problems with this approach. > > > 1 - The Suffix can not be dynamic, i.e. couldn't find a way to pass a > > > parameter to the setSuffix method, neither was able to apply the > > > formatter with different Suffix to each number. > > > 2 - The NumberFormat won't work on the datatable used for > > > AnnotatedTimeLine !! > > > > > I also checked the PatternFormat with no success. > > > > > Thanks for your help.- Hide quoted text - > > > > - Show quoted text - > > -- > > 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.
