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: http://jsfiddle.net/asgallant/N2WX2/8/ On Tuesday, March 18, 2014 4:05:36 PM UTC-4, Doug Elder wrote: > > Yes it should be the first store in the data table and the Title should be > Division Breakdown for 'store name here'. Thank you very much for your > help. Your example has been extremely helpful. I actually found another > example of yours that showed me how to change the name on the change. I > just can't seem to figure out how to set the default. Thanks again. > > On Tuesday, March 18, 2014 3:59:37 PM UTC-4, asgallant wrote: >> >> 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 with the highest value in "Value 1", or something else? >> >> On Tuesday, March 18, 2014 3:12:36 PM UTC-4, Doug Elder wrote: >>> >>> 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 >>> that would probably give me insight into that. >>> >>> On Tuesday, March 18, 2014 8:44:20 AM UTC-4, Doug Elder wrote: >>>> >>>> Here is the chart image. >>>> >>>> >>>> On Tue, Mar 18, 2014 at 8:43 AM, Doug Elder wrote: >>>> >>>>> Must be worse at this than I though. I can't get it to work in >>>>> jsfiddle. Here it is : http://jsfiddle.net/delder818/N2WX2/6/ >>>>> I commented out my json stuff and made up data. What is confusing to >>>>> me is the view on data. I could have 5 sets of data or 25 in my chart. >>>>> Here >>>>> is what it looks like now (not based on the jsfiddle code) >>>>> >>>>> >>>>> >>>>> On Monday, March 17, 2014 5:35:27 PM UTC-4, asgallant wrote: >>>>>> >>>>>> 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 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 chart. Since I'm new to this not even sure how to debug this >>>>>>> issue. >>>>>>> >>>>>>> On Friday, March 14, 2014 12:28:16 PM UTC-4, asgallant wrote: >>>>>>>> >>>>>>>> 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 = chart2.getView(); >>>>>>>> view.rows = rows; >>>>>>>> chart2.setView(view); >>>>>>>> chart2.draw(); >>>>>>>> }); >>>>>>>> >>>>>>>> and the only requirement here is that the drilldown and filtering >>>>>>>> happens on column 0 in both DataTables (and you can change that to be >>>>>>>> a >>>>>>>> different column, if necessary). Whether the data is dynamic or not >>>>>>>> is >>>>>>>> irrelevant. >>>>>>>> >>>>>>>> On Friday, March 14, 2014 10:55:01 AM UTC-4, Doug Elder wrote: >>>>>>>>> >>>>>>>>> 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 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 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 a topic in the >>>>> Google Groups "Google Visualization API" group. >>>>> To unsubscribe from this topic, visit >>>>> https://groups.google.com/d/topic/google-visualization-api/NqSGcrqOjYc/unsubscribe >>>>> . >>>>> To unsubscribe from this group and all its topics, send an email to >>>>> [email protected]. >>>>> To post to this group, send email to [email protected]. >>>>> Visit this group at >>>>> http://groups.google.com/group/google-visualization-api. >>>>> For more options, visit https://groups.google.com/d/optout. >>>>> >>>> >>>> -- 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 [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/google-visualization-api. For more options, visit https://groups.google.com/d/optout.
