from:"Riccardo Govoni ☢"

More likely

options['hAxis'] = {'title': 'asdf' };

or

options['hAxis'] = {};
options['hAxis']['title'] = asdf;

Otherwise I suspect you'd end up with an undefined property when executing
the last line without the one before it.

- R.

On 4 November 2011 12:31, asgallant drew_gall...@abtassoc.com wrote:

 The API is rather particular about how you set options.  I usually see it
 done in object notation, but it you have to do it this way, the proper
 notation is probably:

 options['width'] = 100%;
 options['height'] = 300;
 options['legend'] = none;
 options['hAxis']['title'] = asdf;
 options[vAxis']['title] = asdf;

 --
 You received this message because you are subscribed to the Google Groups
 Google Visualization API group.
 To view this discussion on the web visit
 https://groups.google.com/d/msg/google-visualization-api/-/41kpxYp_-kEJ.

 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Re: Preventing Motion Chart Interpolating Data

Wouldn't be easier to customize the existing scatter plot to behave like a
bubble chart? (you'd need a separate serie for each bubble size/color
combination however, which could make the datatable and options set a
little ugly).

- R.

On 4 November 2011 11:12, rd-london roland.d...@gmail.com wrote:

 Hello again,
 I actually have another request.

 It is possible to use the Google Motion Chart as a highly
 sophisticated bubble chart by setting the data to span just one date,
 a placeholder, meaningless date. This is really useful.

 But with one downside: the one single date appears beneath the x-axis,
 and if the date is purely a placeholder, then it's quite an eyesore -
 and one has to put up supporting copy explaining that the date is
 actually meaningless.

 So it would also be useful to configure the Google Motion Chart such
 that the dates/time, if there is only one date, is not shown beneath
 the x-axis.

 Many thanks,

 Cheers
 R








 On Nov 3, 10:36 am, rd-london roland.d...@gmail.com wrote:
  Hi,
  Many thanks for responding, apologies for taking so long to reply.
  Yes, I'm only talking about the bubbles view.
 
  If interpolate:False is switched on, then the bubbles only actually
  *appear* when there is data. This may seem odd, and you may think that
  the resulting experience may be ugly - however it would then be
  truthful. The beauty aspect is irrelevant when you're actually looking
  for this chart (which I do utterly love btw, I think it's a thing of
  genius) to represent the truth behind the statistics.
 
  So the result would be that bubbles would appear and disappear.
 
  Thanks,
  R
 
  On Oct 31, 1:41 pm, EZChart ezch...@google.com wrote:
 
 
 
 
 
 
 
   I'm not sure I understand what exactly you want to happen when
   setting interpolate: False.
   Are you talking only about the bubbles view?
   Today, if you use a daily scale, with data points one month apart from
 each
   other, then motionchart will create intermediate data points by linear
  interpolation.
   When setting interpolate: False do you want the bubbles to jump
 when
   the data changes, instead of moving smoothly?
 
   On Wed, Oct 26, 2011 at 3:59 PM, rd-london roland.d...@gmail.com
 wrote:
Hello again,
Only me  I see no-one replied to this, which is a great shame.
 
The Motion Chart visualisation is full of wonder, it's a great thing
 -
and Hans Rosling (http://en.wikipedia.org/wiki/Hans_Rosling), the
 man
who originated this I think, is terrific - his TED talk where he
swallows swords is truly a beautiful thing.
 
Given such beauty, it is a great shame that the Motion Control seems
to *ALWAYS* interpolate results - it's so annoying! Is there
absolutely no way I can set a setting, flick a switch, raise a flag -
do something - to stop it doing this?
 
If there isn't, couldn't you just squeak this little tiny request
 into
the next rollout? Go on, you know you want to  It would be as
simple as:
 
interpolate: True, or even interpolate: False
 
Thanks,
R
 
On Sep 17, 6:09 pm, rd-london roland.d...@gmail.com wrote:
 Hi,
 
 Is it at all possible to prevent the Motion Chart frominterpolating
 results?
 At all, in any way?
 
 Thanks,
 R
 
--
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...@googlegroups.com.
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
 google-visualization-api@googlegroups.com.
 To unsubscribe from this group, send email to
 google-visualization-api+unsubscr...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] how to make a pyramid chart

If you are refering to something generically pyramid-shaped like
thesehttp://goo.gl/VYdSG,
I don't we have anything like that.
However, you may be able to tweak a stacked bar
charthttp://code.google.com/apis/chart/interactive/docs/gallery/barchart.htmlvisualization
to achieve something like
thishttp://blog.trivadis.com/blogs/michaelkoenings/WindowsLiveWriter/HowToCreateAgePyramidChartsinReportingSe_95C5/clip_image002_2.jpg,
although I haven't tried it yet.

As Roni said, extra details would be helpful.
- R.

On 4 November 2011 09:15, Roni Biran roni.bi...@gmail.com wrote:

Can you give an example for this chart? An image of some sort?

On 4 בנוב 2011, at 05:56, asromero lob...@hotmail.com wrote:

Is this kind of chart yet supported? or how can i do this type of
chart?

txs

--
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...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Legend Truncated when Querying Fusion Table

This is a known issue on the Fusion Tables side (labels truncation).

See http://code.google.com/p/fusion-tables/issues/detail?id=631 and the
last post in this thread
https://groups.google.com/d/topic/google-visualization-api/MG4kurSZr5s/discussion

- R.

On 4 November 2011 16:40, Wayster c...@8newsnow.com wrote:

 Hello ... how can I keep the legend labels from being truncated (not
 talking about adding the ellipses when there is not enough space in
 the chart area) when populating a column chart using a Fusion Table
 query? Looks like it only displays 10 characters.

 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Can I download Google Visualization API's source code?

2011-11-03 Thread Riccardo Govoni ☢

Unfortunately the terms of service do not allow that.

See http://code.google.com/apis/chart/interactive/faq.html#localdownload

However, the time the browser spends downloading the Google Visualization
API from Google servers is usually small (in the order of a few hundred
milliseconds depeding on your browser and network connection), plus the API
code is cached by the browser so subsequent loads should be even faster.
Does the slowness you see originate from long download times or is the
client-side rendering that is taking the most part ? Can you tell us more
about your case ?

- R.

On 3 November 2011 20:12, Hector Rojas hector.ro...@whitehatconsultores.com
 wrote:

 Hi my name is Hector, I'm a developer, I would like to download the
 Google Visualization API's source code, because my application is very
 slow when it's rendering the chart generated by Google Visualization
 API. I think that my application may be faster, if I have  the Google
 visualization API's source code in my server.

 Thanks for your attention.

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

[visualization-api] On saving interactive charts as static images

2011-11-02 Thread Riccardo Govoni

This is a topic that pops up frequently here in the forum. Many users have 
the need to convert/serialize the interactive charts they generate using 
the Google Charts Tools API into static images (PNGs or equivalent) for the 
user to download or further process.

Currently the interactive charts API do not offer this feature (unless you 
are in specific domains, such as within a Google Apps 
Scripthttp://code.google.com/googleapps/appsscript/script), unless you are 
willing to regenerate your chart using the static 
image APIs http://code.google.com/apis/chart/image/ --- which however 
have different semantics, making it difficult to support both.

A quick workaround for this is to convert the SVG chart to canvas / and 
then extract the image data from there. This allows for full client-side 
pure javascript image serialization, at the cost of cross-browser support. 
The solution works on Chrome,Safari,Firefox,IE9 and Opera, but IE8 and 
lower does not support the necessary features for this to work (server-side 
image serialization is also possible, although I won't discuss it here).

I have written a brief tutorial and example page to show how this work. 
Depending on the browsers your users use, and how flexible you can be, the 
solution might be good enough for your case.

Tutorial 
: http://www.battlehorse.net/page/topics/charts/save_google_charts_as_image.html
Example 
page: 
http://www.battlehorse.net/attach/topics/charts/google_charts_to_image.html
Source code : https://gist.github.com/1333906

Please note that this is somewhat an hack that I put together in the spare 
time based on the popularity of topic and lack of support in the current 
official API, so use at your own risk. Have a look at the tutorial for the 
limitations. If I were to support image serialization for a production 
service, I'd still recommend using the static image APIs mentioned above.

Please discuss / comment / improve.
- R.

-- 
You received this message because you are subscribed to the Google Groups 
Google Visualization API group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/google-visualization-api/-/8kJwHA9OQwsJ.
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...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Scatter chart, formatting each point

2011-11-02 Thread Riccardo Govoni ☢

Each 'serie' is a separate column of data. So if you have 3 series, you'll
have 4 columns of data (1 for the x-axis, 1 for each of the 3 serie).

In your example, although you are defining colors for 6 series, you are
assigning all values to the first 1 (since all your setValue() calls only
target the 0th column -- for the x axis -- and the 1st column -- the values
of the 1st serie).

Have a look at this example instead and the comments contained in the
source therein:
http://savedbythegoog.appspot.com/?id=02b9d7a088bcdd8d95a4e9d7f0d8949a24c93edd

- R.

On 2 November 2011 20:39, AleRitty aleri...@gmail.com wrote:

 Hi! I need to set a specific colour (and/or point size) for each point
 of my graph, I'm using this code (taken directly from the official
 examples):

 [code]
  google.load(visualization, 1, {packages:[corechart]});
  google.setOnLoadCallback(drawChart);
  function drawChart() {
var data = new google.visualization.DataTable();
data.addColumn('number', 'Age');
data.addColumn('number', 'Weight');
data.addRows(6);
data.setValue(0, 0, 8);
data.setValue(0, 1, 12);
data.setValue(1, 0, 4);
data.setValue(1, 1, 5.5);
data.setValue(2, 0, 11);
data.setValue(2, 1, 14);
data.setValue(3, 0, 4);
data.setValue(3, 1, 4.5);
data.setValue(4, 0, 3);
data.setValue(4, 1, 3.5);
data.setValue(5, 0, 6.5);
data.setValue(5, 1, 7);

var chart = new
 google.visualization.ScatterChart(document.getElementById('chart_div'));
chart.draw(data, {width: 400, height: 240,
  title: 'Age vs. Weight comparison',
  hAxis: {title: 'Age', minValue: 0, maxValue:
 15},
  vAxis: {title: 'Weight', minValue: 0,
 maxValue: 15},
  series: {
  0:{color: 'blue', pointSize: '3',
 visibleInLegend: true},
  1:{color: 'black', pointSize: '3',
 visibleInLegend: true},
  2:{color: 'red', pointSize: '3',
 visibleInLegend: true},
  3:{color: 'red', pointSize: '3',
 visibleInLegend: true},
  4:{color: 'red', pointSize: '3',
 visibleInLegend: true},
  5:{color: 'red', pointSize: '3',
 visibleInLegend: true}
  },
  legend: 'none'
 });
  }
 [/code]

 But in this way every point is blue.
 If I change the value for the serie 0 from blue to black, every point
 became black!

 Is possible to change the color of every point indipendently?

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Serialization of visualizations

2011-11-01 Thread Riccardo Govoni ☢

I think there's a bit of confusion here. What exactly do you mean by
'serializing' the chart ?

If you intend to persist the chart state in same format that can be later
rebuilt, this is already available, for example using
ChartWrapper.toJSON()http://code.google.com/apis/chart/interactive/docs/reference.html#chartwrapperobject
.
See the sources of this
examplehttp://savedbythegoog.appspot.com/?id=52de9ea50453e4aeb4a5af5f1f8f85c0ea3a9bcf
which
draws a chart, serializes it into a json string and then parses it back
again to build a clone.

If you intend converting the chart to image, then indeed that is something
that is currently explicitly supported only inside Google Apps
Scripthttp://code.google.com/googleapps/appsscript/service_charts.html
via
the 
getBlob()http://code.google.com/googleapps/appsscript/class_chart.html#getBlobmethod
you mentioned. Alternatives way, such as converting the chart svg
into canvas / and building an image out of that, could probably work, but
they are outside the library boundary (read: you have to implement them on
your own).

-- R.

On 31 October 2011 13:16, Roni Biran roni.bi...@gmail.com wrote:

 according to the I/O 2011 (London GTUG) this feature is supposed to be
 supported in the future for ChartWrapper (
 http://www.battlehorse.net/wontlast/gtugChartsLondon/index.html#27),
 however I don't think it's supported at the moment.

 I know for myself, that I need this feature for exporting charts as images.
 If you'll find a way to make it work, please let us all know.



 On Mon, Oct 31, 2011 at 1:10 PM, Eric allomor...@gmail.com wrote:

 I am using the html examples at
 http://code.google.com/apis/ajax/playground/#line_chart

 This html I paste into a server page.

 How do I load the appropriate libraries and call the methods in order to
 serialize the chart produced?  Please could someone refer me to a
 *working example*
 of html/javascript for this.

 I am able to implement this with the examples given for serialization and
 email but then only as a function in a script editor.
 I believe this has to do with my lack of understanding of the javascript
 and the loading of libraries with google.load.
 When I try to include the following code in an html page in the , I get
 unexpected Identifier
 or unknown method getBlob.

 First I change the line
 new google.visualization.LineChart( ...
 to
 var myChart =  new google.visualization.LineChart(...

 Then in the main function of the linechart example, add the stanzas;

 var chartBlob = myChart.getBlob().getBytes();

var chartFile = [{fileName: chart.png,
  mimeType: image/png,
   content: chartBlob}];

 I would appreciate advice on how to implement this correctly.

  --
 You received this message because you are subscribed to the Google Groups
 Google Visualization API group.
 To view this discussion on the web visit
 https://groups.google.com/d/msg/google-visualization-api/-/-HUmK2on2vwJ.
 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...@googlegroups.com.
 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
 google-visualization-api@googlegroups.com.
 To unsubscribe from this group, send email to
 google-visualization-api+unsubscr...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Can I ask a dumb question

2011-11-01 Thread Riccardo Govoni ☢

Sorry for the late answer.
We recently rolled out a feature that lets you use some aspects of charts
directly from Google Sites (see
http://googledocs.blogspot.com/2011/09/visualize-your-data-with-charts-in.html
)
but we don't offer yet direct support for Dashboards.

To use dashboards you must be able to edit the html source of the page
where you're inserting the dashboard into, something that Sites does not
allow. So if you write an html page that contains a dashboard, you'd have
to host it somewhere else.

As a workaround, you could then later surface the dashboard inside a Google
Site using a gadget that lets you embed external content in a site, like
one of the many iframe gadgets available (menu Insert  More Gadgets when
you are editing a Site page).

-- R.

On 25 October 2011 11:10, Tony Holmes mail.tonyhol...@gmail.com wrote:

 The dumb part with respect to most of you guys is that I am a
 non-programmer so am unfamiliar with the Google Apps Script environment.

 Anyway... watched some Google I/O 2001 YouTube (
 http://www.youtube.com/watch?v=NZtgT4jgnE8) and was impressed with the
 potential of Dashboards to present live data feeds to charts... i.e.
 using CategoryFilter, RangeFilter etc to present different views on data
 held in Docs Spreadsheets.

 The company I work for is a supplier to Google and we have an internal
 Go site, however to try this stuff out set up my own Google Site as a
 trial (https://sites.google.com/site/tonytestforcharts/) .The idea is to
 ultimately host the dashboards on the internal Site.

 The problem I have is that I have discovered I don't have access to the
 head of the document to load libraries and it appears Google sites
 doesn't allow scripts to run anyway, unless through gadgets (I think)
 non-programmer so dooh!

 Questions:
 Can this be done through Google sites or am I barking up the wrong tree?
 Or is there a higher level access for Google sites to allow access to the
 head section and run scripts?   And if so how do I get this?

 Any help you wizards can offer a muggle will be much appreciated.


  --
 You received this message because you are subscribed to the Google Groups
 Google Visualization API group.
 To view this discussion on the web visit
 https://groups.google.com/d/msg/google-visualization-api/-/uTsXNas7XAYJ.
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

[visualization-api] Themes for the Controls and Dashboards API

2011-10-25 Thread Riccardo Govoni

Folks,
The Controls And Dashboards
APIhttp://code.google.com/apis/chart/interactive/docs/gallery/controls.html
is
the part of the Google Charts APIhttp://code.google.com/apis/chart/index.html
that
lets you assemble multiple charts into dashboards and enrich them with
interactive controls to manipulate the data they display. It defines a set
of widgets (category pickers, range sliders, autocompleters...) you
interact with in order to drive the data managed by a dashboard and the
charts that are part of it.

A while back a couple of questions came up in the forums about skinning and
styling the Controls widgets.

To address this, I've set up an example project at
https://github.com/battlehorse/google-charts-controls-gallery that shows
how to create custom themes for the Controls widgets. I have also included
two sample themes as examples
(onehttp://battlehorse.github.com/google-charts-controls-gallery/#google-visualization-controls-theme-plusinspired
by the latest redesign of Google properties, the
otherhttp://battlehorse.github.com/google-charts-controls-gallery/#google-visualization-controls-theme-contrastshowing
an high-contrast setup for accessible access). The styles are
easily inspectable, so it should be fairly easy for anyone to extend /
modify them.

You can find demos and docs at
http://battlehorse.github.com/google-charts-controls-gallery/.

I have hacked it together quickly, so it's still a bit rough (and I haven't
really tested it across a wide set of browsers).

Comments and contributions welcome,
-- R.

--
You received this message because you are subscribed to the Google Groups
Google Visualization API group.
To view this discussion on the web visit
https://groups.google.com/d/msg/google-visualization-api/-/FvXlvJ2bvVYJ.
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...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] cssClass for ControlWrapper

2011-10-25 Thread Riccardo Govoni ☢

Hi there,
ridiculously late, but I've prepared some docs and examples on how to apply
custom themes on Controls:

https://groups.google.com/forum/#!topic/google-visualization-api/9DxAApWoIzk

ControlWrappers use a mixture of widgets (autocompleters, sliders, ... ) so
it's a bit longer to provide a coherent theme for all the controls, but the
above link should provide some guidance.

For minor stylistic changes (for example, the color palette), or changes
that apply to a single control, also consider the 'ui.cssClass' option that
every ControlWrapper supports (
http://code.google.com/apis/chart/interactive/docs/gallery/controls.html#gallery)
and lets you add a custom class to the control.

-- R.

On 10 October 2011 18:58, fgrayli fgra...@gmail.com wrote:

 Can anyone provide any documentation about the format of the Custom
 Style Sheet for different type of the ControlWrappers?
 something like this that we are using for Table:
 cssClassNames = {
'headerRow':'header-row bold-font font',
'headerCell':'header-cell font',
'tableRow':'table-row',
'tableCell':'table-cell font',
'selectedTableRow':'selected-row',
'oddTableRow':'odd-rows',
'hoverTableRow':'hover-row'
};



 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] conversion error on Google visualization java

My best guess is that the version of google collections you are using
(google-collections-1.0-rc4.jar)
is old and did not yet include the method (com.google.common.collect.
ImmutableList.copyOf(Ljava/util/Collection;) )  that TableRow.getCells()
tries to invoke (as you can see from the stack trace).

Upgrading your collections library (see
http://code.google.com/p/guava-libraries/ , which supersedes
google-collections) should fix it.

If you can't do so, you may try recompiling the
google-visualization-javahttp://code.google.com/p/google-visualization-java/sources
against you're current google-collections jar. This might fail for
other reasons (the visualization library depending on other classes/methods
not present in your jar), but the specific exception you mention should go
away because the overloaded use ImmutableList.copyOf() should resolve
against ImmutableList.copyOf(Ljava/lang/Iterable;), which exists in your
google-collections jar.

-- R.

On 13 October 2011 10:28, P G pgun2...@gmail.com wrote:

 Hi,

 I am new to this google visualization api. I am trying to create
 datatable from java backend and javascript will create chart for me
 using google visualization javascript API.
 Java code -
 while (itr.hasNext()) {
DatamartPrice priceObj =
 (DatamartPrice) itr.next();
TableRow row = new TableRow();

  row.addCell(priceObj.getValueDate().toString());
row.addCell(priceObj.getValue());
chartDataTable.addRow(row);
}

 Jar files in classpath are - visualization-datasource-1.1.1.jar and
 google-collections-1.0-rc4.jar

 Exception is thorwn on line chartDataTable.addRow(row);

 java.lang.NoSuchMethodError:
 com.google.common.collect.ImmutableList.copyOf(Ljava/util/
 Collection;)Lcom/google/common/collect/ImmutableList;
at
 com.google.visualization.datasource.datatable.TableRow.getCells(Unknown
 Source)
at
 com.google.visualization.datasource.datatable.DataTable.addRow(Unknown
 Source)
at

 com.jpmorgan.research.cfp.datamart.DatamartUtil.getDatamartPriceDataForGraph(DatamartUtil.java:
 49)
at

 com.jpmorgan.research.cfp.servlets.PerformanceChartServlet.doGet(PerformanceChartServlet.java:
 57)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at

 org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:
 290)
at

 org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:
 206)
at

 org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:
 233)
at

 org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:
 191)
at
 org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:
 127)
at
 org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:
 102)
at

 org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:
 109)
at
 org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:
 291)
at
 org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:
 859)
at org.apache.coyote.http11.Http11Protocol
 $Http11ConnectionHandler.process(Http11Protocol.java:602)
at
 org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:
 489)
at java.lang.Thread.run(Thread.java:619)


 Can someone help me to resolve this issue?

 Thanks,
 PG

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Re: How to change StringFilter value with a listener

I assume that your 'slider' variable points to a StringFilter (like you
mention in the title). In which case setState should work as you describe.

Have a look at this example:
http://savedbythegoog.appspot.com/?id=99fb271ca54b04894ae19f44b748467feea3509band
its source code, where clicking on the button sets a specific value on
the string filter.

If instead your 'slider' variable points effectively to a slider
NumberRangeFilter, than the state format is different, as described in
http://code.google.com/apis/chart/interactive/docs/gallery/controls.html#numberrangefilter

-- R.

On 13 October 2011 15:22, Tday the.t...@gmail.com wrote:

 Somehow there was a missing semi colon in the paste.  I do see that on
 the value = 'Broken' line.

 On Oct 13, 10:21 am, Tday the.t...@gmail.com wrote:
  I'm trying to refine a search method of my table where there are two
  buttons that show only what is essentially true or false.
  Here's my listener declaration for my dashboard.
 
  google.visualization.events.addListener(dashboard, 'ready',
  dashReady);
 
  And here's the listener function.
 
  function dashReady(){
  document.getElementById('workButton').onclick =
 function() {
  slider.value = 'Working';
  slider.draw();
  };
 
  document.getElementById('breakButton').onclick =
 function() {
  slider.value = 'Broken'
  slider.draw;
  };
  }
 
  I also tried slider.setState({'value':'Working/Broken') but had no
  success.  Help would be appreciated!

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Interaction on a Column Chart with a NumberRangeFilter

As you correctly describe, the listener tells you which row was selected
with respect to the filtered chart (row 0 of the filtered chart), but you
resolve that row number against the overall datatable when you call
data.getValue().

To fix the problem, resolve the value against the filtered datatable itself.
Try replacing:

var selectedItem = chart.getChart().getSelection()[0];
var value = data.getValue(selectedItem.row, 0);

with

var selectedItem = chart.getChart().getSelection()[0];
var value = *chart.getDataTable()*.getValue(selectedItem.row, 0);

In the context of dashboards, each chartwrapper that is part of it holds a
reference to the 'filtered' datatable that is was drawn with. You can access
it via its standard getDataTable() method, as shown above.

-- R.

On 13 October 2011 11:12, Andrea andrea.mign...@gmail.com wrote:

 Hi Everybody, I've a problem.

 I am drawing a column chart with a NumberRangeFilter (slider) in this
 way;

 //...
 dashboard.bind(slider, myChart);
 dashboard.draw(dataTable);


 I added a listener:

 google.visualization.events.addListener(myChart, 'select',
 selectHandler);
 function selectHandler() {
   var selectedItem = chart.getChart().getSelection()[0];
   var value = data.getValue(selectedItem.row, 0);
   alert('The user selected ' + value);
 }


 Everything works fine. But when I use the slider to filter my data the
 listener dosn't work anymore. The problem is that the Listener
 considers as row 0 the first bar of the filterd chart, but it refers
 to the unfiltered data table. So the item selection does not work
 when I use the slider.

 i.e.

 DataTable:
 item  value
 A   5
 B   3
 C   2

 If I use the slider to see value  5 I get a column chart with only
 bar B and bar C. But when I click on the first bar of the chart (bar
 B) the event listener returns the first row of DataTable: the item A.

 How can I fix this?

 Tanks.

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Chart and Dashboard White Space

When you say 'dashboard', do you mean the google.visualization.dashboard
mentioned in
http://code.google.com/apis/chart/interactive/docs/gallery/controls.html ?
In that case, I'd like to know more, since those dashboards shouldn't use
any space: the dashboard itself does not occupy any visible space, only the
charts and controls part of it do.

For charts, the chartArea option is usually the one that works best, along
with other minor tricks (such as legend placement, axis font-sizing and
such).

You can use your browser web inspector to have a look at the sizes of each
DOM element and see where space is going.

If you have a live example somewhere, we could have a look and help figuring
out where the problem is.
-- R.

On 13 October 2011 20:25, Tday the.t...@gmail.com wrote:

 It seems like there's an extraordinary amount of whitespace that the
 dashboard and charts add when drawn.  I have a dashboard almost 700
 pixels tall, but probably 400 of that is simply white space.  Same
 goes for a piechart.  I've tried using chart area, but to no avail.

 Any ideas, I've looked through past documentation on this issue--
 solutions are pretty scarce it seems.  I think I just must be doing
 something wrong.

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Re: Dashboard sort

The issue you have is that your code accumulates unnecessary listeners every
time you click on the table header, because of an implicit loop between your
table 'ready' event and the listener that reacts to sorting events:

- when the table is 'ready' , the onReady() method is called.
- onReady() adds a listener for the 'sort' event on the table
- when you click a table header, the 'sort' event fires
- the 'sort' event triggers a dashboard redraw
- the dashboard redraw implicitly redraws the table is well.
- when the table draws, it fires a 'ready'
eventhttp://code.google.com/apis/chart/interactive/docs/events.html#The_Ready_Event.
Go back to step 1.

So every time you change the table sorting, the number of listeners (and
consequent redraws) increases exponentially (to be precise, your dashboard
will redrawn 2^n-1 times on the nth click to change the table sorting).
After a few clicks the whole thing will slow down to a crawl.

You can easily debug this by adding a console.log statement in your 'sort'
event callback and see how many times it fires.

The solution is to break the cycle. After all you want to attach the 'sort'
listener only after the table has been drawn the first time. So you can
change your code to the following:

*var readyListener = *google.visualization.events.addListener(table,
'ready', onReady);
...

function onReady() {
*  google.visualization.events.removeListener(readyListener)*
  google.visualization.events.addListener(table.getChart(), 'sort',
function(event) { ... });
});

-- R.

On 12 October 2011 10:31, Marco Megna ilme...@gmail.com wrote:

 I have problem on the same thing.

 here my code, what's wrong?

 -

 google.load('visualization', '1.1', {'packages':['controls']});
 google.setOnLoadCallback(drawDashboard);

 function drawDashboard() {

 var dashboard = new google.visualization.Dashboard(
   document.getElementById('dashboard'));

 var data = new google.visualization.DataTable();
  data.addColumn('number', 'ID');
 
  data.addColumn('number', 'Peso');
  data.addRows([...some rows...]);

 var table = new google.visualization.ChartWrapper({
 'chartType': 'Table',
 'containerId': 'table',
 'options': {
   'width': 'automatic'
 },
  'view': {'columns': [1,...,10]}
 });

 google.visualization.events.addListener(table, 'ready', onReady);

 var titoloPicker = new google.visualization.ControlWrapper({
 'controlType': 'CategoryFilter',
 'containerId': 'control4',
 'options': {
   'filterColumnLabel': 'Nome',
   'ui': {
 'labelStacking': 'vertical',
 'allowTyping': false,
 'allowMultiple': false
   }
 }
   });

 (... other ControlWrapper)

 var chart = new google.visualization.ChartWrapper({
   'chartType': 'BarChart',
   'containerId': 'chart1',
   'options': {
 'width': 600,
 'height': 600,
 'chartArea': {top: 0, right: 0, bottom: 0}
  },
   'view': {'columns': [2,10]}
 });

   ...(other dashboard.bind)
   dashboard.bind(titoloPicker, [chart, table]);
   dashboard.draw(data);

   function onReady() {
  google.visualization.events.addListener(table.getChart(), 'sort',
  function(event) {
 data.sort([{column: event.column, desc: !event.ascending}]);
  dashboard.draw(data);
   });
  }
 }

 --
 You received this message because you are subscribed to the Google Groups
 Google Visualization API group.
 To view this discussion on the web visit
 https://groups.google.com/d/msg/google-visualization-api/-/CuXKGpWx9P0J.

 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] cssClass for ControlWrapper

Hi there,
just a quick temporary answer to let you know that I'm working on an
exhaustive answer, I just didn't have enough time to put it together so far.
I hope to be able to do it tomorrow, I'll update the post when I have
something to show.

In the meantime, you can use your browser web-inspector to look at the DOM
elements that ControlWrappers generate and start from there. We have kept
the CSS classes of each generated DOM element fairly explicit exactly to
make styling easy and let you adapt controls to your own pages.

-- R.

On 10 October 2011 18:58, fgrayli fgra...@gmail.com wrote:

 Can anyone provide any documentation about the format of the Custom
 Style Sheet for different type of the ControlWrappers?
 something like this that we are using for Table:
 cssClassNames = {
'headerRow':'header-row bold-font font',
'headerCell':'header-cell font',
'tableRow':'table-row',
'tableCell':'table-cell font',
'selectedTableRow':'selected-row',
'oddTableRow':'odd-rows',
'hoverTableRow':'hover-row'
};



 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] When updating a chart with Ajax, how can I prevent the page to scroll up back to the chart being updated?

Hi David,
can you provide some extra info about the visualization you're using and/or
an example page showing the problem?

I created this quick example: http://jsfiddle.net/7JLQ3/1/ that contains a
chart placed in the middle of a very long page, updating every 5 seconds. I
can't reproduce your problem: when the chart redraws the scrolling position
is unaffected.

-- R.

On 2 October 2011 23:17, Julian King hoolm...@gmail.com wrote:

 Two things, first are you using the GoogleVisualizationsForDotNet that I
 published on code.google.com?  If not then i can't vouch for anyone else's
 implementation of google charts.  If you are using my wrapper class then the
 behavior you describe sounds like a postback?  I have a chart refreshing
 though AJAX and the page doesn't scroll.

 If it is my chart wrapper please send sample code.


 On Sat, Oct 1, 2011 at 2:41 AM, David Vallee davi...@gmail.com wrote:

 So I have an ajax call every seconds, grabbing some json data, and I
 have some setValues to update the datatable with the json data. At the
 moment I update the chart with the draw method, the page scrolls back
 to the chart being updated. How can I prevent this behavior?

 --
 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...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/google-visualization-api?hl=en.




 --
 Best Regards,

 Julian King
 (206) 697-4663
 hoolm...@gmail.com

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] image resolution with Intensity Map

You have already written javascript code to create the interactive chart in
the first place. Can't you just embed it in your website so your visitors
will get the full interactive chart (including the tooltip effect you
mention) instead of just a picture? Wouldn't it be preferable?

--R.
On Oct 3, 2011 12:46 PM, marco grazzi marco.gra...@gmail.com wrote:

 thanks a lot, it works great.

 Apologigies, for my IT ignorance ... is it possible to post the picture
 (with the nice feature that when the mouse is on a country you can see the
 actual value) on my website?



 2011/10/2 Riccardo Govoni ☢ battleho...@gmail.com

 Have a look at the Geochart.
 http://code.google.com/apis/chart/interactive/docs/gallery/geochart.html

 It should fulfill your needs and allow larger resolutions. However, it
 renders as SVG, which makes its saving as image tricky.

 Regarding credit, you're not required to, but it is certainly appreciated
 if you want to point out which technology is powering your charts.

 --R.
 On Oct 2, 2011 2:37 PM, marco grazzi marco.gra...@gmail.com wrote:

 --
 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...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/google-visualization-api?hl=en.




 --
 LEM-Scuola Superiore Sant'Anna
 Piazza Martiri della Liberta', 33
 56127 Pisa, Italy
 Tel. +39-050-883341 Fax +39-050-883344
 Web site: https://mail.sssup.it/~grazzi

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] image resolution with Intensity Map

Ignore the latter link. That refers to visualizations that are shipped as
'gadgets', for examples the ones you can have embedded in Google
spreadsheets or iGoogle.

How to put your html page on your website depends on which platform is
serving your website. If you are managing the website on your own, for
example by managing a webserver like Apache or IIS, it should be enough to
put the html page containing the chart in the document root of your website.
If your website is hosted on some other platform, like Wordpress, you could
look into your hosting documentation on how to add raw html content to it.
Wordpress, for example, has plugins that let you add raw html content to
your blog, which you can use to add the chart code (I'm not a wordpress
expert, so other simpler options might exist as well).

-- R.

On 3 October 2011 14:51, marco grazzi marco.gra...@gmail.com wrote:

 Yes, that's preferable. The problem I'm struggling with is how to embed the
 picture...
 I looked here

 http://code.google.com/apis/chart/interactive/faq.html#policy

 and in particular

 http://code.google.com/apis/chart/interactive/faq.html#embedwebsite

 But I m not getting the thing to work. Does the following apply to my case?

 On any other web page, if you have access to the source code, paste the
 XML of the gadget wrapped inside an iframe on the page. Be sure to set the
 data source preference in the XML.

 What should I exactly put in the .html file of the webpage I want to show?
 How do i set this XML thing?





 2011/10/3 Riccardo Govoni ☢ battleho...@gmail.com

 You have already written javascript code to create the interactive chart
 in the first place. Can't you just embed it in your website so your visitors
 will get the full interactive chart (including the tooltip effect you
 mention) instead of just a picture? Wouldn't it be preferable?

 --R.
 On Oct 3, 2011 12:46 PM, marco grazzi marco.gra...@gmail.com wrote:

 thanks a lot, it works great.

 Apologigies, for my IT ignorance ... is it possible to post the picture
 (with the nice feature that when the mouse is on a country you can see the
 actual value) on my website?



 2011/10/2 Riccardo Govoni ☢ battleho...@gmail.com

 Have a look at the Geochart.
 http://code.google.com/apis/chart/interactive/docs/gallery/geochart.html

 It should fulfill your needs and allow larger resolutions. However, it
 renders as SVG, which makes its saving as image tricky.

 Regarding credit, you're not required to, but it is certainly
 appreciated if you want to point out which technology is powering your
 charts.

 --R.
 On Oct 2, 2011 2:37 PM, marco grazzi marco.gra...@gmail.com wrote:

 --
 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...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/google-visualization-api?hl=en.




 --
 LEM-Scuola Superiore Sant'Anna
 Piazza Martiri della Liberta', 33
 56127 Pisa, Italy
 Tel. +39-050-883341 Fax +39-050-883344
 Web site: https://mail.sssup.it/~grazzi

 --
 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...@googlegroups.com.
 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
 google-visualization-api@googlegroups.com.
 To unsubscribe from this group, send email to
 google-visualization-api+unsubscr...@googlegroups.com.
 For more options, visit this group at
 http://groups.google.com/group/google-visualization-api?hl=en.




 --
 LEM-Scuola Superiore Sant'Anna
 Piazza Martiri della Liberta', 33
 56127 Pisa, Italy
 Tel. +39-050-883341 Fax +39-050-883344
 Web site: https://mail.sssup.it/~grazzi

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization

Re: [visualization-api] Remove default popups on mouseover event

Try the 'enableInteractivity' flag as described here:
http://code.google.com/apis/chart/interactive/docs/gallery/columnchart.html

-- R.

On 3 October 2011 22:44, Raghu raghav.go...@gmail.com wrote:

 Hi All

 I'm using Column charts and Pie charts.
 Was looking to see if we can remove/hide the popups which appear on
 hover.
 Found some posts which says its not possible but wanted to confirm.

 Thanks
 Rag

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] image resolution with Intensity Map

2011-10-02 Thread Riccardo Govoni ☢

Have a look at the Geochart.
http://code.google.com/apis/chart/interactive/docs/gallery/geochart.html

It should fulfill your needs and allow larger resolutions. However, it
renders as SVG, which makes its saving as image tricky.

Regarding credit, you're not required to, but it is certainly appreciated if
you want to point out which technology is powering your charts.

--R.
On Oct 2, 2011 2:37 PM, marco grazzi marco.gra...@gmail.com wrote:

-- 
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...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Merging 2 datatables with identical columns

2011-09-29 Thread Riccardo Govoni ☢

Could you write them out using the
ToJSonhttp://code.google.com/apis/chart/interactive/docs/dev/gviz_api_lib.html#tojsonexample
instead
of ToJSonResponse ? This would serialize a plain json object for each
datatable. In the browser, you could load these json objects, easily merge
them together (join their 'rows' array together, assuming the columns'
definitions are the same) and create a single datatable out of the joined
json payload.

-- R.

On 28 September 2011 21:29, Elco Jacobs elcojac...@gmail.com wrote:

I am generating datatables in a python script on a DD-WRT router. The
script will generate datatables of up to 5000 rows. The memory on the
router is limited, so the datatables grow too large and the router
crashes.
To prevent this from happening, I want to create a new datatable each
day and write these to separate JSON response files with
datatable.ToJSonResponse().

When a page is loaded in a web browser, these JSON response files have
to be loaded and combined into one chart in javascript.

I can iterate over the JSON response files and read them into
datatables, but I cannot find a way to append one datatable to
another.

The addRows() function is almost what I need, but it cannot accept an
entire datatable as input.

Can anybody help me on how to merge the two datatables into one
datatable so I can create a combined chart?

--
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...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Changing default settings for each chart. Motion Chart

2011-09-29 Thread Riccardo Govoni ☢

I don't think the motionchart was ever designed to let you tweak its state
at runtime. According to this
paragraphhttp://code.google.com/apis/chart/interactive/docs/gallery/motionchart.html#Motion_Chart_initial_state
the
state should be treated as a sort of black box which you configure once.

To still do what you're trying to, you could listen for
statechangehttp://code.google.com/apis/chart/interactive/docs/gallery/motionchart.html#Eventsevents.
When they fire, extract the current state from the motionchart,
parse it to figure out if the chart turned into a BUBBLE one, tweak the
state setting the xAxisOption as you need it and redraw the motion chart
with the altered state. Being a flash chart, I suspect the redraw might
cause some ugly flickering, though.

-- R.

On 29 September 2011 05:43, Cristian cristian.iban...@gmail.com wrote:

Hi,
I am using options['state'] to set my default setting in my Motion
Chart visualization. [VBAR, _UNIQUE_COLOR, _ALPHABETICAL, etc] {that
part is working great}

When I select a BUBBLE graph instead of a BAR graph I want it to
default to xAxisOption:_TIME. I am at a lost here. I have no idea
where to begin to look
.
I'm thinking that there might be a way to add a listener to know when
a different graph is selected and then assign the defaults o force the
property I need then, but I can't find anything about it.

I would appreciate any help you guys give me or point me in the right
direction.

Thanks,

-Cristian

PS: I'm loading my points from a CSV file. In Mozilla, Safari, Chrome
everything works, but when I try it in IE nothing... any ideas? I'm
posting this question in another thread.

--
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...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Reliability for using Google Charts

2011-09-27 Thread Riccardo Govoni ☢

Your reference should be the Terms of Service (
http://code.google.com/apis/chart/interactive/terms.html).

For example, regarding Will Google Chart disappear some day? , I think the
most exhaustive answer is section 4, in particular 4.5 where the 3 year
deprecation notice is defined.

When making your decision, you should also be aware of the release
processhttp://code.google.com/apis/chart/interactive/docs/release_notes.html#ReleaseProcessGoogle
Charts API uses. The way it's currently shaped has been extensively
discussed in this forum recently because it puts pressure on the developer
(you) to keep pace with it : your charts always serve from a 'stable' API
version (the so called v1.0) and you have 2 a week window, between the time
a new release is announced and the time it hits production, to verify your
charts (and upgrade them if required by API changes) and notify us in the
forums of any bugs you may spot. This has occasionally led to bugs reaching
production. Releases come out on a monthly base, roughly.

We are making changes to said process to better accommodate users needs, but
they're not in place yet, so the above process still applies.

-- R.

On 27 September 2011 07:28, R the V rsdev...@gmail.com wrote:

Dear Google employees or API users,

i'm looking for a Chart API which can be used for commercial goals.
When i take a look at the Google Chart API i see a very nice tool with
many functions which i could use for my graphical dashboard, though i
foresee some problems in the futere. I'm willing to build a dashboard
system with many charts, connected to data contained in a database. My
concern is that i'm dependent on Google API. The TOS is not allowing
to use the files locally.

I simply can't guarantee uptime to my customers if the API disappears
in a few years, or the API isn't available for hours per week.

So the questions i have:
- Is the API reachable all time of day? How about the uptime?
- Will Google Chart disappear some day?

--
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...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] NumberRangeFilter min/max values

2011-09-27 Thread Riccardo Govoni ☢

Sounds like a CSS presentation bug. Can you force a min-width or equivalent
on the slider_div that contains the slider (or any of its parent
containers)? That should fix it.

-- R.

On 27 September 2011 17:31, datam...@yahoo.com datam...@yahoo.com wrote:

 Whenever I use a NumberRangerFilter with the default horizontal
 orientation both values (min  max) appear vertically above and below
 the left (minimum) end of the slider rather than to the left (minimum)
 and right (maximum) like the examples.  I am currently forcing the
 vertical orientation for the numbers to locate correctly, I have been
 unable to find an option or property to correct this issue?  Below is
 a snippet of html I am using, minus the 'ui': {'orientation':
 'vertical'} I am currently using.  What am I missing to display the
 slider horizontally with values to the left and right?

 Thanks,
 Mike

 
 // Create a dashboard
 var dashBoard = new google.visualization.Dashboard(
 document.getElementById('dashboard_div'));

 // Create a range slider, passing some options
 var Control = new google.visualization.ControlWrapper({
  'controlType': 'NumberRangeFilter',
  'containerId': 'slider_div',
  'options': {
 'filterColumnIndex': 1,
 'minValue': 0,
 'maxValue': 28,
  },
 'state': {'lowValue': 15, 'highValue': 28}
 });

 // Create a chart, passing some options.
 var Chart = new google.visualization.ChartWrapper({
'chartType': 'BarChart',
'containerId': 'chart_div',
'options': {
'width': 780,
'height': 440,
'hAxis': {'minValue': 0, 'maxValue': 28},
'chartArea': {top: 0, right: 0, bottom: 0},
'legend': 'none',
'is3D': true,
'min': 0
 }
 });

 dashBoard.bind(Control,Chart);
 dashBoard.draw(ChartData);

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Re: arrow formatting with google docs info

Would something like this be good enough?

https://docs.google.com/spreadsheet/ccc?key=0Av88pFrCTjLhdFhqMVVTZzZJdWYtT0lYTTV3elpseEEhl=en_GB

I used a combination of spreadsheet functions, unicode characters and
conditional formatting.

First I defined a
functionhttps://docs.google.com/support/bin/static.py?page=table.cstopic=25273that,
depending on the comparison of 2 cells (this week vs last week),
produces an up arrow or a down arrow:

=IF(B2A2, ⇧, ⇩)

For the arrow themselves, I used two unicode arrow
symbolshttp://en.wikipedia.org/wiki/Arrow_(symbol)
.
Last I applied some conditional formatting to the column, specifying that
the font color should be green if the cell contains an up arrow, and red
otherwise.

-- R.

On 26 September 2011 08:35, eric engen engen1e...@gmail.com wrote:

i'd rather have it show up in google docs but if their's only a way
(and i've noticed that there is a possibility to publish said
document to the net for free) to do this with an online document that
thats just what i'll have to deal with.

thanks again

On 25 ספטמבר, 20:55, ChartMan chart...@google.com wrote:
Do you need this table with arrows to show up in Docs or just in a web
page?

On Sep 25, 2011 4:44 PM, eric engen engen1e...@gmail.com wrote:

hi and thanks in advance to any and everyone who will take the time to
answer my question.

at the firm i work in we use google docs a lot and i would like to
have somekind of script or something that will show me a small up/down
arrow for different cells by comparing them to a value from last
week( i have a sheet for every week of the month)

if i wasnt clear enough then: last week say my new york shop sold
5000$ of goods and this week 3000$ of goods and i want to have a small
red arrow indicating that the sale of the new york store has gone down
as opposed to last week

thank you for any help' im not a programmer but i know my way around
computers and i believe with just a few small nudges in the right
direction i will get the results i need

--
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...@googlegroups.com. 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Using Google Chart API in chrome extension

2011-09-26 Thread Riccardo Govoni

I explored the topic a bit more. Here are the findings.

For charts that use iframes (such as LineChart and most of the 'corechart' 
package, which renders its SVG contents into an iframe created inside the 
chart container element you specify) there are some limitations in the code 
that prevent the rendering to occur correctly when the chart code is loaded 
in a different Window than the one where the chart is placed (as it happens 
here, where the code is loaded in the background page and the chart is 
rendered in the popup page, and as it may happen in other multi-frame 
scenarios).

Also, for charts that rely on additional resources (such as the Table 
visualization, which loads a style CSS file on the fly when used) such 
resources as well appear to be added to the Window where the code executes 
(the background page) rather than the Window where the chart is placed (the 
popup), resulting in either a non-working or un-styled visualization 
(depending on the loaded resources).

So I'd say that for the moment, the trick of loading the chart API in the 
background page to speed up the rendering of the extension popup is a no-go.

-- R.

-- 
You received this message because you are subscribed to the Google Groups 
Google Visualization API group.
To view this discussion on the web visit 
https://groups.google.com/d/msg/google-visualization-api/-/am6ZkYD0eVkJ.
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...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Re: arrow formatting with google docs info

If the input data are in a separate sheet of the same Google document, then
you can still use the same logic. The function just changes to reference a
different sheet:

=IF(Sheet1!B2Sheet1!A2, ⇧, ⇩)

I have updated the document to contain the same arrows in Sheet2,
referencing the contents of Sheet1.

Or am I missing something?

The ArrowFormatter you found is useful if you accept to put your data inside
a 
Tablehttp://code.google.com/apis/chart/interactive/docs/gallery/table.htmlvisualization
and host the visualization in a webpage, separate from your
spreadsheet (I don't think there's a way to use formatters when embedding
visualizations as gadgets inside a spreadsheet, unless you're willing to
roll out some code of your own to do so).

-- R.

On 26 September 2011 13:00, eric engen engen1e...@gmail.com wrote:

 its a pain of a workaround 'cause i really need the function to draw
 its info from another sheet(within the same document)

 i found this

 http://code.google.com/intl/iw-IL/apis/chart/interactive/docs/reference.html#arrowformatter
 but i have no idea how to use it

 On 26 ספטמבר, 14:52, ChartMan chart...@google.com wrote:
  Reading my mind :-)
  On Sep 26, 2011 12:28 PM, Riccardo Govoni ☢ battleho...@gmail.com
 wrote: Would something like this be good enough?
 
  https://docs.google.com/spreadsheet/ccc?key=0Av88pFrCTjLhdFhqMVVTZzZJ...
 
   I used a combination of spreadsheet functions, unicode characters and
   conditional formatting.
 
   First I defined a
   function
 
  https://docs.google.com/support/bin/static.py?page=table.cstopic=25273
 
 
 
  that,
   depending on the comparison of 2 cells (this week vs last week),
   produces an up arrow or a down arrow:
 
   =IF(B2A2, ⇧, ⇩)
 
   For the arrow themselves, I used two unicode arrow
   symbolshttp://en.wikipedia.org/wiki/Arrow_(symbol)
   .
   Last I applied some conditional formatting to the column, specifying
 that
   the font color should be green if the cell contains an up arrow, and
 red
   otherwise.
 
   -- R.
 
   On 26 September 2011 08:35, eric engen engen1e...@gmail.com wrote:
 
   i'd rather have it show up in google docs but if their's only a way
   (and i've noticed that there is a possibility to publish said
   document to the net for free) to do this with an online document that
   thats just what i'll have to deal with.
 
   thanks again
 
   On 25 ספטמבר, 20:55, ChartMan chart...@google.com wrote:
Do you need this table with arrows to show up in Docs or just in a
 web
   page?
 
On Sep 25, 2011 4:44 PM, eric engen engen1e...@gmail.com wrote:
 
 hi and thanks in advance to any and everyone who will take the
 time
  to
 answer my question.
 
 at the firm i work in we use google docs a lot and i would like to
 have somekind of script or something that will show me a small
  up/down
 arrow for different cells by comparing them to a value from last
 week( i have a sheet for every week of the month)
 
 if i wasnt clear enough then: last week say my new york shop sold
 5000$ of goods and this week 3000$ of goods and i want to have a
  small
 red arrow indicating that the sale of the new york store has gone
  down
 as opposed to last week
 
 thank you for any help' im not a programmer but i know my way
 around
 computers and i believe with just a few small nudges in the right
 direction i will get the results i need
 
 --
 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...@googlegroups.com. 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
   google-visualization-api@googlegroups.com.
   To unsubscribe from this group, send email to
   google-visualization-api+unsubscr...@googlegroups.com.
   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
 
  google-visualization-api@googlegroups.com. To unsubscribe from this
 group, send email to
 
  google-visualization-api+unsubscr...@googlegroups.com. 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

Re: [visualization-api] Re: categoryPicker filterColumn for AnnotatedTimeLine

I understand you're trying to perform column-based filtering on the series
your annotated timeline will display.
This is not directly supported by the 'controls' API (which was initially
designed for row-based filtering) but there are workarounds for this.

Have a look at this thread where I discussed the same issue:
https://groups.google.com/d/topic/google-visualization-api/fhwUv_QKfWA/discussionand
proposed a working example.

Also consider that the 'controls' API at the moment works fully client-side
(you have to load the entire table and the controls take care of selecting
the right views based on user input ).

We are currently collecting usage feedback while the api is still marked as
'experimental' , so if you have a specific scenario, feel free to describe
it (as said, we're already aware that column filtering would be nice to
have).

-- R.

On 23 September 2011 17:29, asgallant drew_gall...@abtassoc.com wrote:

 The frequency of querying also comes into play.  If users are going to end
 up viewing most, if not all, of the columns in a single session, then query
 once and be done with it.

 --
 You received this message because you are subscribed to the Google Groups
 Google Visualization API group.
 To view this discussion on the web visit
 https://groups.google.com/d/msg/google-visualization-api/-/RW5HHfEIl8EJ.

 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Dashboard with two related datasources and charts.

So you want  a set of controls on dashboard 1 to drive the contents (filters
and charts) of a second dashboard, and the two dashboards are fed with
different datatables, right ?

If so, there isn't a pre-cooked way of joining together the two, because of
the nuances of 'translating' the filtering criteria defined by the filters
in dashboard1 into an equivalent filtering operation over dashboard2, which
is however populated by a different datatable that may be structurally
different.
Citing your post, the key operation is disambiguate what related means in
another datasource that contains related information.

That said, are a couple of ways in which you can accomplish this. For
example:

- you populate each dashboard separately, having each dashboard query its
own datasource.
- whenever a control in dashboard1 fires a 'statechange' event (indicating
it received user interaction), you manually filter the datatable that powers
dashboard2 and then call dashboard2.draw(datatable) again, forcing
dashboard2 to align itself to the filters' status in dashboard1.

Alternatively:

- you create, in dashboard2, a set of 'hidden' controls that mimic those of
dashboard1 that you want to affect the second dashboard, and you wire
together controls from the first dashboard to propagate their state to
controls of the second.

Have a look at this example: https://gist.github.com/1242360 . I create 2
dashboards. The first contains a 'stringfilter' on the Name column. The
second one contains another stringfilter, but on a different column (Fruit)
and I keep it hidden via a display:none style. When the user interacts with
the former, I propagate the change to the latter via:

google.visualization.events.addListener(control1, 'statechange', function() {
  control2.setState(control1.getState());
  control2.draw();
});

The end result is that the same filtering criteria the user entered on the
first dashboard, is applied to the second as well.

Does this resemble what you're trying to achieve?

-- R.


On 23 September 2011 00:45, Onno Benschop o...@itmaze.com.au wrote:

 Before I start coding I'm trying to get my head around how this is
 intended to hang together. Links and/or sample code would be a bonus,
 but really I'm trying to get it.

 I have a working Dashboard that uses a datasource to draw controls, a
 map and a table (and thanks to this forum, you can now click on the
 table and highlight the map and vice versa). I started with the
 Airport, Country, Region, City example and took my lead from there.

 I have another datasource that contains related information that I'd
 like to display in the same Dashboard in such a way that the existing
 controls also affect the filters of the second datasource and its
 charts.

 I could make another handleQueryResponse() handler and link the two
 with onReady eventListeners, but that seems clunky, given that there
 are join() and bind() functions which clearly give you the notion that
 you can join two tables and deal with the result.

 Alternatively, in my initialization handler I could fire off another
 query - to my second datasource, have it be handled by the original
 handleQueryResponse() handler and somehow (since this is asynchronous)
 join that to the other datasouce, or should this be dealt with in
 another way?


 How is this expected to be glued together?

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Re: categoryPicker filterColumn for AnnotatedTimeLine

When you said The categories that I want to filter on are in fact the
column headers I thought you wanted to use a CategoryFilter to decide
which columns to retain of the input DataTable. Is that correct ?

If so, can't you operate this way: Given the input datatable,

- extract all column headers from it
- create a CategoyFilter and use the extracted column headers for its '
valueshttp://code.google.com/apis/chart/interactive/docs/gallery/controls.html#categoryfilter'
option. This will let you pick among column headers.
- forget the filterColumnIndex parameter as said in the other thread.
- listen for statechange events. Once one comes in, use getState() to get
which column headers the user has picked, map them to column positions,
create a suitable view and feed it to the Annotated timeline as shown in the
other thread.

Granted, it's still a workaround that only partially uses the API, so it's
debatable whether it's better or not than rolling your own custom thing, but
doesn't it do the job?

Or are you trying to do something different by populating the CategoryFilter
with all the contents of a specific column?

-- R.

On 26 September 2011 16:40, Dan daniel.duff...@gmail.com wrote:

Hi Riccardo,

I can see what you have done, but think this only works for using the
slider. You mention in the other thread that you have to specify a
filterColumnIndex
as it is mandatory but it won't be used. However as I want to use the
controlPicker control and this will make use of the filterColumnIndex
value, as all the values in the dropdown box will still be that of the
column rather than the contents of the header row.

I think I'll have to build my own control until the ability to use control
filters to filter columns rather than just rows is available. Do you think
this is something that will be available in a later release?

One other thing, I should probably create a new thread for it. Is the Query
Language likely to be able to join between multiple tables in the future?

Thanks,
Dan

--
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...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Character limits on visualization header with Fusion Table

This was discussed recently. It's a bug on fusion tables side. Have a look
at this thread (
https://groups.google.com/forum/#!topic/google-visualization-api/MG4kurSZr5s)
for info on the bug and how to track it.

--R.
On Sep 26, 2011 9:23 PM, Jonathan jpdp...@gmail.com wrote:
 I'm trying to populate a table visualization with information from a
 Fusion Table, but I'm noticing that the column heads have a 10
 character limit. I have more than 10 characters in my heads, and it
 looks like Google has the same problem on their example 

http://gmaps-samples.googlecode.com/svn/trunk/fusiontables/gviz_datatable.html
 ('Scoring Te' instead of 'Scoring Team')

 How do i increase the number of characters shown in those table
 headers?

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Chart affecting other css on the page

The issue is not with the chart, but with the CSS structure of the page.

Since your menu uses a float:left, it does not affect sizing of the other
block level elements you have on the page. Therefore your #chart_div div
(where the chart is placed) is allowed to span the entire width of the page
(although its contents will obviously respect the float and be arranged
around it). Since the #chart_div is placed after the menu in the html
structure of the page, it ends up sitting above the float, hence stealing
the hover event. You can verify it by using Firebug or the Chrome element
inspector to analyze the layout structure of the page.

You can fix it by adding 'margin-left: 7em' to your chart_div (or something
equivalent), placing the chart_div inside a table (because the table will
respect the float in its positioning) or marking the chart_div itself as
float:left (hence forcing its left margin to not expand past the right
margin of the menu).

-- R.

On 24 September 2011 22:33, Gavin qofdatab...@googlemail.com wrote:

 I have a menu in a div which floats to the left of the chart. The menu
 uses css hover to change colour when the mouse is over it.
 This works unless it is on the same horizontal level as the chart.
 See http://www.mythic-beasts.com/~gjamie/test.html

 This behaviour is the same in Firefox and Chrome. Surely the chart
 code should not spill out of its div?

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Missing Gauge Chart features

Hi Tigro,
can you better clarify which features you are missing? I think all your
requirements are supported. Look at this example:

http://savedbythegoog.appspot.com/?id=ef4e85c6d294dc143f49e1e16b75aa2f7027b6eb
(view the source code of it for the actual options I used).

which uses a custom -30 - 50 scale and custom markers for green, yellow and
red ranges. Isn't that what you need?

-- R.

On 23 September 2011 20:54, Tigro bart.boela...@gmail.com wrote:

 Hi,

 I'm using the Google Gauge Chart in my home monitoring project for
 displaying temperatures and humidities of various rooms.
 While playing with the Google Gauge API, I stumbled across the
 following missing features :
 - ability to provide a scale (minimum and maximum value)
 - numbers provided should follow the scale
 - numbers given to green from/to, yellow from/to and red from/to
 should follow the scale
 - ability to provide negative numbers

 e.g. for temperatures, I would like to present a scale from -30°C to
 50°C. When supplying a temperature value of 20, the arrow should point
 to 20.

 I hope the guys at Google implement these features in one of their
 next revisions.

 Kind regards,


 Bart.

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] DataTable - Header row

I'm sorry but I don't think the Table visualization allows for this kind of
header formatting (having an header spanning multiple rows, with sub-headers
as you describe).

--  R.

On 23 September 2011 19:01, Bharat bcrupa...@yahoo.com wrote:

 Is there any way to be able to format the Header rows for a DataTable?

 Here is the scenario:  I have Base Volume for Oil and Base Volume for
 Gas.  In an HTML table, I can easily merge columns to put the Base
 Volume up Top and then Oil and Gas below.

 |Base Volume|
 -
 |  Oil   |   Gas  |

 This allows me to shrink the width of Oil and Gas columns each so that
 I can display more data without have to do horizontal scrolling.

 Thanks.

 Bharat

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Using Google Chart API in chrome extension

I played with this for a few minutes. As you suggest, I try loading the api
in the background page (so this happens only once), and then access it in
the popup page via:

var background = chrome.extension.getBackgroundPage();

'background' now points to the window object of the background page, so you
can access the Google Visualization api, for example:
background.google.visualization.DataTable.

You can see an example at https://gist.github.com/1240641.

The issue I face is that the chart that is created in the popup window is
empty. More specifically, the chart rendering process creates an iframe
(where the chart svg is placed) and said iframe appears to be empty.

I tried a few alternatives, but in all cases I end up with an empty iframe:
- executing the draw code in background page context, but pointing to the
popup page DOM via chrome.extension.getViews({type: popup})[0]
- drawing in the background page and then copying the created chart in the
popup page via cloneNode().

I don't have much time right now to follow up, but I suspect the charts code
fails drawing when the document hosting the target chart container is not
the same document which hosts the API (although I couldn't find any specific
js errors while debugging). Alternatively, there could be restrictions in
the chrome extensions model to prevent popup page accessing the contents of
iframes created by the background page (although this seems likely, if I
know chrome extensions well enough).

I'll try to look a bit further into this if I have time, in case nobody
picks this up before.

-- R.

On 22 September 2011 06:01, Andrey andrey.skladchi...@gmail.com wrote:

 Hello. i using a Google Chart API in my chrome extension popup page.
 But it is unuseful that api loading every time popup showing. Can i
 and how i can load API script in background page and call it from
 popup page to increase popup open speed?

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Data table for a large database_table

How large is your database table?
The usual limitation comes from the fact that the Google Visualization API
is a Javascript API, hence you can't store huge amounts of data on any
Javascript datastructures (be it a google.visualization.DataTable or a plain
JSON object) before the browser starts to suffer and slow down.

You may achieve different results depending on the browser/platform
combination, but from my experience datasets of a few hundred thousands
cells (say, a datatable with 20K rows and 10 columns) are the threshold at
which the performances start to fall apart. The bottleneck depends on the
browser and it may be on raw javascript parsing speed, memory consumption or
DOM manipulation speed. Some browsers (for example, old versions of IE, or
mobile browsers) fall apart way before that limit, and even a few thousand
cells are enough to cause trouble.

Another issue you might want to consider is the byte size of such table and
how long it would take to transfer it to the client on typical network
bandwidths.

Depending on your needs, sometime is better to go for specialized
datastructures tailored for your case. This one is an example of a very
specific case of datastructure specialization:
http://ejohn.org/blog/javascript-trie-performance-analysis/

-- R.

On 23 September 2011 07:30, orkun ahmettemi...@gmail.com wrote:

 hello

 I was wondering whether it was possible to use Google Visualization
 API -data table
 for a large database_table.

 Or do you recommend another one ?

 regards

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Re: Dashboard - addListener 'select' - not working

I think you are attaching the 'ready' listener to the wrong object. Your
line reads:

google.visualization.events.addListener(*visualization*, 'ready', onReady);

But I'm not sure what 'visualization' points to. Instead you should attach
the listener to the dashboard, and for this you have to assign the
google.visualization.Dashboard instance to an object.

var *dashboard* =
new google.visualization.Dashboard(document.getElementById('dashboard'));
dashboard.bind(CyPicker, [TmPicker, NrPicker, TrPicker]).
   bind(TmPicker, [map1, table1, chart1]).
   draw(data);

google.visualization.events.addListener(*dashboard*, 'ready', onReady);
function onReady(...) {
  ...
}

The above code reads: when the dashboard is ready (aka, it has completed
drawing at least once and hence all the controls and charts part of it are
guaranteed to exist), then you attach selection handlers.

Does it make sense?
-- R.

On 23 September 2011 00:27, Onno Benschop o...@itmaze.com.au wrote:

 That worked a treat.

 The code now looks like this:

new
 google.visualization.Dashboard(document.getElementById('dashboard')).
bind(CyPicker, [TmPicker, NrPicker, TrPicker]).
bind(TmPicker, [map1, table1, chart1]).
draw(data);

google.visualization.events.addListener(table1, 'select', function()
 { map1.getChart().setSelection(table1.getChart().getSelection()); });
google.visualization.events.addListener(map1, 'select', function()
 { table1.getChart().setSelection(map1.getChart().getSelection()); });



 While investigating I did some experimentation with the 'ready'
 listener for the Dashboard, but that didn't work as expected (I got an
 error about a being null). I came across the documentation that said
 that I should use this method because there was no guarantee that the
 listener could be added if the Dashboard wasn't ready. The document is
 here:


 http://code.google.com/apis/chart/interactive/docs/reference.html#chartwrapperobject

 The actual error I got was:
 Error: a is undefined
 Source File:

 http://www.google.com/uds/api/visualization/1.0/cd9282b3113b5d80b6043070ddbc00e4/default,map,controls,table,corechart.I.js
 Line: 282

 The code that generated that error was:
 new
 google.visualization.Dashboard(document.getElementById('dashboard')).
bind(CyPicker, [TmPicker, NrPicker, TrPicker]).
bind(TmPicker, [map1, table1, chart1]).
draw(data);

 google.visualization.events.addListener(visualization, 'ready',
 onReady);

function onReady() {
google.visualization.events.addListener(table1, 'select',
 function()
 { map1.getChart().setSelection(table1.getChart().getSelection()); });
google.visualization.events.addListener(map1, 'select',
 function()
 { table1.getChart().setSelection(map1.getChart().getSelection()); });
}

 Note that I also tried with a different variable scope, I defined both
 map1 and table1 in the global scope, unlike in the working code at the
 beginning of this message where the scope of map1 and table1 are
 within my handleQueryResponse() handler.

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Re: Dashboard - addListener 'select' - not working

Try binding the 'ready' event listener before you draw the dashboard:

var dashboard = new google.visualization.Dashboard();
google.visualization.events.addListener(dashboard, 'ready', function() {});
dashboard.bind().bind().bind().draw(data);

(I suspect the 'ready' event coming out of draw() might fire before you
attach the handler to it, which may happen in some conditions).

If that doesn't work, I really need to have access to a sample page
containing your dashboard to debug it to figure out what's going wrong.

-- R.

On 23 September 2011 12:05, Onno Benschop o...@itmaze.com.au wrote:

 I appreciate your insight and I understand what you're saying. It
 turns out that the visualization variable came from the original
 sample code and it wasn't being used at all ;) I replaced it with
 dashboard, instantiated it instead of creating an anonymous object,
 then attached the listener to the dashboard variable. Same error.

 I also tried using an anonymous function in the 'ready' addListener,
 with no effect.

 The documentation I referred to in my previous message tells me that
 what I'm doing is wrong and tells me that my code won't be called, but
 I'm not seeing that. I wonder if the reason it's working for me is
 that I'm not calling an external function, but an anonymous one in my
 addListener like this works:

 google.visualization.events.addListener(table1, 'select', function()
 { map1.getChart().setSelection(table1.getChart().getSelection()); });


 And this doesn't work:

 dashboard = new
 google.visualization.Dashboard(document.getElementById('dashboard')).
bind(CountryPicker, [TeamPicker, NearPicker, TrailorPicker]).
bind(TeamPicker, [map1, table1]).
draw(data);

 google.visualization.events.addListener(dashboard, 'ready', function()
 {
google.visualization.events.addListener(table1, 'select', function()
 { map1.getChart().setSelection(table1.getChart().getSelection()); });
google.visualization.events.addListener(map1, 'select', function()
 { table1.getChart().setSelection(map1.getChart().getSelection()); });
 });

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] How to change the color of Row Header

Have a look at cssNames option, as described in the documentation (
http://code.google.com/apis/chart/interactive/docs/gallery/table.html )
which lets you assign a specific CSS style both to the header row and header
cells. You can then apply the color scheme of your choice to that CSS class.

-- R.

On 23 September 2011 13:50, Patel funt...@gmail.com wrote:

 How to change the background  color of Name, Height and Smokes?


 function drawVisualization() {
  // Create and populate the data table.
  var data = new google.visualization.DataTable();
  data.addColumn('string', 'Name');
  data.addColumn('number', 'Height');
  data.addColumn('boolean', 'Smokes');
  data.addRows(3);
  data.setCell(0, 0, 'Tong Ning mu');
  data.setCell(1, 0, 'Huang Ang fa');
  data.setCell(2, 0, 'Teng nu');
  data.setCell(0, 1, 174);
  data.setCell(1, 1, 523);
  data.setCell(2, 1, 86);
  data.setCell(0, 2, true);
  data.setCell(1, 2, false);
  data.setCell(2, 2, true);



  // Create and draw the visualization.
  visualization = new
 google.visualization.Table(document.getElementById('table'));
  visualization.draw(data, {allowHtml: true});
 }

 In this example:
 http://code.google.com/apis/ajax/playground/?type=visualization#table

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Interaction with Scatter Plot

At the moment the scatter plot does not offer any visual highlight for
selection events (that is, the selection is registered, but the selected
point is not visually differentiated from the others, see
https://groups.google.com/d/topic/google-visualization-api/jwLMkhwKP6c/discussion),
so plain setSelection won't work for you. Other team members might
detail
whether changes are happening in this area or not, because I'm not fully
up-to-date on this.

In the meanwhile, since the scatterplot uses a separate color for each data
serie (each datatable column) an alternative solution might be the
following:

- when a point is selected (via setSelection or by user click), identify the
correspondent datatable row and move the cell containing the point value to
a separate column (this will trigger a color change) and redraw the
visualization.
- when another point is selected, revert the previous change and apply the
previous step.

I haven't explicitly coded this, but I think it should work, although it's a
non trivial amount of helper code to write.

-- R.

On 23 September 2011 10:09, Maxim Colls collsma...@gmail.com wrote:

 Hi,

 I'm trying to interact with the Scatter Plot. What I want to do is to
 highlight / change the color of a point dynamically.

 I tried with setSelection method but it doesn't seem to work.

 Thanks,

 Màxim

 --
 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...@googlegroups.com.
 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 google-visualization-api@googlegroups.com.
To unsubscribe from this group, send email to 
google-visualization-api+unsubscr...@googlegroups.com.
For more options, visit this group at 
http://groups.google.com/group/google-visualization-api?hl=en.

Re: [visualization-api] Interaction with Scatter Plot