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

2016-04-22 Thread rajan . bhatt
Hi is this a free chart. actually i am new to this field so want to know that should i use it commercially for free or its chargeable? On Tuesday, January 15, 2013 at 5:41:13 AM UTC+5:30, asgallant wrote: > > Here's an example: http://jsfiddle.net/asgallant/x5Eth/ > > On Monday, January 14, 2013

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

2015-03-13 Thread sourav mondal
Here I have tried a little, may this help you friends http://dotnetawesome.com/mvc/how-to-implement-drill-down-google-chart-in-mvc4 On Tuesday, January 15, 2013 at 4:23:39 AM UTC+5:30, Choy wrote: Here is the format of my chart: http://jsfiddle.net/asgallant/zwPuU/ I would like to add drill

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

2014-08-01 Thread Rk MooRthy Rajendran
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++) {

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

2014-08-01 Thread Rk MooRthy Rajendran
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:

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

2014-08-01 Thread 'Jon Orwant' via Google Visualization API
Some charts support an explorer option, which lets you enable zoom; search for it on the doc page for the appropriate chart. (And the Map Chart has standard Google Maps zooming.) Jon On Fri, Aug 1, 2014 at 8:36 AM, Rk MooRthy Rajendran rkmoorth...@gmail.com wrote: Hi Andrew, Can we have

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

2014-07-31 Thread Andrew Gallant
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],

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

2014-07-30 Thread Rk MooRthy Rajendran
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

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

2014-07-30 Thread Rk MooRthy Rajendran
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

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

2014-07-29 Thread Rk MooRthy Rajendran
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

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

2014-07-29 Thread Andrew Gallant
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

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

2014-07-28 Thread Rk MooRthy Rajendran
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

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

2014-07-28 Thread Andrew Gallant
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,

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

2014-07-28 Thread Rk MooRthy Rajendran
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++) {

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

2014-07-25 Thread Rk MooRthy Rajendran
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,

[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: Drill down functionality for column charts

2014-07-23 Thread Rk MooRthy Rajendran
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

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

2014-04-04 Thread Doug Elder
Quick question. The pie chart click works on my laptop across all the browsers. When I deploy it to our server Microsoft Server 2003 it will not work on IE 9. Is this a limitation of the server? It works on Firefox, Chrome and Safari. Someone mentioned that I needed to be running IE 9 on the

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

2014-04-04 Thread asgallant
The version of IE on your server is irrelevant. What part doesn't work? Do the charts not draw, or is it just the interaction between the charts that doesn't work? Are there any error messages in IE9's developer console (open the page, hit F12 to open the developer tools, go to the console

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

2014-04-04 Thread Doug Elder
This is the error it is giving me. I don't get the error from my pc only when it it running on the server. SCRIPT5007: Unable to get value of the property 'row': object is null or undefined Here is the line of code in question. var division = data2.getValue(sel[0].row, 0); On Fri, Apr 4,

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

2014-04-04 Thread Doug Elder
Based off of your help with me I have two listeners on the page. The first is a line cart that displays a bar chart the second is a pie chart that displays another bar chart. How can it work on my pc and not the server for only IE? It works on Firefox and Chrome.

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

2014-04-01 Thread Doug Elder
Thanks once again. Is there any way to tell if you have clicked on the 1st, 2nd, 3rd etc slice? On Tue, Mar 25, 2014 at 5:23 PM, asgallant drew_gall...@abtassoc.comwrote: Your code is quite close to correct, there were just a few things that needed fixing. Try this:

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

2014-04-01 Thread asgallant
The row returned by sel[0].row tells you which slice was clicked on. On Tuesday, April 1, 2014 3:47:37 PM UTC-4, Doug Elder wrote: Thanks once again. Is there any way to tell if you have clicked on the 1st, 2nd, 3rd etc slice? On Tue, Mar 25, 2014 at 5:23 PM, asgallant

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

2014-04-01 Thread asgallant
You can get the name of the slice by referencing the appropriate column in the DataTable (usually column 0). Getting the slice color is a bit more difficult. Are you setting the colors or slices.slice index.coloroptions? On Tuesday, April 1, 2014 4:05:18 PM UTC-4, Doug Elder wrote: I can

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

2014-04-01 Thread Doug Elder
Yes my rough code was as follows, but row didn't return what I thought. if (sel[0].row == 1) { chart5.setOption('colors', [#0066FF, #6495ED, #87CEFA]); }else if (sel[0].row == 2){ chart5.setOption('colors', [#D52D12, #B2, #FF6A6A ]); }else if (sel[0].column == 3){

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

2014-04-01 Thread asgallant
What do you want to do with the color? The colors option sets the colors for the pie slices to use, where the first slice uses the first color in the array, the second slice uses the second color, etc. On Tuesday, April 1, 2014 4:23:32 PM UTC-4, Doug Elder wrote: Yes my rough code was as

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

2014-04-01 Thread Doug Elder
I'm going to set the bar colors either shades of the pie slice or draw put a border the color of the pie slice selected. I actually just got the shades working now. I have a feeling the border is going to be trickier. On Tue, Apr 1, 2014 at 4:51 PM, asgallant drew_gall...@abtassoc.com wrote:

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

2014-03-25 Thread Doug Elder
Please help, I'm trying to do the same thing from a pie chart to a bar graph and none of it transfers over between it. Here is my jsFiddle: http://jsfiddle.net/delder818/QXJ7Q/2/ I've tried changing it to various getData, getColumnId, GetColumnLabel. I can't seem to figure out the difference in

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

2014-03-25 Thread asgallant
Your code is quite close to correct, there were just a few things that needed fixing. Try this: http://jsfiddle.net/asgallant/QXJ7Q/3/ On Tuesday, March 25, 2014 4:52:43 PM UTC-4, Doug Elder wrote: Please help, I'm trying to do the same thing from a pie chart to a bar graph and none of it

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

2014-03-19 Thread Doug Elder
Perfection! This really gets my feet under me and the chart looks great. It will add just what my customers are looking for. Thank you again for all the help. On Tue, Mar 18, 2014 at 6:28 PM, asgallant drew_gall...@abtassoc.comwrote: Pull the data you want from the DataTable via the #getValue

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

2014-03-18 Thread Doug Elder
I actually think I have it working with the exception of how to set the default row to display and generate the title for chart 2 based on the store name. I can change the chart 2 name on the click of the graph but am having trouble setting it up coming in. If I new how to set the default row

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

2014-03-18 Thread asgallant
Your fiddle was missing the google loader's jsapi script link in the Resources panel. Fixed here: http://jsfiddle.net/asgallant/N2WX2/7/ As far as setting the default value, what criteria do you want to use to determine the default? Should it be the first store in the DataTable, or the store

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

2014-03-18 Thread asgallant
Pull the data you want from the DataTable via the #getValue method. To get the store name in the first row of data, it would be: data.getValue(0, 0); You can use this to set the chart title and to set the filter on the rows. I updated the example with this:

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

2014-03-17 Thread Doug Elder
Almost there. I have both tables showing. The second table shows what I put in as the default row but when I click on a bar it freezes and the second table never updates. The code below is what controls that correct? Only difference I can really see is I have now views set up on the first

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

2014-03-17 Thread asgallant
Post your code (or even better, a jsfiddle example) that demonstrates the problem, and I'll take a look. On Monday, March 17, 2014 10:54:27 AM UTC-4, Doug Elder wrote: Almost there. I have both tables showing. The second table shows what I put in as the default row but when I click on a bar

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

2014-03-14 Thread Doug Elder
Do you have an example using dynamic json data? I'm new to this and don't see how you'd dynamically set the view. Any help would be appreciated. On Monday, January 14, 2013 7:11:13 PM UTC-5, asgallant wrote: Here's an example: http://jsfiddle.net/asgallant/x5Eth/ On Monday, January 14, 2013

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

2014-03-14 Thread asgallant
The important view for the drilldown is this one: google.visualization.events.addListener(chart, 'select', function () { var sel = chart.getChart().getSelection(); var country = data.getValue(sel[0].row, 0); var rows = data2.getFilteredRows([{column: 0, value: country}]); var view

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

2013-01-16 Thread Raji
Awesome, I got it, thank you very much for your help On Monday, January 14, 2013 6:02:50 PM UTC-8, asgallant wrote: Yes, it would just require changing the labels in the second column in that example. On Monday, January 14, 2013 7:14:37 PM UTC-5, Raji wrote: Thank you for the reply.

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

2013-01-14 Thread asgallant
Here's an example: http://jsfiddle.net/asgallant/x5Eth/ On Monday, January 14, 2013 5:53:39 PM UTC-5, Raji 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

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

2013-01-14 Thread Raji
Thank you for the reply. In my case, the x axis labels would change depending on the column clicked. for eg. If US was clicked, the new chart should show x axis : East Coast, Pacific, West Coast If Europe was clicked, the x axis would show European countries etc. can this be done? thank you!

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

2013-01-14 Thread asgallant
Yes, it would just require changing the labels in the second column in that example. On Monday, January 14, 2013 7:14:37 PM UTC-5, Raji wrote: Thank you for the reply. In my case, the x axis labels would change depending on the column clicked. for eg. If US was clicked, the new chart