How do I grouping data in geochart using tooltip column values?

[ranjith...@gmail.com]

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

this is my actual data

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

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?

[asgallant]

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 would do the trick for you?

[ranjith...@gmail.com]

Thanks for your reply,can you tell me how to use category filter for this.....

[asgallant]

Here's an example: http://jsfiddle.net/asgallant/KcCVP/