[visualization-api] Re: Mutiple records to Google Charts

2014-08-17 Thread Andrew Gallant
You are overwriting $rows every time though the loop: $rows = array(); Remove that line from the while loop, and it will stop overwriting. Also, you need to adjust your months by 1 to match Javascript's 0-indexed months: $month=date(m, strtotime($date)) - 1; On Saturday, August 16, 2014

[visualization-api] Re: ChartWrapper.draw() can produce a JavaScript warning in Firefox

2014-08-17 Thread Andrew Gallant
Yes, and it should pass that error. You cannot draw a chart if you do not provide the target container's ID. On Saturday, August 16, 2014 9:26:24 PM UTC-4, Nathan Whittaker wrote: In Firefox (v31), if ChartWrapper.draw() is called without the *opt_container_ref* parameter defined, the

[visualization-api] Re: ChartWrapper.draw() can produce a JavaScript warning in Firefox

2014-08-17 Thread Andrew Gallant
, this causes a JavaScript warning (not an error). Not a critical issue, but annoying. On Sunday, August 17, 2014 9:33:02 AM UTC-4, Andrew Gallant wrote: Yes, and it should pass that error. You cannot draw a chart if you do not provide the target container's ID. On Saturday, August 16, 2014 9:26:24

[visualization-api] Re: google visualization with native javascript and php

2014-08-16 Thread Andrew Gallant
Do you have a question? On Saturday, August 16, 2014 6:04:07 AM UTC-4, anuj joshi wrote: private static native void generateGraph(String stationName)/*-{ $wnd.google.load(visualization, 1.0, { packages : [ 'corechart' ], callback : drawVisualization }); function drawVisualization() { //

[visualization-api] Re: Phylograms or other branch-length-respecting trees in the the Visualization API

2014-08-16 Thread Andrew Gallant
The Visualization API does not have any tools for creating phylograms. It may be possible to simulate one using a ScatterChart, as you have noted, but by default it would not support the Newick data structure. You could probably code an algorithm to translate the Newick structure into a

[visualization-api] Re: Maintaining aspect ratio for scatterchart WITHOUT using px size units.

2014-08-16 Thread Andrew Gallant
I'd like to test this to see if I can figure out what causes it. Can you provide an example that demonstrates the effect? On Saturday, August 16, 2014 9:50:49 AM UTC-4, Bryan Maloney wrote: I did a lot of fiddling and made a discovery: The problem only exists when I do float:left! When I

[visualization-api] Re: Maintaining aspect ratio for scatterchart WITHOUT using px size units.

2014-08-15 Thread Andrew Gallant
Setting the dimensions on your div using % should work fine. If you don't specify dimensions in the chart options, the chart defaults to the size of its container. The only potential pitfall is with using % for height, as this only works when the parent of the element has an explicit height -

[visualization-api] Re: Paging for Charts !?

2014-08-15 Thread Andrew Gallant
2014 01:50:36 UTC+2 schrieb Andrew Gallant: There are no paging controls for charts. You *could* implement paging for a chart, but paging isn't very user-friendly. Have you looked at the Controls https://google-developers.appspot.com/chart/interactive/docs/gallery/controls#gallery to see

[visualization-api] Re: getFilteredRows as First Chart of Dashboard

2014-08-15 Thread Andrew Gallant
You cannot use a chart's ready event handler to draw the chart - it will loop infinitely (draw - ready - draw - ready, ad infinitum). Use a ready event handler for another chart hooked up to the same filters instead, and remove Chart1 from your Dashboard binding: // assumes Chart2 is bound to

[visualization-api] Re: Need help with TimeLine visualization - data from JSON file.

2014-08-14 Thread Andrew Gallant
Do you want to generate the JSON dynamically (like from a database query)? If you do, what is your server environment like (database, scripting or programming language, etc)? On Thursday, August 14, 2014 4:12:24 AM UTC-4, Ákos Kovács wrote: How can I generate a json file like that you have

Re: [visualization-api] Re: Table and map in same dashboard

2014-08-14 Thread Andrew Gallant
When you float the controls, you need to clear the float afterwards (otherwise, the controls end up layered underneath the table's container div, which is why they don't work). See example: http://jsfiddle.net/asgallant/t2vw2hrq/ You can clear the errors by setting up error event handlers for

Re: [visualization-api] Re: Table and map in same dashboard

2014-08-14 Thread Andrew Gallant
script. It would be great if you can figure out why it doesn't work! Thanks again! Best, Nikolaj On Thu, Aug 14, 2014 at 3:01 PM, Andrew Gallant agal...@google.com javascript: wrote: When you float the controls, you need to clear the float afterwards (otherwise, the controls end up

[visualization-api] Re: Background colors for threshold indicators on line chart (stripped ? )

2014-08-14 Thread Andrew Gallant
There are a couple of ways you can do this. You can use a ComboChart with stacked area series (example: http://jsfiddle.net/asgallant/apH2B/), or you can use area style intervals (example: http://jsfiddle.net/asgallant/apH2B/35/, note that the tooltips here can be cleaned up so they don't

[visualization-api] Re: Is there a way detect cycles and filter them out prior to generating a sankey diagram?

2014-08-13 Thread Andrew Gallant
Detecting the loops ahead of time could be difficult (but likely worth it for the possible performance gains). You could hijack the Sankey's error to locate cycles, though: google.visualization.events.addListener(chart, 'error', function (e) { var loopErrorMatch = e.message.match(/Cycle

[visualization-api] Re: Paging for Charts !?

2014-08-13 Thread Andrew Gallant
There are no paging controls for charts. You *could* implement paging for a chart, but paging isn't very user-friendly. Have you looked at the Controls https://google-developers.appspot.com/chart/interactive/docs/gallery/controls#gallery to see if any of those will work for you? On

[visualization-api] Re: Question about creating a timeline

2014-08-12 Thread Andrew Gallant
You have to convert your Timeline into a ChartWrapper in order to use it with a Dashboard: var chart = new google.visualization.ChartWrapper({ chartType: 'Timeline', containerId: 'Chart', options: { // put your chart options here } }); On Tuesday, August 12, 2014 5:14:58

Re: [visualization-api] Re: How to show X Axis at all teh time with Google AngularJS Chart DIrective

2014-08-12 Thread Andrew Gallant
, Vipul vip...@gmail.com javascript: wrote: Thank You Andrew :). This was helpful On 7 August 2014 19:10, Andrew Gallant agal...@google.com javascript: wrote: The only Angular Google Charts directive I know about (this one https://github.com/bouil/angular-google-chart) is a 3rd-party library

[visualization-api] Re: Google Visualization API - Maps

2014-08-12 Thread Andrew Gallant
Batch geocoding your points should speed up the load time all by itself. The layers that article talks about are not available through the Visualization API's Map visualization; you would need to use the Google Maps API to have access to the layers. On Tuesday, August 12, 2014 6:26:15 PM

[visualization-api] Re: PHP Server side graph generation

2014-08-11 Thread Andrew Gallant
With the Visualization API, you would need to render the chart in a browser, call the chart's getImageURI method, and send the image/octet stream to your server to save as a .png file that you could then email. You could also use the Image Chart API

[visualization-api] Re: custom image as data point in scatter chart

2014-08-11 Thread Andrew Gallant
You cannot add an image as a data point, but you can use an overlay to position an image on top of the chart: https://google-developers.appspot.com/chart/interactive/docs/overlays On Monday, August 11, 2014 7:43:36 AM UTC-4, Ananya Ojha wrote: Can we put image as google chart data point? If

[visualization-api] Re: google geomap for UAE

2014-08-11 Thread Andrew Gallant
You need to set the resolution option to provinces. Also, the GeoMap visualization is deprecated, you should use the newer GeoChart visualization instead: http://jsfiddle.net/asgallant/0o2q0xd7/7/ On Monday, August 11, 2014 6:56:13 AM UTC-4, jayapal d wrote: I am trying to replicate the

Re: [visualization-api] Re: custom image as data point in scatter chart

2014-08-11 Thread Andrew Gallant
Yes, it works exactly the same way with a ScatterChart. On Monday, August 11, 2014 8:27:38 AM UTC-4, Ananya Ojha wrote: Can we use it in scatter chart? On Mon, Aug 11, 2014 at 5:56 PM, Andrew Gallant agal...@google.com javascript: wrote: You cannot add an image as a data point, but you

[visualization-api] Re: New Sheets setQuery Select Where for dates help needed

2014-08-11 Thread Andrew Gallant
To compare a date, you have to use a date literal, which has the format date '-MM-dd'. Your query should look like this: var selectStatement = 'SELECT A, B, C WHERE A = date 2014-01-09 '; (assuming your original dates are in the format M/d/) On Monday, August 11, 2014 1:54:19 PM

Re: [visualization-api] Re: Column chart - Bar color

2014-08-09 Thread Andrew Gallant
should change or should i change anything? On Sat, Aug 2, 2014 at 5:51 AM, Andrew Gallant agal...@google.com javascript: wrote: I could not replicate this problem; do you have an example I could test? The charts are drawn with vector graphics (SVG), so they should scale well with screen

[visualization-api] Re: Charts not getting displayed in email

2014-08-08 Thread Andrew Gallant
Most (if not all) email clients do not support javascript in emails. You can create an image from the chart by drawing it in a browser and calling the #getImageURI method. This creates an image/octet stream that you can save as a .png file or use as the src of an img tag, which you can then

[visualization-api] Re: Geomap with Markers always showing value.

2014-08-08 Thread Andrew Gallant
You can't make the labels stay in markers mode; you would have to use text mode instead. text mode changes the size and color of the label itself, instead of a marker. On Friday, August 8, 2014 10:41:29 AM UTC-4, Mark Schenkel wrote: Is it possible to configure a geomap in Markers mode such

[visualization-api] Re: Sankey Diagrams

2014-08-07 Thread Andrew Gallant
You can make a feature request here: http://code.google.com/p/google-visualization-api-issues/issues/list On Thursday, August 7, 2014 7:20:12 AM UTC-4, James Patrick wrote: I want to bring attention to this post, i also love and use Sankey Diagrams however the current state does not allow

[visualization-api] Re: where to add chxr for google charts

2014-08-07 Thread Andrew Gallant
The chxr parameter is for the Image Chart API, not the Interactive Chart API, so you can't use it here. You can instead use the hAxis.viewWindow.min/max option, which allows you to specify the min and max values on the axis: hAxis: { title: 'Status of document', titleTextStyle: {

[visualization-api] Re: Not able to visualize charts in Android, suggest what changes required

2014-08-07 Thread Andrew Gallant
In general, older versions of the Android browser (before Android 3.2) do not support SVG, and thus cannot render charts. There is no fix for this except to use a different browser (Chrome, Firefox, Dolphin, etc). If your problem stems from a newer version of Android, we need more information

[visualization-api] Re: How to make link of google charts with SQL2008

2014-08-07 Thread Andrew Gallant
How you do this is going to depend on what your server environment is like. What server scripting/programming language are you working with? If you are using PHP, there is a sample script you can follow here: https://groups.google.com/d/msg/google-visualization-api/1Z2shPnkORA/RCj5QnyDVecJ.

[visualization-api] Re: Move and modify legend on Geochart?

2014-08-07 Thread Andrew Gallant
Hmmm...I would normally suggest using an onmouseover handler for that, but the GeoCharts don't fire mouse events. I think if you use a MutationObserver (or a DOMNodeInsertion event handler, if MutationObserver is not available) to watch for changes to the legend's container, and fix the

[visualization-api] Re: Bar Chart Width

2014-08-07 Thread Andrew Gallant
The calculation for determining bar widths is complex (I wrote up a rough estimation here: http://stackoverflow.com/a/24825504/613559). Assuming all of your x-axis values are evenly spaced (or you are using a discrete axis) and you have the bar.groupWidth option set to '100%', each row needs a

[visualization-api] Re: where to add chxr for google charts

2014-08-07 Thread Andrew Gallant
, August 7, 2014 8:48:56 AM UTC-4, Andrew Gallant wrote: The chxr parameter is for the Image Chart API, not the Interactive Chart API, so you can't use it here. You can instead use the hAxis.viewWindow.min/max option, which allows you to specify the min and max values on the axis: hAxis

Re: [visualization-api] Re: How to show X Axis at all teh time with Google AngularJS Chart DIrective

2014-08-07 Thread Andrew Gallant
: Thanks a lot Andrew, it worked. Is there a Link where I can have documnetation for the Google Graphs for Angular On 6 August 2014 19:15, Andrew Gallant agal...@google.com javascript: wrote: You need to set the chart's interpolateNulls option to true. On Wednesday, August 6, 2014 6:17:05

[visualization-api] Re: How to get a transparent chart ?

2014-08-07 Thread Andrew Gallant
Try using the chf parameter https://google-developers.appspot.com/chart/image/docs/chart_params#gcharts_solid_fills. The color string supports appending two hex digits to the end for alpha: chf=bg,s,8360c7a0 On Thursday, August 7, 2014 5:43:20 PM UTC-4, Laurent wrote: Nobody knows how to

[visualization-api] Re: Google visualization dashboard Pie display

2014-08-06 Thread Andrew Gallant
First, you need to remove the view parameter from the PieChart's ChartWrapper - it is not needed since you are constructing a new DataTable for the PieChart to draw from. var pie = new google.visualization.ChartWrapper({ chartType: 'PieChart', containerId: 'chart1', options: options

[visualization-api] Re: Pass JSON using java servlet to populate the simple Column chart

2014-08-06 Thread Andrew Gallant
There are two approaches you can take with this: either insert your data into the page server-side, or use an AJAX request client-side to dynamically fetch the data. Since you already have a servlet that serves up a JSON object, using AJAX should be simple enough. I recommend using a

[visualization-api] Re: HTML Tooltip Position in scatter chart

2014-08-06 Thread Andrew Gallant
Controlling the position of the tooltip is not easy. I wrote up an answer on StackOverflow that attempts to do this: http://stackoverflow.com/questions/24795432/how-to-change-pop-up-location-of-google-charts-tooltip/24807496#24807496 It may be easier to turn off the API's tooltips and use

Re: [visualization-api] Re: Tyro GeoChart questions (also googleVis)

2014-08-06 Thread Andrew Gallant
The javascript I used in the fiddle is: function drawChartGeoChartID1590742f148() { var data = gvisDataGeoChartID1590742f148(); var options = {}; options[width] = 1200; options[height] =900; options[projection] = lambert; options[region] = US; options[resolution]

[visualization-api] Re: Google Visualization API - Maps

2014-08-06 Thread Andrew Gallant
15 minutes seems quite excessive, even if you are using the maximum of 400 points. I don't know how the Map visualization works on the back-end, but you may have better luck batch geocoding your addresses first (Geocoding API https://developers.google.com/maps/documentation/geocoding/), and

[visualization-api] Re: Google visualization dashboard Pie display

2014-08-06 Thread Andrew Gallant
); Thanks On Wednesday, August 6, 2014 8:41:58 AM UTC-4, Andrew Gallant wrote: First, you need to remove the view parameter from the PieChart's ChartWrapper - it is not needed since you are constructing a new DataTable for the PieChart to draw from. var pie = new

[visualization-api] Re: making y axis start at 0

2014-08-06 Thread Andrew Gallant
Set the vAxis.minValue option to 0: vAxis: { minValue: 0 } On Wednesday, August 6, 2014 3:13:56 PM UTC-4, Neil Camara wrote: Hi folks, How can I force the chart to show 0? Please check my output chart http://i.imgur.com/0ClqVJw.png Thanks, Neil -- You received this message

[visualization-api] Re: Move and modify legend on Geochart?

2014-08-06 Thread Andrew Gallant
The API does not provide the means to set the location of the legend, nor does it provide much in the way of number formatting. To do what you want, you are going to have to get down and dirty with the rendered chart code. Here's an example: google.visualization.events.addListener(chart,

[visualization-api] Re: get Json configuration, after edit edit an graphic

2014-08-06 Thread Andrew Gallant
I am not quite sure what it is you are looking for, but likely whatever you need is available from one of the ChartWrapper methods: var wrapper = editor.getChartWrapper(); wrapper.getOptions(); wrapper.getChartType(); wrapper.getDataTable(); wrapper.getView(); On Wednesday, August 6, 2014

[visualization-api] Re: Bubble Chart tool tip

2014-08-05 Thread Andrew Gallant
You cannot change the font weight in the tooltips, but you can create custom HTML tooltips https://google-developers.appspot.com/chart/interactive/docs/customizing_tooltip_content#custom_html_content which allow you to style your content however you like. On Tuesday, August 5, 2014 12:08:27

[visualization-api] Re: How to show X Axis at all teh time with Google AngularJS Chart DIrective

2014-08-05 Thread Andrew Gallant
, Andrew Gallant wrote: I suspect that your dates are not showing up because the chart is too short; if you make it taller (or use the chartArea.height and chartArea.top options to make the inner height shorter and/or move it up higher) there will be more space for the axis labels to draw

Re: [visualization-api] Re: Tooltip Font Misbehaving

2014-08-05 Thread Andrew Gallant
the code as HTML and view it on my site, the font changes on the bold again. Something is messing it up on the site with CSS, but since I can’t drill down to the circle elements using IE dev tools, I’m kind of stuck. On Monday, August 4, 2014 7:51:01 PM UTC-4, Andrew Gallant wrote: Which

[visualization-api] Re: Google visualization dashboard Pie display

2014-08-05 Thread Andrew Gallant
i get an error that says Invalid column index 2. Should be an integer in the range [0-1]. Thanks On Friday, August 1, 2014 8:38:08 PM UTC-4, Andrew Gallant wrote: You need to calculate the data for your PieChart in the ready event handler for your Table

[visualization-api] Re: Tyro GeoChart questions (also googleVis)

2014-08-05 Thread Andrew Gallant
The GeoCharts don't support custom tooltips yet, so the range of what you can do is a bit limited. If you want to get rid of the second row from the tooltips, the solution is to use a tooltip role column to override the contents of the row and null them out. The tooltip will render with a

[visualization-api] Re: problems showing characters from unicode hex codes

2014-08-05 Thread Andrew Gallant
You need to use the javascript unicode value for your characters, not the HTML unicode value. If you have a function that creates HTML-encoded characters, you can convert a character to javascript unicode with this: function decodeHTMLUnicode (str) { var d = document.createElement('div');

[visualization-api] Re: Tyro GeoChart questions (also googleVis)

2014-08-04 Thread Andrew Gallant
I don't know about embedding in a Blogger post; the charts require javascript, and some blogging platforms do not allow users to post javascript. You may have better luck asking on StackOverflow for help embedding javascript in Blogger. For your second question, are you using regions mode or

[visualization-api] Re: Find a user on Google+ through API

2014-08-04 Thread Andrew Gallant
This is not the right place for Google+. Try the Google+ API Documentation https://developers.google.com/+/api/, or the Google+ API Developer's page https://plus.sandbox.google.com/+GooglePlusDevelopers/posts. On Monday, August 4, 2014 11:07:09 AM UTC-4, Martin Schneider wrote: Hi! Sorry,

[visualization-api] Re: What are the exact chartType names? What chartTypes are available for use in a dashboard?

2014-08-04 Thread Andrew Gallant
The chartType property takes a string referencing the google.visualization object property for the chart you want to draw. For example, if you want to draw a Line Chart, the normal Line Chart object is: google.visualization.LineChart so when using a ChartWrapper, you would set the chartType

[visualization-api] Re: Is it possible to apply controls to a Calendar chart?

2014-08-04 Thread Andrew Gallant
Yes, you should be able to use any of the Controls https://google-developers.appspot.com/chart/interactive/docs/gallery/controls with a Calendar chart. When building the ChartWrapper for the Calendar, make sure you set the view parameter to exclude the columns you don't want the Calendar to

Re: [visualization-api] Re: Tooltip Font Misbehaving

2014-08-04 Thread Andrew Gallant
1, 2014 at 8:27 PM, Andrew Gallant agal...@google.com javascript: wrote: If it works fine in jsfiddle then you almost certainly have CSS that is changing it. If you use Chrome's developer tools, you can drill down into the SVG code inside the chart container. On Friday, August 1, 2014

[visualization-api] Re: specifying N number of x-axis when data is only one

2014-08-04 Thread Andrew Gallant
You need to specify the hAxis.ticks option. The ticks option takes an array of values or object. Values point to the location where a tick mark (and label) should be placed. Objects have v (required) and f (optional) properties, where v is the value to place a tick mark at, and f is the

[visualization-api] Re: How to show X Axis at all teh time with Google AngularJS Chart DIrective

2014-08-04 Thread Andrew Gallant
I suspect that your dates are not showing up because the chart is too short; if you make it taller (or use the chartArea.height and chartArea.top options to make the inner height shorter and/or move it up higher) there will be more space for the axis labels to draw. The second y-axis should be

[visualization-api] Re: specifying N number of x-axis when data is only one

2014-08-04 Thread Andrew Gallant
Yes, it will works for dates, just use Date objects instead of the timeofday arrays: hAxis: { ticks: [new Date(2014, 7, 1), new Date(2014, 7, 2), new Date(2014, 7, 3), new Date(2014, 7, 4)] } On Monday, August 4, 2014 8:12:05 PM UTC-4, Neil Camara wrote: It worked Andrew and it looks

[visualization-api] Re: Timeline chart from JSON file

2014-08-03 Thread Andrew Gallant
); On Saturday, August 2, 2014 3:22:46 PM UTC-4, Ákos Kovács wrote: Yes, I see, but how can I implement it to PHP? 2014. augusztus 2., szombat 17:14:25 UTC+2 időpontban Andrew Gallant a következőt írta: This post https://groups.google.com/d/msg/google-visualization-api/2LNtd5Fe8L8/QXJHhQBvBHEJ

[visualization-api] Re: I'd like to commission someone to write a fairly basic line chart. Interested?

2014-08-02 Thread Andrew Gallant
. This is too cool, thank you thank you! On Thursday, July 31, 2014 9:05:13 PM UTC-7, Andrew Gallant wrote: Oops, sorry, my mistake. You need to add the csvToDataTable function I posted above to the javascript (just paste it in before the drawChart function). On Thursday, July 31, 2014 5:38:29 PM

[visualization-api] Re: Timeline chart from JSON file

2014-08-02 Thread Andrew Gallant
, only Google's official. 2014. augusztus 2., szombat 2:26:00 UTC+2 időpontban Andrew Gallant a következőt írta: The DataTable constructor requires a very specific JSON format; if you aren't using that format, the constructor will throw an error and your chart will not draw. I can help

Re: [visualization-api] Re: Column chart - Bar color

2014-08-01 Thread Andrew Gallant
, 2014 at 12:18 PM, Nagendra Singh nagendr...@gmail.com javascript: wrote: Hi, The marker which are displayed in the scatter chart are not having smooth edges when displayed in a big screen. Is this normal? On Thu, Jul 24, 2014 at 11:33 PM, Andrew Gallant agal...@google.com javascript

[visualization-api] Re: Timeline chart from JSON file

2014-08-01 Thread Andrew Gallant
The DataTable constructor requires a very specific JSON format; if you aren't using that format, the constructor will throw an error and your chart will not draw. I can help you get your chart working if you share your code. I also suggest that you search this group for examples of creating

[visualization-api] Re: Tooltip Font Misbehaving

2014-08-01 Thread Andrew Gallant
. I'm having trouble getting dev tools to let me pick the tooltip in the DOM and I don't see it when viewing source. Any tips? On Thursday, July 31, 2014 11:49:58 PM UTC-4, Andrew Gallant wrote: The font should apply to both, and does when I created a test case: http://jsfiddle.net

Re: [visualization-api] Not allowing non-whole numbers in axis for interactive charts

2014-08-01 Thread Andrew Gallant
The easy way to find the max value is to use the DataTable#getColumnRange https://developers.google.com/chart/interactive/docs/reference#DataTable_getColumnRange method, which will return an object with min and max properties. You can file a feature request

[visualization-api] Re: I'd like to commission someone to write a fairly basic line chart. Interested?

2014-07-31 Thread Andrew Gallant
sense? If I point to my index.html file that works fine. Im using IIS on Windows 7 to serve the page. Anything special I need to turn on? On Monday, July 28, 2014 4:48:17 PM UTC-7, Andrew Gallant wrote: Storing the CSV file inside your web directory makes this much easier

[visualization-api] Re: Drill down functionality for column charts

2014-07-31 Thread Andrew Gallant
July 2014 11:48:35 UTC+5:30, Rk MooRthy Rajendran wrote: Hi Andrew, Its working fine. Thank you very much for your valuable reply... -Rk.MooRthy On Tuesday, 29 July 2014 18:14:59 UTC+5:30, Andrew Gallant wrote: You should be able to replicate that chart. Use a ComboChart https

Re: [visualization-api] Re: How to reverse vertical axis data order

2014-07-31 Thread Andrew Gallant
, Andrew Gallant agal...@google.com javascript: wrote: Set the vAxis.direction option to -1. On Tuesday, July 29, 2014 3:49:22 AM UTC-4, Paul Preston wrote: I have a chart (and code below) where the vertical axis needs to show 1 at the top and the highest number at the bottom, at the moment

[visualization-api] Re: Tooltip Font Misbehaving

2014-07-31 Thread Andrew Gallant
The font should apply to both, and does when I created a test case: http://jsfiddle.net/asgallant/u8j9D/. Can you provide a full code example that replicates the problem? It is possible that you have CSS that is messing with the tooltips; I suggest examining the tooltip with a DOM inspector

Re: [visualization-api] Visualization Playground Broken

2014-07-31 Thread Andrew Gallant
The old playground is gone for good; it's not going to be fixed. The dev team is working on alternatives, but I would not expect something in the immediate future. In the meantime, if you need a playground-like tool to work with, jsfiddle.net is a popular option (and there are others as well,

[visualization-api] Re: How to open a Gauge chart

2014-07-31 Thread Andrew Gallant
What code are you trying to save? On Thursday, July 31, 2014 2:05:10 PM UTC-4, Ron Hernandez wrote: Hi Team, formerly I was using it but since it got changed I dont know how to open my gauge chart anymore. It's mentioned : You can copy the snippet below to a file on your computer and open

[visualization-api] Re: Radar chart

2014-07-31 Thread Andrew Gallant
The (deprecated) Image Chart API supports radar charts, but it is due to be turned off next April, so I would not rely on it. The Interactive Chart API does not support them, but you can file a feature request http://code.google.com/p/google-visualization-api-issues/issues/list to add them.

[visualization-api] Re: I'd like to commission someone to write a fairly basic line chart. Interested?

2014-07-31 Thread Andrew Gallant
btw I set the path to the following: its in the root directory along with mychart.html url: '/current.csv' , On Thursday, July 31, 2014 5:57:50 AM UTC-7, Andrew Gallant wrote: Open the page in Chrome and open the developer's console (ctrl+shift+j). Are there any error messages

[visualization-api] Re: Official documentation on how to include multiple charts on the same page?

2014-07-31 Thread Andrew Gallant
There are many ways to include multiple charts on the same page. The thing they all share in common are that each chart has to have a unique container div, so if I create 3 charts on a page, I might put them in 3 container divs with id's chart1, chart2, and chart3. You can separate out the

[visualization-api] Re: formatting time on the tooltip

2014-07-30 Thread Andrew Gallant
You need to format your data to get the tooltips to display properly. If you are using a date or datetime data type, you can format it using a DateFormatter: var formatter = new google.visualization.DateFormat({pattern: 'h:mm aa'}); formatter.format(data, 0); If you are using a timeofday data

[visualization-api] Re: Filter table results with a drop down menu

2014-07-30 Thread Andrew Gallant
From the sound of things, I think you want to use a CategoryFilter. Here's some example javascript you can use to get started: function drawVisualization() { var query = new google.visualization.Query('http://spreadsheets.google.com/tq?key=**pub=1');

[visualization-api] Re: Charts Timeline error

2014-07-30 Thread Andrew Gallant
Those dates are correct. Javascript uses a zero-based index for months, so all of the month numbers are 1 lower than most date systems (ie. January is 0, February is 1, March is 2, etc...). On Wednesday, July 30, 2014 3:07:23 PM UTC-4, Jose gerardo Renteria Valdespino wrote:

[visualization-api] Re: how to do ColorFormat for cells with true/false value

2014-07-30 Thread Andrew Gallant
The ColorFormatter only works on number data type, so you can't use it with your boolean values, but you can emulate its effect. The ColorFormatter changes the style property of the DataTable cells, which the Table visualization assigns as the style attribute of the td's, so all you have to

[visualization-api] Re: Drill down functionality for column charts

2014-07-29 Thread Andrew Gallant
2014 04:36:59 UTC+5:30, Andrew Gallant wrote: You can use a DataView to calculate each data series as a percent of the total: var columns = [0]; for (var i = 1; i data.getNumberOfColumns(); i++) { columns.push({ type: 'number', label: data.getColumnLabel(i

[visualization-api] Re: How to reverse vertical axis data order

2014-07-29 Thread Andrew Gallant
Set the vAxis.direction option to -1. On Tuesday, July 29, 2014 3:49:22 AM UTC-4, Paul Preston wrote: I have a chart (and code below) where the vertical axis needs to show 1 at the top and the highest number at the bottom, at the moment it is the other way around - how do I this? Thanks

[visualization-api] Re: Place a marker on a horizontal bar chart by using google.visualization.BarChart and not ImageChart

2014-07-28 Thread Andrew Gallant
pictorial representation of what is to be achieved. On Saturday, July 26, 2014 6:07:50 AM UTC+5:30, Andrew Gallant wrote: Will your chart have just one column or multiple columns? If it will have multiple columns, is it ok if the lines extend all the way across the chart? If you can use

[visualization-api] Re: Drill down functionality for column charts

2014-07-28 Thread Andrew Gallant
wrote: Hi Andrew, Thanks for your valuable reply. Now i have to put drill down stacked bar chart as percentage wise. Do you have any idea or sample code for regarding this..??? Thanks in Advance.. -Rk.MooRthy On Saturday, 26 July 2014 06:03:56 UTC+5:30, Andrew Gallant wrote: Set

[visualization-api] Re: Geo chart ready event

2014-07-28 Thread Andrew Gallant
The ready event fires as it should: http://jsfiddle.net/asgallant/4wLyu/ Make sure you are creating the event handler before drawing the chart; if you create it after drawing, the ready event may have already fired, and thus your callback will never be called. On Monday, July 28, 2014 7:31:57

[visualization-api] Re: I'd like to commission someone to write a fairly basic line chart. Interested?

2014-07-28 Thread Andrew Gallant
store its location anywhere including the root dir of the website. Hopefully that makes it a bit easier. Thanks again for all your help on this! On Sunday, July 27, 2014 6:23:30 AM UTC-7, Andrew Gallant wrote: For turning on and off the lines, would either of these work for you? http

Re: [visualization-api] Not able to see Google Line Chart on ie8 or ie9

2014-07-28 Thread Andrew Gallant
Your $scope object has several errant commas: $scope.chartObject = { type: LineChart, displayed: true, data: { cols: [ { label: Month, type: number, // -- this comma }, { label: Weight,

[visualization-api] Re: Chrome: Cannot read property 'length' of null

2014-07-27 Thread Andrew Gallant
Could you provide a code example that demonstrates the problem? That error is too generic to point to any specific cause. On Saturday, July 26, 2014 10:52:55 AM UTC-4, Zdravko Balorda wrote: I get this error on rendering a ComboChart in Chrome: Cannot read property 'length' of null The

[visualization-api] Re: Want to Set the Tooltip as default within the graph

2014-07-27 Thread Andrew Gallant
, Vishawjeet Singh wrote: Thanks for your reply Andrew. Attached is my code, i wanted a way to make the Tool Tip Auto Selected/Static so that users can see it without hovering / Selecting the section. Thanks Regards, Vishawjeet On Saturday, 26 July 2014 17:39:50 UTC+5:30, Andrew Gallant

[visualization-api] Re: Format axes' titles

2014-07-27 Thread Andrew Gallant
Set the style of the axis titles using the hAxis and vAxis.titleTextStyle options. hAxis: { titleTextStyle: { fontSize: 14 // takes an integer for the pixel-size of the font (note that em notation does not work here) } } On Saturday, July 26, 2014 6:21:40 PM UTC-4, Luigi

[visualization-api] Re: BAR CHART COLOUR CHANGE ACCORDING TO RANGE

2014-07-26 Thread Andrew Gallant
You need to draw the chart using the DataView, not the DataTable: chart.draw(view, options); On Saturday, July 26, 2014 3:21:16 AM UTC-4, Mirko Nulla wrote: data.rows is formed so [[A.T.E. di Giuseppe di Mascio,13,4,20],[ALDO NATALE,22,2,20],[ALESSANDRINI CLAUDIO,0,0,20]] Il giorno

[visualization-api] Re: Want to Set the Tooltip as default within the graph

2014-07-26 Thread Andrew Gallant
If you post some example code demonstrating the problem, I can help you figure out why it isn't working and what needs to be done to fix it. On Saturday, July 26, 2014 5:36:40 AM UTC-4, Vishawjeet Singh wrote: Hi Karthik, Wanted to know if you were able to implement this functionality ?

[visualization-api] Re: trouble in dashboard where one controller is controlling multiple charts

2014-07-25 Thread Andrew Gallant
The reason you see just the speed data is because you draw the Dashboard with the area data and then immediately draw over it with the speed data. Dashboards can only use a single set of data. In your case, since you have two data sets with a common column (Tech), you might want to consider

[visualization-api] Re: BAR CHART COLOUR CHANGE ACCORDING TO RANGE

2014-07-25 Thread Andrew Gallant
They way that is set up, you should see Percentuale 2 colored red, yellow, and green (based on the values of Percentuale, though). Is that working? To get both data sets working, you need to make a few tweaks: view.setColumns([0, 1, { type: 'string', role: 'style', calc: function

[visualization-api] Re: Drill down functionality for column charts

2014-07-25 Thread Andrew Gallant
Set the isStacked option to true. On Friday, July 25, 2014 2:19:11 AM UTC-4, Rk MooRthy Rajendran wrote: Hi, It was very useful to me, very thank to u guys. Now i have to add stacked bar chart for my requirement. Can u any one help me regarding that..??? -Rk.MooRthy On Wednesday, 23

[visualization-api] Re: Place a marker on a horizontal bar chart by using google.visualization.BarChart and not ImageChart

2014-07-25 Thread Andrew Gallant
PM UTC+5:30, Andrew Gallant wrote: What kind of marker do you want to add? There may be a work-around to do what you want. On Thursday, July 24, 2014 6:30:16 AM UTC-4, Dev wrote: How to set marker using package 'corechart' and google.visualization.BarChart? Need options to set for marker

[visualization-api] Re: Question about creating a timeline

2014-07-25 Thread Andrew Gallant
Thanks for the reminder, I started an answer a few days ago and got distracted away. You can merge the DataTables from each query together with a bit of hackery: http://jsfiddle.net/asgallant/2wt3Q/ This method will work with any number of queries you need to make, as long as every query

[visualization-api] Re: User input to update Google Charts using PHP MySQL

2014-07-25 Thread Andrew Gallant
enough in defining SQL injection. Storing the values received for user input into another variable is okay? On Thursday, July 24, 2014 11:31:12 AM UTC-7, Andrew Gallant wrote: I don't see anything in your query that looks like it would throw a divide by zero error. Is the error from

[visualization-api] Re: Clicking on a line

2014-07-25 Thread Andrew Gallant
You can use a click event handler: google.visualization.events.addListener(chart, 'click', function (event) { var match = event.targetID.match(/^line#(\d+)$/); if (match) { console.log('clicked line from series index ' + match[1]); } }); The series index is *usually* the

[visualization-api] Re: I'd like to commission someone to write a fairly basic line chart. Interested?

2014-07-25 Thread Andrew Gallant
This is probably easy to do, and if you're feeling adventurous, we can help you save a bit of cash and do this yourself. A few key questions:' What do you mean by turn off / isolate certain values? Would something like this

Re: [visualization-api] Re: Column chart - Bar color

2014-07-24 Thread Andrew Gallant
the bulk of your data stays on the server and only what you need to display at any given time is stored client-side. On Wednesday, July 23, 2014 10:47:33 PM UTC-4, Nagendra Singh wrote: I am sorry for that. So what do you suggest I should do? On Wed, Jul 23, 2014 at 2:41 AM, Andrew Gallant asgall

Re: [visualization-api] Re: Sign on axis

2014-07-24 Thread Andrew Gallant
, Andrew Gallant agal...@google.com javascript: wrote: Use the vAxis.format option. The format option takes an ICU number pattern, which separates out positive and negative formats with a semicolon, so you could have, as an example: vAxis: { format: '+#;-#' } which would format 3 as +3

<    1   2   3   4   5   6   7   >