Thanks for your reply. I tried the general options but that didn't help. The requirement is to display the TIME from decimal number to minutes:seconds.fractions for example if the value is 740.59 Second, it should be displayed as 12:20.59 Seconds. 740.59 -> 12:20.59 Using numberFormat won't address this use case. I was able to address this use case using LineChart, but interested to use Annotated Time Series. Any ideas?
On Feb 8, 4:00 am, Viz Kid <[email protected]> wrote: > 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%252bunsubscri�[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.- 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]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
