GeoCharts can only display one row of data per map unit, so when you have two rows of data for VA, it takes the last row only. If you want to display data for a particular brand, you will have to filter the data for chart to include just one brand at a time. Perhaps a CategoryFilter<https://developers.google.com/chart/interactive/docs/gallery/controls#categoryfilter> would do the trick for you?
On Thursday, July 11, 2013 4:21:47 AM UTC-4, [email protected] wrote: > > Hi, > > I am using geoChart to display following data in country Map > > I have plotted the map using State cloumn and TotalSales($) as value Column > > Now ,the tooltip displays like this : ID TotalSales($_113607.00) > > I have following summary data in datatable > > [image: enter image description here] > > this is my actual data > > [image: enter image description here] > > Now I have added more columns(City,Brandname) to break data from summary > data from first table > > The tooltip displays like this : VA Totalsales($_:34943(City > Fairfax(BrandName sony)))- this is wrong > > But I want to display the tooltip like this : VA Totalsales($_:7768(City > Fairfax(BrandName sony))) - this is correct > > this is my data to display tooltip > > [image: enter image description here] > > From these, what I got is , Geochart takes only last row for display > tooltip,but I want to display particular brand's Totalsales i.e sony -7768$ > > How do I do this? > -- 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/groups/opt_out.
