I tried your idea, and it didn't work. Same problem as without it.
I also don't understand why it works when the chart is first drawn, but not
after the chart is updated. It seems as if the only way to make progress
here is to just destroy the chart and redraw it each time, which isn't
desira
Is it possible to use a NumberFormatter and BarFormatter at the same time
on a table whose underlying DataTable will be updated?
I am able to render a Table with both a numberformatter and barformatter
applied to the same column. That looks fine.
But when I change the values, the last forma
You can create a sample by creating a Table with 4 columns in it, and then
apply a BarFormatter to the last 3 columns. It will give you the chart
that you're looking for.
If you have problems or difficulties, post your code and I'll take a look.
--
You received this message because you are
You could do something very similar using a Table with a BarFormatter. The
BarFormatter is one of the nicer features of the Google Table charts; I use
it frequently to produce charts similar to what you posted here.
hope that helps,
-- N
On Tuesday, May 1, 2012 3:59:23 PM UTC-4, Sshe
Nice - where did you learn about the pagingSymbols field? I had no idea
that existed, and I can't find it on the doc. Very handy.
>>>
table.draw(data, {
width: 400,
showRowNumber: true,
page: 'enable',
pageSize: pageSize,
pagingSymbols: {
If you do change that, please make sure to let us know ahead of time. I
have some code that relies on the elements in the table being marked-up as
they currently are; changing them to different elements will break that
code and I'll need to make changes to accommodate that. This may also
aff
I have a slightly different question:
Why hasn't the GVIZ team add versioning consistent with what's in other
products?
Please don't reply saying "we will consider it". That's not what I'm
asking for. I am specifically asking why you haven't added it yet despite
requests to do so for a
Ah, now I'm seeing the button. I'm not in +1 either, so public gratitude
from me isn't possible. :(
I don't know why I missed it before. I'm still getting used to the new
interface. There's so much white space that my eyes just wander around the
screen and never seem to notice anything.
Viewing this page:
http://www.liiter.ee/beta/uus/index_beta.html
Running IE8 Standards mode, I get this error:
Line: 53
Error: Every row given must be either null or an array.
Is the problem that you have a comma after the last element in your addRows
statement?
It worked fine for me i
I'm surprised the Google Groups interface doesn't give the option of giving
a +1 to a good answer here, or give posters "karma points" for their nice
replies. Asgallant has tons of good ones, and it'd be nice to not just say
"thanks" but to also give him a +1 for a helpful answer.
That's also
Thanks for diting the example.
Interesting you mentioned creating the DataTable object before the script
finishes. That's actually how the Google Visualization Playground is
written - if you visit
http://code.google.com/apis/ajax/playground/?type=visualization#sort_event
and click "Edit HTML
That's an interesting idea. I have a workaround (below), but I'll probably
try that the next time I do something like this.
I ended up redrawing each sparkline separately in its own setTimeout
function that fires at some random interval (interval length depends on how
many charts I have, so I
If I remember correctly, the indices used in the Pattern (the ones inside
the { }) are not indices into the datatable. They are indices into the
array passed to the formatter. So they will always start with 0. The data
can be in any column, you specify that in the call to format().
hope that
Ok, based on what I've seen, that sounds right.
I could put the jQuery code inside each the datatable cell, so that each
cell contains its own jQuery code that renders only its own contents. I'm
pretty sure that would work, but I don't think it would be any more
efficient than the workaround
I have a table that has a column of type 'string'. That column has a span
element that is used to construct a jQuery sparkline. It's contents look
something like:
When the chart is first rendered, the sparklines render as well. But when
I sort the table (on any of the columns), the spar
Hi,
I'd like to disable sorting for some columns in my Table. It doesn't look
like this is directly possible, but instead one needs to set sort='event'
and then handle the sort event.
Since I want to use the default sorting behavior for all my columns except
for one, I am hoping I can just le
How about chaning this:
> data = addRow( data );
>
to just
addRow(data);
That way it's clear you're trying to do a by-reference call. Next, I'd
change:
> function addRow( var data ) {
>
to just
function addRow(data) {
And then I'd remove t
There have been other discussion on this. I actually am in favor of
allowing the user to specify their own aggregation function for determining
the color, instead of using the default "average" aggregation function.
See this discussion:
https://groups.google.com/d/topic/google-visualizatio
Hi Davide,
I'm sorry, but I'm not able to look through so much code to figure out
what the problem is. Can you perhaps come up with a smaller version
that reproduces the problem?
Also, if you run a debugger like Firebug, what does it say? Sometimes
you won't see anything because an error occurr
I've been using the "new Date" method, though I haven't tried any
other approach. It would be nice if the approach you're using worked.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visu
asgallant - I also don't see an "Attach a file" link either. Are you
posting to the list from the Groups web page, or from within another
app?
Davide, can you post your code snippet to jsfiddle instead? We might
be able to see it there.
--
You received this message because you are subscribed t
Nah, it's not hard at all. As you make a change, put it in a list.
That's a good start, and isn't difficult. A product manager or
interested individual can review the list to make it more customer
friendly, though that's not really necessary if you don't have the
resources. Then you post the li
Can you post a changelog so we know what to look for?
Without a changelog, it becomes very difficult to verify that the RC
is good unless the application built with it is relatively trivial.
Verifying that the RC works with more complex applications requires
that we have some idea what to look for
Everyone knows that to in roulette, you just bet your wife's
birthday. You're guaranteed to do well, even if you don't win the
roulette spin ;)
Incidentally, canoes were added to make prediction even more
difficult. "The Eudaemonic Pie" tells some of the roulette team's
story. The team members
Hi,
I'm trying to add a tooltip to my tables. I create my DataTable, and
then I do something like:
data.setProperty(0,1,'title','tooltip here');
The Table is drawn with allowHtml:true. When the table renders, the
tooltip isn't visible and looking at the element for row 0, col 1
shows that the
Awesome - that makes sense. I had the feeling I was missing something
like that.
thanks for spotting this. And yes, you get bonus points, even though
no jQuery. ;)
It's too bad the Google Groups doesn't have a point/karma system, like
on stackoverflow. Or even something less sophisticated. It
Hi,
I have code that updates a DataTable. There is a view with a
calculated column on this datatable. But the calculated column
doesn't update when the DataTable is updated.
Here's how to reproduce:
* Go here:
http://code.google.com/apis/ajax/playground/?type=visualization#simple_data_view
I was excited about this and had a chance to test it late last night.
It looks like it has been fixed! I'm going to run more tests on my
production apps, but so far looks good. This will save a lot of extra
function calls to convert the dates appropriately.
Can you elaborate on why a cross-site
Which API are you using? I don't recognize the addCell calls, or the
way you're declaring the variable types.
In any case, I'm going to assume that you will probably need to create
different TableRow objects, since if you don't, you'll just be adding
the same instance of one TableRow object to yo
I'll give it a shot. I can't test it easily right now, which is why I
was asking on the forum before trying. I think I'll be able to try it
out this weekend; will let you know if it works.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" g
Would using removeRow() work for you?
If you want to remove the row and replace it with a row containing
default values, then create a default row and insert it using
insertRows().
Does that solve the problem you're running into?
--
You received this message because you are subscribed to the Go
You're right about the tables, and probably the org charts (I don't
use them). In fact, the tables have a really nice approach that lets
you assign classes so that you can style them to match your other
tables.
But the text fields in the other visualization elements seem to be
affected by CSS. F
Hi,
I've learned a lot on this group, especially from asgallant, about how
you can control presentation by manipulating the CSS styles associated
with the various visualization elements.
Is there a chance we could add CSS elements and classes to the GVIZ
API ?
I know some of the visualization el
Asgallant, I have to ask - are you running those different versions of
IE on the same machine, or different ones? If the same, are you using
any special tricks/apps to make them play well together?
When I last tried to run different versions of IE, I had a lot of
trouble. If you know any tricks
Hi ChartMan,
Were you able to find more about this, perhaps even a workaround until
a fix is ready? I really like the look of charts with the bar
formatter, and want to apply it to my charts that update in real time.
thanks,
--
You received this message because you are subscribed to the Google
rhead
anytime dates are used).
This can also make the library look buggy to new users who run into it
and aren't able to identify the problem.
On Jan 25, 1:31 am, NA wrote:
> Was the datetime issue in the thread below corrected?
>
> http://groups.google.com/group/googl
Was the datetime issue in the thread below corrected?
http://groups.google.com/group/google-visualization-api/browse_thread/thread/a14e7248e8f7e3ae/aac7ef36144672ab
I'd love to remove the path that I'm using to fix this...
--
You received this message because you are subscribed to the Google
Impressive effort to get to the _bar_format_old property! This is a
nice workaround, but I don't think it's going to generalize to the
cases that I have (each of my tables can be updated by more than one
method, and the formatters for a column won't/shouldn't be known by
those methods). I am star
Thanks very much for creating an example :) I was meaning to do that
to perhaps get more responses.
I've modified your example so that it shows the odd behavior.
Take a look at:
http://jsfiddle.net/LvZRa/2/
In this example, after clicking on the button, the sorting looks
correct but the valu
Anyone from the GVIZ team to comment on this?
I'd love to use the formatters with this table as it updates, but this
is preventing me from doing so.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email t
In fact, even clearing the formatters for every entry in the column
with "setFormattedValue(i,1,null);" before re-applying them at each
draw() still doesn't work, same behavior as before.
Any GVIZ team have any ideas what I need to do, and if this behavior
is somehow desirable?
--
You received t
No, that doesn't work. 2 things go wrong in that case:
- Bars appear for all entries, but their sizes aren't correct. It
looks like entries whose value wasn't changed kept their old bar
size. This isn't the correct behavior; they need to be resized to
take into account other values in their col
Wow! I have a report with many tables and three gauges that update
dynamically. With the new release, the page runs *much* more smoothly
than before. It's a huge difference.
I assume this is because of the memory leak fixes, but I'm not sure.
Whatever the reason, this update seems to have made
Hi,
I have Tables displaying data from a DataTable that is updated
periodically. In my table options, I have:
wrap.setOptions({
allowHtml:true
,sortColumn:1
,sortAscending:false
,page:'disable
Can you update this thread when the update goes out?
thanks,
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email
For what it's worth, I've found that it's sometimes more convenient to
set columns on the Table directly instead of the DataTable or
DataView. I also like to set the sort order on the Table, too, since
this avoids my needing to sort the DataTable (whose sort order might
be important to another met
alization.Query.setResponse returns JSON, then you can just
> eval it directly.
> Something like
> response = google.visualization.Query.setResponse(...)
> response = eval(response);
> var data = new google.visualization.DataTable(response.table);
>
> On Jan 17, 11:12 am, NA wrote
Hi,
That's what I ended up doing. With some minor tweaks to the regexp
expressions, it works well. (If anyone wants to see, let me know and
I'll post it later tonight. I'm not at the computer that has access
to that code right now).
thanks again for the helpful suggestion,
--
You received th
Hi Jinji,
How do I zip the URL? I'm not aware of any Javascript methods for
zipping/gzipping. There are a few libraries floating around on the
Internet, but most of them seem unreliable in various ways - old,
don't work, buggy, etc.
Is there a standard way of zipping string data in Javascript,
Now I'm curious - is there a reason the Table chart doesn't implement
identify which column was clicked on? Is this something that's more
complicated than I imagine, or are there some situations where this
becomes difficult?
Since the Table provides a listener that tells us what row was clicked
o
I will, thanks!
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to
google-visualization-api+unsubscr...@googl
Ironic that at the top of this Google Groups thread there's a link
titled "Translate all to English" but that it's not helpful here!
David - can you post a complete example that reproduces the problem
you're seeing? I couldn't tell from the Google translation what the
problem actually was. What
Hi,
Can you give more details about the Table memory leak? There's an old
thread with the subject "Memory Leak in Table Visualization
Component". Does this bug fix address that issue?
thanks, and congrats on preparing a new release!
--
You received this message because you are subscribed to
Hi,
I currently use the Query() method to request data from my server. My
server responds with text that looks something like:
google.visualization.Query.setResponse({"status":"ok","reqId":"0","table":
{"cols ...
All is good so far. :)
I want to make requests to this same server, but I want
Thats a fine workaround, but is there any plan to allow us to switch
methods with the Query object?
This would allow end users of your product to not have to implement
their own protocols to solve this problem. POST is a standard
solution to sending a large query to a server, and it makes more se
Will the roles work ? I have been avoiding for several reasons, but
also assumed that since the GeoChart documentation doesn't mention
them that they wouldn't work.
One of the reasons I'm avoiding roles is because they are described as
"experimental". That puts me in a situation no better than u
Are you saying that if we want a map using longitude and latitude
coordinates with labels, this is no longer possible? This was
possible with the GeoMap object.
Or am I misunderstanding this? I have the same issue - I'd like to
use the new map, but I need to place a label with each of the
marker
No, I didn't! That seems like the right thing to do.
But which element do I need to style to prevent the horizontal
scrollbar from appearing? I've been styling the table's container
using jQuery('.google-visualization-table-
table').parent().css('overflow-x','hidden'); but I don't think that I
c
Hi,
I've been using the google.visualization.Query(url) method to get
data. The url string that I'm using is starting to get very long.
I'm concerned it's going to get too long and exceed the expected
maximum lengths for a GET request. Will this method automatically
rewrite the request into a PO
Sorry if it's obvious, but did you try F12 to see what the debugger
tells you? I believe the debugger also has a "Net" tab which lets you
see all the network requests being made. You should be able to verify
that all the queries your app is making are successful from there;
that would let you pin
Hi,
I have some Tables that have horizontal scrollbars which I'd like to
suppress. I don't think there's an option in the Table visualization
for doing this, and I couldn't find a way to permanently suppress this
using CSS, since when the underlying DataTable is updated, the Table's
horizontal sc
Some thoughts:
> Without the WHERE, it works fine, so the rest of the code is okay. Is
> there specific Google spreadsheet syntax that I should be using?
If there are, that would be one of the drawbacks of this method ;)
Using Google Spreadsheets, other than binding you to potentially
special syn
Hi,
Does the wrapper.setDataSourceUrl() method change the reqId value when
it makes requests to your server? If so, you'll need to change that
value in the text file before sending it back. I'm not aware of any
other way to work with a text file as a data source (I didn't see a
way in the API to
So it sounds like there isn't a method, I'll just have to roll one
myself out of the other get* methods, including the ones asgallant.
I'm going to create an enhancement request for this, as I think it's
useful to be able to extract a row from a table for later
manipulations.
In fact, it's also u
That explains it - I thought this was a way to get back the data in
the row.
Is there a method that returns the data in a row (including value,
type, format, etc)? Or do I need to write my own?
--
You received this message because you are subscribed to the Google Groups
"Google Visualization A
When you set a formatted value for a cell, the format isn't copied
over to any derived tables, such as those created by grouping
operations.
Unfortunately, if you set a formatter function for a column, it isn't
copied to derived tables, either. The formatter function behaves
similarly to what you
I'm not understanding asgallant's or MC Get Vizzy's comments. In
fact, it seems like you're talking about getValue() but I'm talking
about getRowProperties().
There's a method called getRowProperties documented here:
http://code.google.com/apis/chart/interactive/docs/reference.html#DataTable_
I'm having some trouble with getRowProperties. I have:
function drawVisualization() {
var dataTable = new google.visualization.DataTable();
dataTable.addColumn('string', 'Name');
dataTable.addColumn('number', 'Age');
dataTable.addColumn('string', 'Instrument');
dataTable.addColumn('stri
I'm under the impression that if the webpage requested a CSS file but
was unable to download it, you'd see an error in Firebug. Doesn't
Firebug have a "network" panel that might show a list of files
requested and whether they were successfully downloaded?
I'm not sure about your forum posting pro
You can always check the browser compatability by visiting the Chart
Gallery and seeing if you can view the charts:
http://code.google.com/apis/chart/interactive/docs/gallery.html
That's a good way to make sure the API is still working, and a way of
confirming that a browser is capable of displ
Looks like you had copied and pasted the code here?
It appears that you are setting the values for row 4 over and over
again. I didn't get a chance to run the code, but that's what it
looks like. Change the values of "4" in the last few setValue calls
to 5, 6, 7, and 8 and you should be ok.
You
Good point - I agree about parents with the same name.
But the problem even exists with terminal leaf nodes that have the
same name. If these are terminal leaf nodes, there shouldn't be any
ambiguity since their parent is defined and they aren't parents for
any other node. In my test cases, howe
Rather than swap the value of the cell, I suggest looping over each
value in the column and setting its formatted value using
setFormattedValue(). Set the formatted value to be an img link, as
done in "regular html" (). Then set the allowHtml
option of the Table to true. The images will then app
I think that the doc indicates you cannot set reqId yourself, but I'm
not positive. This is something the API sets. If you have a page
that makes multiple calls to get data, you'll see the reqID parameter
vary for each call. I assume this is used by the API to determine
which response goes with
I think you mean:
google.setOnLoadCallback(firstFunction);
If you use google.setOnLoadCallback(firstFunction()), you will
actually call firstFunction() with no inputs. But
google.setOnLoadCallback(firstFunction) just passes the function
"firstFunction" to the setOnLoadCallback method, which is
You might want to post a link to that doc on this group, too. It
could be helpful for some of the readership.
On Oct 9, 9:24 am, daxesh patel wrote:
> Hi,
> i want to make Document about how to use Google Organization
> Chart in Oracle Apps And publish that doc on internet so any special
>
Are you sure it's the rendering process? In the tests that I've run
(ranging from hundreds to thousands of points), I didn't see much
variance across browsers. Some were faster than others, but all were
in the same ballpark. I wasn't using the scatterplots, though, so
that may be significant (I
I recommend using a ChartWrapper to create the Gauge. Then call the
ChartWrapper.draw() method without any inputs.
If you call Gauge.draw(dataTable, options), the chart is redrawn with
the datatable.
You might be able to call Gauge.draw() without any inputs, though I'm
not sure if the Gauge supp
I initially agreed with that, but then realized that you'd need to
teach a Table how to aggregate the columns, which it doesn't know how
to do. The DataTable, on the other hand, knows how to perform
aggregations, so adding an totals row property to the DataTable and
having the Table know how to p
BTW, are we talking about a total row with a DataTable or with a
Table? It seems as if we're mixing the two, as pagination is for a
Table but the comments and subject are for DataTable.
If you can implement it for a DataTable, and have the Table detect the
totals row and display it appropriately,
+1 to make the totals entire table based.
+1 to allowing us to specify the aggregation function for the totals
(similar to how grouping is done).
I agree with Guillaume's comments about totals with pagination. If
you can support both without too much trouble, then go for it, as it
might make more
I want to show the header, but I specifically don't want paging (I
find paging distracting when scanning data). It is a nice idea, but
given my anti-paging constraint, it won't work!
Re the css: The problem is that the html and css used to create the
GVIZ Tables isn't documented nor is it part of
So it looks like the google.visualization.Table class doesn't support
this? I'm reluctant to use another library to try to manipulate the
GVIZ objects. I I were going to use another library, I suspect it's
be easier and possibly more reliable to not use the GVIZ library in
the first place, and ju
Is it possible to get the headings in a Table to freeze, so that if
you scroll down they remain visible?
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visualization-api@googlegroups.com.
> The email suggests a quick solution to converting these values to string
> using a DataView, so you won't have any sorting issues.
> Please take a minute to look at the suggestions we made (using a DataView).
> It's a very easy and quick change. How many charts are we talking about?
I read your
I don't understand.
Are you saying that you never supported plotting data vs time?
Plotting data vs time is *extremely* common (I can't believe I even
have to type this out). Your current charts do this just fine,
without any problems. There is no reason to change that. Why would
you put in a
Is there a "positiveColor" or similar option for NumberFormat ? We
can color negative values using "negativeColor", but I'd like to also
color positive values.
If not, any tips for doing this simply, similarly to what we could do
with NumberFormat?
--
You received this message because you are s
I must admit, I got the idea from an earlier tip you had given me :)
It is super messy. A great future enhancement would be to provide a
css API for styling the gauges, charts, etc. That'd be very helpful.
--
You received this message because you are subscribed to the Google Groups
"Google V
You might be able to inspect the markup around the chart to find out
if you can apply some css to the appropriate class or selector to
change it. It's messy, but it might be a suitable workaround until
this is something the API allows you to do.
--
You received this message because you are subsc
I'm not sure what you are agreeing with.
There is a workaround - I've been using it for a few months now. But
this is a deficiency in the charts. If the x-axis were a "category"
axis, this would be fine. But in the case where the x-axis is a date
(or any other numerical axis), this behavior dis
Can you tell us why GVIZ doesn't use Google's versioning system? This
is what's most frustrating and surprising. Explaining why it's not
used would at least restore some faith in the product, since without
an explanation it seems as if the GVIZ team "just forgot".
--
You received this message b
I'm not sure if this is what you're getting at, but the charts do not
recognize that there are gaps between the x-axis coordinates when you
use dates. They are rendered as if the space between each point is
equal. You will need to create entries for those missing points on
your own. If there is
That's sort of what I was thinking.
I'm worried, though, that this code will "collide" with the GVIZ
Table's sort capability. I think I'd have to make sure my detail rows
stayed below their parent rows; but not sure as I still haven't yet
clearly planned it out.
At present, I just display detail
Does anyone have ideas on how to expand a Table row to show more rows
when it's clicked? There are a couple of earlier threads asking about
this - one doesn't get answered, the other suggests tooltips, which
doesn't seem particularly useful.
Are there better ideas?
Perhaps something like using t
Hi,
I'm planning on adding sparklines to a project I have. The sparklines
will be updating at regular intervals, about every 1-5 seconds.
Should I use the sparklines object for this, or is it better to create
my own sparklines using the Line chart type? I have a feeling the
answer is going to b
iccup. I'll
post again if it happens...
thanks,
On Aug 18, 3:12 am, Viz Kid wrote:
> We are not aware of any issues.
> Is this still the case for you? Is the long downloading time occurs when you
> load the map or the general package?
>
>
>
>
>
>
>
>
That's the second person to post that they are having problems. As
with my comments in the other thread, the GVIZ product manager needs
to step in and start using the versioning used by other Google
products to give your end users some control over the version they are
using. You are actually dam
This is why the Google Visualization package needs to follow the
versioning used by other Google products. Because Alex cannot select
which version he wants to use, he is now forced to attempt to fix this
issue *after* all of his clients have experienced the bug, instead of
after he has had time t
Why aren't you willing to speak about future plans? The unwillingness
to let customers know where you're heading makes it difficult to work
with your product.
In fact, you'd think that your product manager would want to share
this information with his clients. Instead, you seem to be very
secret
Do we have an ETA on this? It adds an extra set of processing I have
to do on every data set, which I'd love to eliminate.
--
You received this message because you are subscribed to the Google Groups
"Google Visualization API" group.
To post to this group, send email to google-visualization-api
1 - 100 of 207 matches
Mail list logo
