This isn't documented but you can use the "formatted value" ( setFormattedValue) of the DataTable cells in column 0 to control the displayed string. So the cell would contain the fruit + region ID as value, and the fruit only as formatted value.
On Thu, Mar 17, 2011 at 12:42 AM, Gordon <[email protected]> wrote: > I am trying to create a data visualization that allows a user to dive > deeper into the data. I thought a tree map would a good way for > someone to dive into my data. I have run into a little problem with > the tree map though. I have reoccurring data below each node, and the > only way I can make it appear is by making each variable unique. An > example of the problem is below > > regionid parentid state.area state.area.log > 1 USA <NA> 100.0 15.10154 > 2 Northeast USA 25.0 12.03974 > 3 South USA 25.0 13.70966 > 4 North Central USA 25.0 13.54832 > 5 West USA 25.0 14.39435 > 6 Banana Northeast 12.5 25.00000 > 7 Apple Northeast 12.5 25.00000 > 8 Banana South 12.5 25.00000 > 9 Apple South 12.5 25.00000 > 10 Banana North Central 12.5 25.00000 > 11 Apple North Central 12.5 25.00000 > 12 Banana West 8.0 16.00000 > 13 Apple West 8.0 16.00000 > 14 Strawberry West 9.0 18.00000 > > When I run this it puts all the Apple's and Banana's in the Northeast > and only leaves Strawberry in the West. I know i can fix the solution > by appending the region to the fruit (i.e. Apple-West) but this > solution isn't as clean as i would like in presentation. Any one have > a solution or suggest a new visualization? > > -- > You received this message because you are subscribed to the Google Groups > "Google Visualization API" group. > To post to this group, send email to > [email protected]. > To unsubscribe from this group, send email to > [email protected]. > For more options, visit this group at > http://groups.google.com/group/google-visualization-api?hl=en. > > -- You received this message because you are subscribed to the Google Groups "Google Visualization API" group. To post to this group, send email to [email protected]. To unsubscribe from this group, send email to [email protected]. For more options, visit this group at http://groups.google.com/group/google-visualization-api?hl=en.
