How to create a pie chart from strings in XML file?

[zaplec]

Hi A new user here.

I have a XML file which contains lots of products and their types etc info. For example a lot simplified version would be like this

<container>  <product>   <type>Apple</type>  </product>  <product>  <type>Orange</type> </product></container>[/code]

 

Now I would need to create a pie chart where each slice would represent the types of the products. How could I do that?

I've tried to create variables for each types, so that the variable calculation is count and expression is $F{Type}.equals("Orange") and so on for each type. Is this a correct way to approach this? If I add these to a pie chart, it shows countless slices with each representing one increment and label just showing which slice is of what type. For example I can have a pie chart having 10 slices of Oranges, each representing one orange and then 20 slices of Apples.