This is the right group. As I mentioned before, the Annotated time line chart *ignores* the formatted value of the DataTable. Therefore, the formatting that you apply here is simply ignored. The solution to your problem is to pass formatting options to the chart itself (rather than to the DataTable).
You can either set the option 'allValuesSuffix' which simply add a suffix to all the number values in the chart or to use 'numberFormats' to choose the exact format for each of the series independently. Notice however that both these options has no direct set method and you would need to use the general setOptions(optionName, optionValue) of the AnnotatedTimeLine.Options class. Viz Kid On Sun, Feb 7, 2010 at 5:16 AM, Budband <[email protected]> wrote: > Is this the right group for posting GWT Visualization (Integrated) > related Questions. > > On Feb 4, 11:11 pm, Budband <[email protected]> wrote: > > I still have problem with NumberFormat in Annotated time line. Here > > is the code in GWT that is ignored by the api: > > > > com.google.gwt.visualization.client.formatters.NumberFormat.Options > > nOptions = > > > com.google.gwt.visualization.client.formatters.NumberFormat.Options.create(); > > nOptions.setPrefix("$"); > > > > NumberFormat formatter = NumberFormat.create(nOptions); > > DataTable data = getCompanyPerformance(); > > formatter.format(data, 1); > > formatter.format(data, 2); > > > > Options options = Options.create(); > > AnnotatedTimeLine viz = new AnnotatedTimeLine(data, options,"700px", > > "240px"); > > > > I know that the API is working on JS, but maybe not on GWT wrapper of > > JS. Any idea? > > > > On Jan 4, 4:28 am, Viz Kid <[email protected]> wrote: > > > > > > > > > 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 (seehttp:// > code.google.com/apis/visualization/documentation/gallery/annot... > > > 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]> > <google-visualization-api%[email protected]<api%[email protected]> > > > > > > . > > > > For more options, visit this group at > > > >http://groups.google.com/group/google-visualization-api?hl=en.- 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.
