Create Charts using all results from Aggregate

Hi folks,

I can't find the answer or solution for what I need in my chart. 

I would like to show in a chart columns the results from an Aggregate, however I only managed to show only one result and not all results.

I'm sending some images and a OML for to show better what I have doing.

If someone can show me a way to do it, I will appreciate that. 

Thanks for your time.


Hi Andre,

the way you've built it now, you are literally only adding exactly 2 datapoints

I'm guessing you were trying to find a way to add 2 dataseries and tried to do it this way.  For adding more than 1 dataseries, a.f.a.i.k. you have to create a datapoint list, mapping an aggregate result directly won't allow for more than 1 dataseries.  If anyone knows of a way, please comment, I'd be interested.

So the way to do it is to build a datapointlist, adding 2 datapoints per record of your aggregate, one for each data series.

See attached oml, I don't understand portuguese, but I think it is roughly what you need.

Good luck,



Hi Dorine,

First of all, thanks for your support. Your solution was exactly what I needed. Thank you so much for share your knowledge and help me to solve this problem.

All the best for you!

My pleasure,