Skip to Content (Press Enter)
2020-09-11 10-49-32
André de Paula
117Views
3Comments
Solved
Create Charts using all results from Aggregate
Question
Charts

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.

MyDinUI.oml
0
0
01 Jul 2020
Copy Link
2021-09-06 15-09-53
Dorine Boudry
 
MVP
Solution

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,

Dorine

MyDinUI.oml
0
0
01 Jul 2020
Copy Link
2020-09-11 10-49-32
André de Paula

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!

0
0
02 Jul 2020
Copy Link
2021-09-06 15-09-53
Dorine Boudry
 
MVP

My pleasure,

Andre


1
0
02 Jul 2020
Copy Link
Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.