Pie Chart woes

I'm currently trying to add a Pie chart into a reporting page.
The report is doing a record type query and simply pulling back 

Id
Items

The issue is my Items are an array

The DB table looks like 


1 Widget

2 Widget / Whatsit

3 Whatsit / Dohicky


i would like my pie to show a slice for each item, but at the moment I'm getting a slice per item (so 3 in total)
How can i split the data so i have a slice for widgets (2 items), a slice for whatsits (2 items)and one for dohicky (i item)

  Discussion posts and replies are publicly visible

Parents Reply Children