[visualization-api] Re: Drill down functionality for column charts
Hi Andrew,
Thanks for your reply.
-Rk.MooRthy
On Thursday, 31 July 2014 18:33:08 UTC+5:30, Andrew Gallant wrote:
Try this:
var rawData = [{...}]; // your web service data
var myData = [['Categories','ConvToSales','NotConvSales']];
for (var i = 0; i rawData[0].categories1.length; i++) {
myData.push([
rawData[0].categories1[i],
rawData[0].convToSales1[i],
rawData[0].NotConvToSales1[i]
]);
}
var data = google.visualization.arrayToDataTable(myData);
On Thursday, July 31, 2014 1:33:25 AM UTC-4, Rk MooRthy Rajendran wrote:
Hi Andrew,
I have to plot charts using Google API with web service data, The web
service result is in Json format.
So need to convert the Json format into Multi dimensional array for
render the chart.
This is my web service data :
[{categories1: [TOTAL,GROUND FLOOR-GOLD,FIRST FLOOR-GOLD,FIRST
FLOOR-DIAMOND,FIRST FLOOR-PLATINUM,SECOND
FLOOR-GOLD,YOUNGONES-GOLD,YOUNGONES-DIAMOND,YOUNGONES-PLATINUM,YOUNGONES-SILVER,SILVERMINE-GF,SILVERMINE-FF,SILVER
JEWELLERY,HANDICRAFT],
convToSales1:[77131,22556,3998,1187,315,5626,6683,151,48,3427,19984,4972,7042,1142],NotConvSales1:[10073,2751,630,266,67,1001,955,68,15,221,2629,1094,321,55]}]
Need to convert the above json into following format :
[['Categories','ConvToSales','NotConvSales'],
['YOUNGONES-DIAMOND',126,514],['YOUNGONES-PLATINUM',555,552],
['YOUNGONES-SILVER',645,154],['SILVERMINE-GF',5029,687],
['SILVER JEWELLERY',164,179],['HANDICRAFT',335,212]]
Do you have any idea to converting the data
Thanks in Advance..
-Rk.MooRthy
On Wednesday, 30 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://developers.google.com/chart/interactive/docs/gallery/combochart
to combine both columns and lines. Use the series.series
index.targetAxisIndex option to assign each data series to either the
left
(axis index 0) or right (axis index 1) y-axes. Use the vAxes.axis index
option to set options for the axes (which work the same as the vAxis
options). The drilldown stuff should work exactly the same.
On Tuesday, July 29, 2014 2:33:29 AM UTC-4, Rk MooRthy Rajendran wrote:
Hi Andrew,
Do you have any idea to plot the above chart which i have
attached..(PFA)
The chart contains Drill down functionality and Dual Y-Axis.
Thanks in advance..
-Rk.MooRthy
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i);
}
var pct = val / total;
var formattedValue = dt.getFormattedValue(row, x) +
' (' + (pct * 100).toFixed(2) + '%)';
return {v: pct, f: formattedValue};
};
})(i)
});
}
var view = new google.visualization.DataView(data);
view.setColumns(columns);
On Monday, July 28, 2014 2:32:29 AM UTC-4, Rk MooRthy Rajendran
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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy
Rajendran wrote:
Thanks, Its working fine
-Rk,MooRthy
On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote:
Here is the format of my chart:
http://jsfiddle.net/asgallant/zwPuU/
I would like to add drill down functionality - Clicking on USA
should yield another chart with US states etc. All the charts
would be
clickable to a drill down version.
I understand I have to use the selection event, could you give
me an example of that?
Thanks in advance!
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday
[visualization-api] Re: Drill down functionality for column charts
Hi Andrew,
Can we have zoom options in Google charts... How to set it..
-Rk.MooRthy
On Friday, 1 August 2014 18:05:18 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your reply.
-Rk.MooRthy
On Thursday, 31 July 2014 18:33:08 UTC+5:30, Andrew Gallant wrote:
Try this:
var rawData = [{...}]; // your web service data
var myData = [['Categories','ConvToSales','NotConvSales']];
for (var i = 0; i rawData[0].categories1.length; i++) {
myData.push([
rawData[0].categories1[i],
rawData[0].convToSales1[i],
rawData[0].NotConvToSales1[i]
]);
}
var data = google.visualization.arrayToDataTable(myData);
On Thursday, July 31, 2014 1:33:25 AM UTC-4, Rk MooRthy Rajendran wrote:
Hi Andrew,
I have to plot charts using Google API with web service data, The web
service result is in Json format.
So need to convert the Json format into Multi dimensional array for
render the chart.
This is my web service data :
[{categories1: [TOTAL,GROUND FLOOR-GOLD,FIRST FLOOR-GOLD,FIRST
FLOOR-DIAMOND,FIRST FLOOR-PLATINUM,SECOND
FLOOR-GOLD,YOUNGONES-GOLD,YOUNGONES-DIAMOND,YOUNGONES-PLATINUM,YOUNGONES-SILVER,SILVERMINE-GF,SILVERMINE-FF,SILVER
JEWELLERY,HANDICRAFT],
convToSales1:[77131,22556,3998,1187,315,5626,6683,151,48,3427,19984,4972,7042,1142],NotConvSales1:[10073,2751,630,266,67,1001,955,68,15,221,2629,1094,321,55]}]
Need to convert the above json into following format :
[['Categories','ConvToSales','NotConvSales'],
['YOUNGONES-DIAMOND',126,514],['YOUNGONES-PLATINUM',555,552],
['YOUNGONES-SILVER',645,154],['SILVERMINE-GF',5029,687],
['SILVER JEWELLERY',164,179],['HANDICRAFT',335,212]]
Do you have any idea to converting the data
Thanks in Advance..
-Rk.MooRthy
On Wednesday, 30 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://developers.google.com/chart/interactive/docs/gallery/combochart
to combine both columns and lines. Use the series.series
index.targetAxisIndex option to assign each data series to either the
left
(axis index 0) or right (axis index 1) y-axes. Use the vAxes.axis
index
option to set options for the axes (which work the same as the vAxis
options). The drilldown stuff should work exactly the same.
On Tuesday, July 29, 2014 2:33:29 AM UTC-4, Rk MooRthy Rajendran wrote:
Hi Andrew,
Do you have any idea to plot the above chart which i have
attached..(PFA)
The chart contains Drill down functionality and Dual Y-Axis.
Thanks in advance..
-Rk.MooRthy
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran
wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i);
}
var pct = val / total;
var formattedValue = dt.getFormattedValue(row, x) +
' (' + (pct * 100).toFixed(2) + '%)';
return {v: pct, f: formattedValue};
};
})(i)
});
}
var view = new google.visualization.DataView(data);
view.setColumns(columns);
On Monday, July 28, 2014 2:32:29 AM UTC-4, Rk MooRthy Rajendran
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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy
Rajendran wrote:
Thanks, Its working fine
-Rk,MooRthy
On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote:
Here is the format of my chart:
http://jsfiddle.net/asgallant/zwPuU/
I would like to add drill down functionality - Clicking on USA
should yield another chart with US states etc. All the charts
would be
clickable to a drill down version.
I understand I have to use the selection event, could you give
me an example
[visualization-api] Re: Drill down functionality for column charts
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://developers.google.com/chart/interactive/docs/gallery/combochart
to combine both columns and lines. Use the series.series
index.targetAxisIndex option to assign each data series to either the left
(axis index 0) or right (axis index 1) y-axes. Use the vAxes.axis index
option to set options for the axes (which work the same as the vAxis
options). The drilldown stuff should work exactly the same.
On Tuesday, July 29, 2014 2:33:29 AM UTC-4, Rk MooRthy Rajendran wrote:
Hi Andrew,
Do you have any idea to plot the above chart which i have attached..(PFA)
The chart contains Drill down functionality and Dual Y-Axis.
Thanks in advance..
-Rk.MooRthy
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i);
}
var pct = val / total;
var formattedValue = dt.getFormattedValue(row, x) + '
(' + (pct * 100).toFixed(2) + '%)';
return {v: pct, f: formattedValue};
};
})(i)
});
}
var view = new google.visualization.DataView(data);
view.setColumns(columns);
On Monday, July 28, 2014 2:32:29 AM UTC-4, Rk MooRthy Rajendran 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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy Rajendran
wrote:
Thanks, Its working fine
-Rk,MooRthy
On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote:
Here is the format of my chart:
http://jsfiddle.net/asgallant/zwPuU/
I would like to add drill down functionality - Clicking on USA
should yield another chart with US states etc. All the charts would
be
clickable to a drill down version.
I understand I have to use the selection event, could you give me
an example of that?
Thanks in advance!
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i);
}
var pct = val / total;
var formattedValue = dt.getFormattedValue(row, x) + '
(' + (pct * 100).toFixed(2) + '%)';
return {v: pct, f: formattedValue};
};
})(i)
});
}
var view = new google.visualization.DataView(data);
view.setColumns(columns);
On Monday, July 28, 2014 2:32:29 AM UTC-4, Rk MooRthy Rajendran 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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy Rajendran
wrote:
Thanks, Its working fine
-Rk,MooRthy
On Tuesday, 15 January
[visualization-api] Re: Drill down functionality for column charts
Hi Andrew,
I have to plot charts using Google API with web service data, The web
service result is in Json format.
So need to convert the Json format into Multi dimensional array for render
the chart.
This is my web service data :
[{categories1: [TOTAL,GROUND FLOOR-GOLD,FIRST FLOOR-GOLD,FIRST
FLOOR-DIAMOND,FIRST FLOOR-PLATINUM,SECOND
FLOOR-GOLD,YOUNGONES-GOLD,YOUNGONES-DIAMOND,YOUNGONES-PLATINUM,YOUNGONES-SILVER,SILVERMINE-GF,SILVERMINE-FF,SILVER
JEWELLERY,HANDICRAFT],
convToSales1:[77131,22556,3998,1187,315,5626,6683,151,48,3427,19984,4972,7042,1142],NotConvSales1:[10073,2751,630,266,67,1001,955,68,15,221,2629,1094,321,55]}]
Need to convert the above json into following format :
[['Categories','ConvToSales','NotConvSales'],
['YOUNGONES-DIAMOND',126,514],['YOUNGONES-PLATINUM',555,552],
['YOUNGONES-SILVER',645,154],['SILVERMINE-GF',5029,687],
['SILVER JEWELLERY',164,179],['HANDICRAFT',335,212]]
Do you have any idea to converting the data
Thanks in Advance..
-Rk.MooRthy
On Wednesday, 30 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://developers.google.com/chart/interactive/docs/gallery/combochart
to combine both columns and lines. Use the series.series
index.targetAxisIndex option to assign each data series to either the left
(axis index 0) or right (axis index 1) y-axes. Use the vAxes.axis index
option to set options for the axes (which work the same as the vAxis
options). The drilldown stuff should work exactly the same.
On Tuesday, July 29, 2014 2:33:29 AM UTC-4, Rk MooRthy Rajendran wrote:
Hi Andrew,
Do you have any idea to plot the above chart which i have attached..(PFA)
The chart contains Drill down functionality and Dual Y-Axis.
Thanks in advance..
-Rk.MooRthy
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i);
}
var pct = val / total;
var formattedValue = dt.getFormattedValue(row, x) + '
(' + (pct * 100).toFixed(2) + '%)';
return {v: pct, f: formattedValue};
};
})(i)
});
}
var view = new google.visualization.DataView(data);
view.setColumns(columns);
On Monday, July 28, 2014 2:32:29 AM UTC-4, Rk MooRthy Rajendran 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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy Rajendran
wrote:
Thanks, Its working fine
-Rk,MooRthy
On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote:
Here is the format of my chart:
http://jsfiddle.net/asgallant/zwPuU/
I would like to add drill down functionality - Clicking on USA
should yield another chart with US states etc. All the charts would
be
clickable to a drill down version.
I understand I have to use the selection event, could you give me
an example of that?
Thanks in advance!
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i
[visualization-api] Re: Drill down functionality for column charts
Hi Andrew,
Do you have any idea to plot the above chart which i have attached..(PFA)
The chart contains Drill down functionality and Dual Y-Axis.
Thanks in advance..
-Rk.MooRthy
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i);
}
var pct = val / total;
var formattedValue = dt.getFormattedValue(row, x) + ' ('
+ (pct * 100).toFixed(2) + '%)';
return {v: pct, f: formattedValue};
};
})(i)
});
}
var view = new google.visualization.DataView(data);
view.setColumns(columns);
On Monday, July 28, 2014 2:32:29 AM UTC-4, Rk MooRthy Rajendran 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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy Rajendran
wrote:
Thanks, Its working fine
-Rk,MooRthy
On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote:
Here is the format of my chart: http://jsfiddle.net/asgallant/zwPuU/
I would like to add drill down functionality - Clicking on USA
should yield another chart with US states etc. All the charts would be
clickable to a drill down version.
I understand I have to use the selection event, could you give me an
example of that?
Thanks in advance!
On Tuesday, 29 July 2014 10:32:21 UTC+5:30, Rk MooRthy Rajendran wrote:
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i);
}
var pct = val / total;
var formattedValue = dt.getFormattedValue(row, x) + ' ('
+ (pct * 100).toFixed(2) + '%)';
return {v: pct, f: formattedValue};
};
})(i)
});
}
var view = new google.visualization.DataView(data);
view.setColumns(columns);
On Monday, July 28, 2014 2:32:29 AM UTC-4, Rk MooRthy Rajendran 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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy Rajendran
wrote:
Thanks, Its working fine
-Rk,MooRthy
On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote:
Here is the format of my chart: http://jsfiddle.net/asgallant/zwPuU/
I would like to add drill down functionality - Clicking on USA
should yield another chart with US states etc. All the charts would be
clickable to a drill down version.
I understand I have to use the selection event, could you give me an
example of that?
Thanks in advance!
--
You received this message because you are subscribed to the Google Groups
Google Visualization API group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com
[visualization-api] Re: Drill down functionality for column charts
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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy Rajendran wrote: Thanks, Its working fine -Rk,MooRthy On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote: Here is the format of my chart: http://jsfiddle.net/asgallant/zwPuU/ I would like to add drill down functionality - Clicking on USA should yield another chart with US states etc. All the charts would be clickable to a drill down version. I understand I have to use the selection event, could you give me an example of that? Thanks in advance! -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Drill down functionality for column charts
Hi Andrew,
Thanks for your valuable reply..
-Rk.Moorthy
On Tuesday, 29 July 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),
calc: (function (x) {
return function (dt, row) {
var val = dt.getValue(row, x);
var total = 0;
for (var i = 1; i dt.getNumberOfColumns(); i++) {
total += dt.getValue(row, i);
}
var pct = val / total;
var formattedValue = dt.getFormattedValue(row, x) + ' (' +
(pct * 100).toFixed(2) + '%)';
return {v: pct, f: formattedValue};
};
})(i)
});
}
var view = new google.visualization.DataView(data);
view.setColumns(columns);
On Monday, July 28, 2014 2:32:29 AM UTC-4, Rk MooRthy Rajendran 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 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 July 2014 12:38:35 UTC+5:30, Rk MooRthy Rajendran
wrote:
Thanks, Its working fine
-Rk,MooRthy
On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote:
Here is the format of my chart: http://jsfiddle.net/asgallant/zwPuU/
I would like to add drill down functionality - Clicking on USA should
yield another chart with US states etc. All the charts would be
clickable
to a drill down version.
I understand I have to use the selection event, could you give me an
example of that?
Thanks in advance!
--
You received this message because you are subscribed to the Google Groups
Google Visualization API group.
To unsubscribe from this group and stop receiving emails from it, send an email
to google-visualization-api+unsubscr...@googlegroups.com.
To post to this group, send email to google-visualization-api@googlegroups.com.
Visit this group at http://groups.google.com/group/google-visualization-api.
For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Drill down functionality for column charts
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 July 2014 12:38:35 UTC+5:30, Rk MooRthy Rajendran wrote: Thanks, Its working fine -Rk,MooRthy On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote: Here is the format of my chart: http://jsfiddle.net/asgallant/zwPuU/ I would like to add drill down functionality - Clicking on USA should yield another chart with US states etc. All the charts would be clickable to a drill down version. I understand I have to use the selection event, could you give me an example of that? Thanks in advance! -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
[visualization-api] Re: Drill down functionality for column charts
Thanks, Its working fine -Rk,MooRthy On Tuesday, 15 January 2013 04:23:39 UTC+5:30, Choy wrote: Here is the format of my chart: http://jsfiddle.net/asgallant/zwPuU/ I would like to add drill down functionality - Clicking on USA should yield another chart with US states etc. All the charts would be clickable to a drill down version. I understand I have to use the selection event, could you give me an example of that? Thanks in advance! -- You received this message because you are subscribed to the Google Groups Google Visualization API group. To unsubscribe from this group and stop receiving emails from it, send an email to google-visualization-api+unsubscr...@googlegroups.com. To post to this group, send email to google-visualization-api@googlegroups.com. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
