Modifying the date format in tooltips in Timeline charts is not yet
supported, sorry.
On Saturday, November 1, 2014 9:22:39 PM UTC-4, Craig wrote:
I have the below code for a Google timeline graph.
When I hover over a bar in the graph, the date in the pop up box only
shows the Month and
Your options should be like this:
var options = {
wordtree: {
format: 'implicit',
word: 'home'
},
maxFontSize: 20,
fontName: 'Times-Roman',
width: 1280,
height: 900,
colors: ['#e0440e', '#e6693e', '#ec8f6e', '#f3b49f', '#f6c7b6'],
};
Does that work for
No, you cannot turn off the annotation tooltips, sorry.
On Monday, November 3, 2014 7:07:31 AM UTC-5, Alexandre Carrie wrote:
Hello,
I'm using ComboChart with annotations on some bars, but when the bar is
too small to permit us to see the annotation, a tooltip is generated. But I
don't
:53:10 PM UTC-4, Andrew Gallant wrote:
I don't have an update for you yet, but we're looking into it.
On Wednesday, October 29, 2014 3:00:02 PM UTC-4, mayl...@pubget.com wrote:
Any updates??
I did try using the chartwrapper - same results. The charts displays
fine when I run the HTML
If you don't need all columns to draw your chart (or you can combine the
string columns into a single column of data), you can use a DataView
https://google-developers.appspot.com/chart/interactive/docs/reference#DataView
to restrict the columns you use, and/or use calculated columns that
2014 05:39:12 UTC-7, Andrew Gallant wrote:
If you don't need all columns to draw your chart (or you can combine the
string columns into a single column of data), you can use a DataView
https://google-developers.appspot.com/chart/interactive/docs/reference#DataView
to restrict the columns
If I might offer an improvement: you can instead set the Table's view to
the rows matching the latest date, and then clear the view after the
Table's first draw. This way, you are never redrawing the whole dashboard
just to change the data in the Table, and it also keeps the values in the
To clarify Jon's post: this includes the GeoMap, GeoChart, and Map
visualizations. Every chart has a Data Policy section in its documentation
(examples: GeoChart
https://google-developers.appspot.com/chart/interactive/docs/gallery/geochart#Data_Policy,
AreaChart
I don't have an update for you yet, but we're looking into it.
On Wednesday, October 29, 2014 3:00:02 PM UTC-4, mayl...@pubget.com wrote:
Any updates??
I did try using the chartwrapper - same results. The charts displays fine
when I run the HTML, but I when I add a very simple Google
by row label (I.e define each record of type A, then define each
record of type B, ) the rows will stay fixed in the same order, but
the events in the timeline will remain unaltered?
On Tuesday, October 28, 2014 6:46:14 PM UTC-6, Andrew Gallant wrote:
As I recall, the bars are placed
You can add an annotation column to your data. You can use a DataView to
calculate this automatically for you:
var view = new google.visualization.DataView(dataTable);
view.setColumns([0, 1, 2, 3, {
type: 'string',
role: 'annotation',
sourceColumn: 2,
calc: function (dt, row) {
As I recall, the bars are placed in the order of the rows in the DataTable,
so if you sort your data by row label, the Timeline rows should always be
in the same order.
On Tuesday, October 28, 2014 2:30:23 PM UTC-4, Nick Pepperling wrote:
Do you know if there is any way to freeze the position
: center;
}
On Tuesday, October 28, 2014 6:59:36 PM UTC-4, Nicole Goldup wrote:
Thanks Andrew.
It works, however the values are off center. Is it possible to make the
percentages centered?
Regards,
Nicole
On Tuesday, October 28, 2014 11:55:06 PM UTC+11, Andrew Gallant wrote:
You can add
Sorry, but the Timeline's axis is not yet configurable.
On Monday, October 27, 2014 5:34:08 AM UTC-4, Vamshi Krishna wrote:
I was able to generate the timeline successfully with the help of JSON.
When i generated the graph the everything was fine, except the scale on
the major axis.
and then days..so on.
Thank you for your previous reply
Regards,
Prajna
On Thursday, 16 October 2014 06:43:17 UTC+5:30, Andrew Gallant wrote:
There are many ways to accomplish a drilldown chart; which is the best
way is probably going to depend on how your data is structured. Here's
Ahh, I see now. I had thought that your data was already organized by data
series. To split the data into series based on a column of values, there
are two basic ways. First, you can continue along the path you started,
filtering your data, splitting it into series, and then grouping it for
Setting vAxis.gridlines.color to transparent should
work: http://jsfiddle.net/asgallant/oatbak5s/
On Monday, October 27, 2014 9:13:00 PM UTC-4, born2achieve wrote:
Hi,
I create column chart and it has vaxis and haxis grid lines. i trying hard
to remove the both the grid lines. i tried to
The chart title's font size is controlled by the titleTextStyle.fontSize
option: http://jsfiddle.net/asgallant/1b7sjvts/
On Monday, October 27, 2014 6:41:42 PM UTC-4, Abdul Javeed wrote:
Im trying to make the font bigger of the title only. I have had no luck,
Below is my code, if you know
Do you want to represent time as in duration or time as in time of day?
On Saturday, October 25, 2014 4:05:00 AM UTC-4, Keerthy Ar wrote:
How to represent time value on y axis ?
--
You received this message because you are subscribed to the Google Groups
Google Visualization API group.
To
Your code uses jqplot, not the Visualization API (which is what this group
is about). You will likely be able to find help with this on
stackoverflow.com
On Thursday, October 23, 2014 9:05:18 PM UTC-4, Lim Jing Xiang wrote:
html
head
script language=javascript type=text/javascript
('gradient_chart_div'));
chart.draw(data, options);
}
/script
/head
body bgcolor=#5E5C5C
div id=\series_chart_div\ style=\width: 400px; height:
270px;\/div
/body
/html
Am Freitag, 24. Oktober 2014 01:40:00 UTC+2 schrieb Andrew Gallant:
The colorAxis option is missing
FYI, that will disable all interactivity with a series, not just tooltips.
On Friday, October 24, 2014 8:23:45 AM UTC-4, Michael Dorfman wrote:
You can't specifically disable tooltips, but you can disable user
interactivity for a series. This was the solution I found here (
I can't help you if I can't duplicate the problem - can you post the code
you are using?
On Friday, October 24, 2014 10:45:36 AM UTC-4, cyb wrote:
Hi,
ok now my other pc gets also this error. i have used google chrome on my
PC2 an he says i should do an update to chrome 38.0.2125.104 after
There are several examples of constructing a DataTable from PHP in this
group; try searching for php json datatable.
Incidentally, unless you have a need to store the JSON file on your server,
you don't need to copy save the JSON to a file - you can just output it
directly into the javascript
I'm not sure what your intention is with all of that code - it looks like
you mashed several code blocks from different examples together. Is your
intention to have something like this: http://jsfiddle.net/asgallant/WaUu2/
(with a LineChart instead of a BarChart)?
On Friday, October 24, 2014
I don't see any errors when I draw a Map. Can you post code (preferably a
jsfiddle example) that demonstrates the problem?
On Wednesday, October 22, 2014 2:19:09 PM UTC-4, cyb wrote:
Hi,
i have nothing changed on my code, but if i load a google Map chart i get
this error:
Chart not
Set the backgroundColor option:
var options = {
colorAxis: {colors: ['yellow', 'red'],
backgroundColor: '#453391'
};
On Thursday, October 23, 2014 4:33:00 AM UTC-4, Dustin Böttger wrote:
Hello together,
i am new to the Google Charts Api and i want to use them in my Filemaker
Coloring the bars in a Timeline using the colors option is a tricky
process at best, and may well be bugged. It is much easier to use a
style role column to color the
bars: http://jsfiddle.net/asgallant/t5wj394u/
On Thursday, October 23, 2014 2:55:36 PM UTC-4, Abdul Javeed wrote:
i want my
2014 14:39:05 UTC+2 schrieb Andrew Gallant:
Set the backgroundColor option:
var options = {
colorAxis: {colors: ['yellow', 'red'],
backgroundColor: '#453391'
};
Unfortunately, it does not work for me.
https://lh4.googleusercontent.com/-KKOKq40whEk/VEj7gwT0j8I/ACA/YzGhRD5uR20
The problem is in the JSON; Date objects are not valid JSON. The
Visualization API uses a string format for passing dates via JSON. The
string format is Date(year, month, day) - it is a string that looks like
a Date object, without the new keyword. As an example, your first row of
data
Tooltips on the Timeline chart are not yet customizable, so you would have
to implement your own solution for this. Here's some code to get you
started: http://jsfiddle.net/asgallant/t5wj394u/1/
On Tuesday, October 21, 2014 2:24:56 PM UTC-4, Abdul Javeed wrote:
This information can be showed
Set the legend.position option to bottom:
new google.visualization.ColumnChart(document.getElementById('visualization'
)).
draw(data, {
title: Requirements,
legend: {
position: 'bottom'
}
});
On Tuesday, October 21, 2014 4:17:59 PM UTC-4, Abdul Javeed wrote:
How to have
GeoMaps are deprecated; there will be no further development on them. The
GeoCharts replaced GeoMaps years ago.
Here's an example of how to use HTML tooltips with the
GeoCharts: http://jsfiddle.net/asgallant/00q4rf9s/
On Sunday, October 19, 2014 10:54:08 AM UTC-4, Mark Schenkel wrote:
Assuming you have two functions that draw the Map and the GeoChart,
respectively, you could use something like this to draw them:
function draw () {
drawMap();
drawGeoChart();
}
google.load('visualization', '1', {packages: ['geochart', 'map'], callback:
draw});
On Monday, October 20,
There are many ways of doing this; I need to know more about how your code
is organized before I can suggest which might work best for you. Can you
post a simplified example that demonstrates the code organization?
On Monday, October 20, 2014 2:22:17 PM UTC-4, Juan wrote:
I'm starting with
The charts do not expose any methods to get the R-squared value from a
trendline; you will have to calculate it yourself if you want to use it
elsewhere. They also do not expose any means of modifying the trendline
tooltips.
On Monday, October 20, 2014 2:25:18 PM UTC-4, Stephen Huey wrote:
Creating a vertical line can be done either by adding a domain-axis
annotation with the style option set to line, or by adding an additional
data series with two (x, y) points sharing a common x-value. The
horizontal line can be added with an additional data series with two (x, y)
points
The Visualization API runs in a browser environment, so unless your
stand-alone application includes browser capabilities (HTML, CSS,
SVG/Canvas, javascript, primarily), you cannot use the Visualization API in
it.
On Saturday, October 18, 2014 4:37:52 AM UTC-4, Danial Chong wrote:
Hi there
Making the rows fill the container exactly will be quite difficult to do,
but you can adjust the height of the rows in CSS or by adding classes/CSS
to individual cells. If the outer container (the grey area, assuming there
are no layers of HTML between the grey area and the table's container
Put the ready event handler before calling chart2.draw; otherwise the chart
may finish drawing and fire its ready event before you create the handler,
and thus the handler will never trigger. This could explain why it isn't
working.
On Thursday, October 16, 2014 4:41:18 AM UTC-4, Mike wrote:
You can change the color of the points using a style role column (like
when changing the color of the bars). Changing the color of the line is
more difficult. The scope role column will grey out sections of the line
(as in your example), but you cannot control the color. The only other way
There are a couple of things you need to adjust. First, your spans need
quotes around the title text:
data2.setFormattedValue(i, j, 'span title='+ testText +'' +
formattedValue + '/span');
Then set up your tooltips in a ready event handler for the table, instead
of on document ready:
https://lh5.googleusercontent.com/-n9trnHdWOWg/VDg-XY6jNhI/IMA/Ecy7rSyLfWc/s1600/charts_canary.png
On Wednesday, October 8, 2014 9:35:06 PM UTC-3, Andrew Gallant wrote:
Can you post some code that replicates the problem?
On Tuesday, October 7, 2014 2:40:09 PM UTC-4, Matheus Henrique
I answered this exact question 2 or 3 years ago. I'll try to find the
post, though it seems to be eluding my search for the time being.
On Saturday, October 11, 2014 5:25:15 PM UTC-4, Sjoerd Maessen wrote:
I'm looking into a solution to realise something like the first line chart
in the
I have not tested the charts personally in IE8 in a long time, but I do not
know of any bugs that prevent them from working. If you can post code that
isn't working in IE8, I'll take a look and see if I can figure out why.
On Sunday, October 12, 2014 2:01:09 AM UTC-4, ANZ wrote:
@asgallant
Your DataTable construction is not correct. Try this:
?php
$con=mysqli_connect(localhost,root,,data_trafiek);
$result = mysqli_query($con,select date,vol_dl,vol_ul from per_uur);
if ($result !== false) {
$output = array(
'cols' = array(
UTC-4, Lorenzo Forti wrote:
Hi,
I've the same problem. My Android version is 4.4.2 KitKat and with Chrome
I can't see the chart. It shows a message: graphics are not supported
lorenzo
Il giorno venerdì 8 agosto 2014 00:57:37 UTC+2, Andrew Gallant ha scritto:
In general, older versions
You need to set the view parameter on the chart to restrict the chart to
use columns 1 and 2 only:
var myLine = new google.visualization.ChartWrapper({
'chartType' : 'LineChart',
'containerId' : 'line_div',
view: {
columns: [1, 2]
}
});
On Tuesday, October 14, 2014
To the best of my knowledge, you cannot get the calculated value of a
trendline point for a given x-value from the chart. You can make a feature
request
http://code.google.com/p/google-visualization-api-issues/issues/list to
add support for getting the calculated value of a trendline point,
You can set the formatted value of the status value cells to whatever HTML
string you need to create the appearance you want. As an example:
for (var i = 0, length = data1.getNumberOfRows(); i length; i++) {
var value = data1.getValue(i, 1);
var className = (value === 0) ?
responsible.
Op vrijdag 10 oktober 2014 02:58:14 UTC+2 schreef Andrew Gallant:
Your aggregation column needs to be a number type:
var GroupedData = google.visualization.data.group(Data,[2],[{
column: 2,
type: 'number',
label: Data.getColumnLabel(2),
aggregation
The baseline only shows up when you have a continuous data type for the
domain (x-axis). Given your labels, I believe you are using a discrete
(string-type) axis, which will not show the baseline.
On Wednesday, October 15, 2014 10:12:46 AM UTC-4, born2achieve wrote:
I am missing the vertical
There is no function to get the current data in the query language, so you
have to construct the date yourself in javascript:
var today = new Date();
var todayString = today.getFullYear() + '-' + (today.getMonth() + 1) + '-'
+ today.getDate();
then in your query:
var queryString = 'SELECT A,
Your aggregation column needs to be a number type:
var GroupedData = google.visualization.data.group(Data,[2],[{
column: 2,
type: 'number',
label: Data.getColumnLabel(2),
aggregation: google.visualization.data.count
}]);
You may need to change the source column to something other
I don't have any example code for this, but if you can share what you have
tried so far, perhaps I can nudge you in the correct direction to make it
work?
On Thursday, October 9, 2014 5:18:37 AM UTC-4, Mike wrote:
Dear all,
I am looking at including a tooltip for each row within a google
Yes, your data should be continuous. The easiest way to handle this would
be to create some offset space to the left and right of your data by
setting the hAxis.viewWindow.min and hAxis.viewWindow.max options to values
below and above the min and max of your x values (respectively):
var
The R-squared value is not available from the visualization API, you will
have to calculate it yourself.
On Thursday, October 9, 2014 2:40:25 PM UTC-4, Zhenyu Hu wrote:
Dear All,
I am using google chart api to draw a scattered polynomial trend line.
I can get the trend line equation
You are setting the formatted value of the cell when you call
formatter.format(data,
1); and the formatted value is not overwritten when you change the actual
value of the cell. You need to reformat your data after calling #setCell:
chart.draw(data, options);
data.setValue(0,1, sales);
Here's an example: http://jsfiddle.net/asgallant/y5nw5ow8/
On Sunday, October 5, 2014 12:50:36 AM UTC-4, ss kumar wrote:
Hi,
Thanks for ur reply.
Could you reply sample code on how to use it? Thanks.
On Fri, Oct 3, 2014 at 7:26 PM, Andrew Gallant agal...@google.com
javascript: wrote
You can do something quite similar by creating a DataTable with 4 columns:
domain (axis labels), value (for the height of the lower bars), box
thickness (for the height of the colored boxes), and color:
var data = google.visualization.arrayToDataTable([
['Label', 'Value', 'Box thickness',
, 2014 8:56:57 AM UTC-4, Andrew Gallant wrote:
Add an annotation role column to your data set (which will be attached
to whatever series of data immediately precedes it in the DataTable). This
is a string type column that contains labels to add to data points. Use
null values for all
Can you post some code that replicates the problem?
On Tuesday, October 7, 2014 2:40:09 PM UTC-4, Matheus Henrique Klem Galvez
wrote:
I forgot to mention that it happend with two types of charts: line and
column chart.
On Tuesday, October 7, 2014 3:36:44 PM UTC-3, Matheus Henrique Klem
If having the baseline always be in the center of the chart is acceptable
(even when there are no data points below it), there is an easy solution to
this problem: get the min/max for each series and set the minValue/maxValue
options to the negative of the opposite value: this will ensure that
= new
google.visualization.PieChart(document.getElementById('chart_div'));
On Thursday, October 2, 2014 10:13:47 AM UTC+5:30, lifes...@gmail.com
wrote:
It sure did Andrew. Thanks a lot.
On Thursday, October 2, 2014 7:45:16 AM UTC+5:30, Andrew Gallant wrote:
Why are you starting to fill
Add an annotation role column to your data set (which will be attached to
whatever series of data immediately precedes it in the DataTable). This is
a string type column that contains labels to add to data points. Use null
values for all points that you do not want to have labels. If you
The timeline charts do not support setting a specific range for the time
axis.
I cannot replicate your issue with the extra character after the div. If
your chart is too short to contain the data you input, the API will add a
vertical scroll bar, though.
On Saturday, October 4, 2014 7:50:42
Do you want to have axis labels at the end points, or do you want to label
the data points themselves?
For the area fills, set the series.series indec.areaOpacity option to 0
for all series that you want to remove the shading on. So, if the first,
second, and third data series should not have
Sorry, but there is no way to track or set the page of the legend. You
could remove the legend and implement your own in HTML, though.
On Saturday, October 4, 2014 2:32:21 PM UTC-4, Daniel Haas wrote:
The legend of my LineChart has 2 pages that I can switch between using
arrows:
The closest solution for this is to use a ChartRangeFilter
https://google-developers.appspot.com/chart/interactive/docs/gallery/controls#chartrangefilter,
but that allows you to get a range of data based on the start or end date;
it doesn't restrict the chart view to a particular length of
There's nothing built into the API that will do this for you, but you can
add some code to track which data series are visible and set either the
colors option or the series.series index.color options based on which
data series are visible at any given time, and what was visible previously.
, 2014 at 4:45 AM, Andrew Gallant agal...@google.com
javascript: wrote:
Here's an example using the DOMParser:
var xml = 'metric-datasmetric-datametricPathApplication
Infrastructure Performance|MineStar|Individual Nodes|Node 2
9383|JMX|Test|CacheSize/metricPathmetricNameServer|Component:7
This line:
var chart = new
google.visualization.DataTable(document.getElementById('chart_div'));
is incorrect. You should be creating a visualization object there, not a
DataTable. Did you intend to create a Table?
var chart = new
The easy way to do that is to use a NumberFormatter
https://google-developers.appspot.com/chart/interactive/docs/reference#numberformatter
:
var formatter = new google.visualization.NumberFormat({pattern: '$#.00'});
// format column 1 of DataTable data
formatter.format(data, 1);
Specifying the
The Query object
https://google-developers.appspot.com/chart/interactive/docs/reference#Query
you use to get the data from Google Docs has a #setRefreshInterval method
that allows you to specify a time interval to update your data on, which
should be able to give you real-time data.
On
example that demonstrates the problem?
On Monday, September 29, 2014 12:07:35 PM UTC-4, Schabagh wrote:
Hi Andrew,
I sent the text file to your email address. did you get it?
Thanks
Am Donnerstag, 25. September 2014 14:32:55 UTC+2 schrieb Andrew Gallant:
Can you report the data in text
Have you tried using the Google China domain? https://www.google.cn/jsapi
On Friday, September 26, 2014 10:08:04 PM UTC-4, John Pham wrote:
how do one get access to https://www.google.com/jsapi
from China - the google.com address is blocked
--
You received this message because you are
Google Finance does not use the Visualization API for its charts. It looks
similar to the Annotated Timeline, but they are not the same.
If you want to duplicate some of the features of that chart, you will have
to custom code them. The Annotated Timeline is probably not the chart you
want
to put it into google api's chart table.
How can I handle that?
On Wed, Sep 24, 2014 at 5:50 AM, Andrew Gallant agal...@google.com
javascript: wrote:
You can use the DOMParser object
https://developer.mozilla.org/en-US/docs/Web/API/DOMParser to parse an
XML document. IE 8 does not have
You can build the grouping columns array in a loop:
var groupColumns = [];
for (var i = 0; i noOfCustomers; i++) {
groupColumns.push({ 'column': i + 1, 'aggregation':
google.visualization.data.sum, 'type': 'number' });
}
result = google.visualization.data.group(data, [{ column: 0, modifier:
Yes, annotations are now supported on all bar-type charts (BarCharts,
ColumnCharts, ComboCharts using bars type series).
On Wednesday, September 24, 2014 9:32:38 AM UTC-4, Alexandre Carrie wrote:
Hello Andrew,
Today, can we put annotations on bars in combo chart?
--
You received this
Do you specifically need to load the chart code via AJAX? This is likely
to be difficult to implement; I know several people have posted a question
like this over the past few years, but I do not know of any successes off
the top of my head (searching the forum may prove me wrong, however).
You can use the DOMParser object
https://developer.mozilla.org/en-US/docs/Web/API/DOMParser to parse an
XML document. IE 8 does not have the DOMParser object though, so if you
have to support IE 8, follow this guide
The charts are drawn entirely in the browser, so you don't need anything
special in NodeJS for them. Accessing the database through Node should be
possible, but you'll have better luck getting help with that on
StackOverflow http://stackoverflow.com/ than here.
On Tuesday, September 23, 2014
Alternatively, you can keep markers mode on, and use a different location
for geocoding, like Iqaluit: http://jsfiddle.net/asgallant/5bw0vd13/1/
On Tuesday, September 23, 2014 11:56:04 AM UTC-4, Sergey wrote:
Hi Alicia, the issue you're seeing is that the marker is placed outside of
your
You can't get an x to click, but you can make the bars disappear on click
with a bit of hackery:
function drawChart() {
var data = google.visualization.arrayToDataTable([
['Year', 'Sales', 'Show Sales', 'Expenses', 'Show Expenses'],
['2004', 1000, true, 400, true],
Use an AnnotationChart, not a LineChart (the AnnotationChart is the
replacement for the AnnotatedTimeline), as an example:
chartTemperature = new google.visualization.AnnotationChart
(document.getElementById('columnchart'));
You should have 1 google.load call that looks like this:
Some of those features are supported out-of-the-box, others will require
some degree of custom coding to implement. There are a few features that I
am not sure what you are asking for, and would need more information before
I can give an answer on.
1) yes
2) yes, with custom coding
3) yes
4)
/wy1wy6qh/
only the title is displayed. hAxis title is not displayed . The text on
hAxis is set to slanted but it does not appear so.
On Saturday, September 20, 2014 5:13:04 AM UTC+5:30, Andrew Gallant wrote:
You should not wrap any options in a ui option for the charts
(columns);
var chart = new window.google.visualization.LineChart(document.
querySelector('#chart'));
chart.draw(view, options);
I can't indicate the Line Chart and the Curve groups.
Thanks
Am Dienstag, 16. September 2014 01:21:24 UTC+2 schrieb Andrew Gallant:
Is this what you
: {
axis: 'horizontal',
keepInBounds: true,
maxZoomIn: 0,
zoomDelta: 1.5,
},
And I have incorrect times if I use nulls to create spaces between the
groups.
Thanks
Am Dienstag, 16. September 2014 01:21:24 UTC+2 schrieb Andrew Gallant
This will be easier to demonstrate with both genders. First, adjust your
query to group by gender:
$query=SELECT sex_emp, COUNT( * ) AS cnt FROM empleado GROUP BY sex_emp;
and build your DataTable like this:
$table = array(
'cols' = array(
array('label' = 'Gender', 'type =
Can you post a link to the page I can use to test this, or example code
that reproduces the problem?
On Friday, September 19, 2014 4:45:51 AM UTC-4, Ákos Kovács wrote:
I have a Google Timeline based graph. It was worked properly, perfectly. I
have percived yesterday, that it gives only a
You can pivot the data as in my eample, and then use a DataView to create
your Others column:
var othersView = new google.visualization.DataView(pivotedData);
othersView.setColumns([0, 1, 3, {
type: 'number',
label: 'Others',
calc: function (dt, row) {
return dt.getValue(row,
You should not wrap any options in a ui option for the charts. There are
controls with a ui option, but no charts with one. Your wrapper should
look like this:
var chart = new google.visualization.ChartWrapper({
chartType: 'ColumnChart',
containerId: 'chart_div',
dataTable: data,
are
displayed as Jan 2012,Feb 2013which is different from the format passed
from the modifier function.
On Friday, September 19, 2014 6:25:28 AM UTC+5:30, Andrew Gallant wrote:
You should return formatted Date objects from the getMonths function,
instead of returning a string:
var result
You need to call filter.setDataTable in the handler:
document.getElementbyId('btnGetData').onclick = function()
{
data = GetData();
filter.setDataTable(data);
filter.draw();
}
On Friday, September 19, 2014 12:16:23 PM UTC-4, Shivani Kanakhara wrote:
I am using a category filter
You can do this with the hAxis.ticks option:
hAxis: {
format: 'hh:mm', // default formatting
ticks: [
// specify tick marks every hour
{v: new Date(2014, 8, 19, 0), f: 'Sep 19, 12AM'}, // override
default formatting
new Date(2014, 8, 19, 1),
new Date(2014,
You should return formatted Date objects from the getMonths function,
instead of returning a string:
var result = google.visualization.data.group(
data,
[{ column: 0, modifier: getMonths, type: 'date'}],
[{ 'column': 1, 'aggregation': google.visualization.data.sum, 'type':
'number'
You have to query each tab in the spreadsheet separately. Depending on how
your sheets are laid out, it may also be necessary to make multiple queries
per tab if your charts need data from sections of the sheet that are laid
out differently.
On Thursday, September 18, 2014 1:46:08 PM UTC-4,
You can group your data using the google.visualization.data.group
https://google-developers.appspot.com/chart/interactive/docs/reference#google_visualization_data_group
function. Hook up an event handler on your dropdown that groups your data
appropriately (you will want to use a modifier
1 - 100 of 688 matches
Mail list logo