Any example of Time Vs. Time in Annotated Time Series with the time format for Y Axis?
On Feb 17, 12:43 pm, Budband <[email protected]> wrote: > I want to know when if anytime, this feature will be supported in > Annotated time series. > Any ideas? > > On Feb 16, 12:50 pm,Budband<[email protected]> wrote: > > > 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.-Hidequoted > > > > text - > > > > - Show quoted text -- 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.
