Graphing with Velocity

Hello Everybody

I’m experimenting with VELOCITY-Reports.
I have seen all the examples with fixed data.

My data is always the result from an sql-command.
Example:
[code
var vquery = “select type,count(type) as anzahl from xyz group by type”
var result = databaseManager.getDatasetByQuery(“MyServer”,vquery,null,-1)
][/code]
I don’t know how many records(types) i will get.

Now i want to show the result in a barchart:
One bar for each record,xaxis.labels = anzahl,labels = type
maxValue = max(anzahl) from result
barcolors = default

or in a piechart:
one slice for each type, legend = typ, label = anzahl

Can someone give me an example for getPieChartDef() and getbarchartDef()
to get the wanted graphs.

Regards
Albert