48
Views
4
Comments
[How to use OutSystems Charts Web] Stacking Type - How are we getting 4 Labels if there are only 3 conditions Type?
Question
how-to-use-charts
Web icon
Forge asset by OutSystems Lab

Could you please explain in detail how this chart data is created with 2 Electronics label, 1 Book label and 1 Clothing label in column chart?

Thanks!

2022-05-06 16-37-40
Joseph Danne Enriquez

Check how many groups of rows is grouped by with ProductType as Electronics.

UserImage.jpg
Deepti Gargama

5 rows are getting grouped when  productType = Electronics



2021-09-06 15-09-53
Dorine Boudry
 
MVP

Hi Deepti,

I think that maybe the people making this tutorial were more focused on showing the different options you have to work with on a chart, rather then getting the data right.

Basically, like Joseph said, you have to make sure that the aggregate or SQL or server action that is retrieving the data for this chart, has no more than one row per label / series pair.

So in this example, I would group by ProductType and Condition.

See attached OML, I added a Demo screen to the ChartsHowTo.

Hope this explains it for you, I wouldn't pay too much attention to the data, but try to understand the features that the HowTo component is showcasing.

Dorine


edit

compared to your aggregate, this is what mine looks like :

ChartsHowToWithExtraScreen.oml
UserImage.jpg
Deepti Gargama

Thanks Joseph and Dorine for your response.

I agree to the point that our focus should be more on 'HowTo' rather than 'data' for this component. However, I need a clear understanding/explanation for the charts data rendered on the screen. It should be similar to data set which we expect by applying filters/groupings on various table in order to keep our concepts clear.

Community GuidelinesBe kind and respectful, give credit to the original source of content, and search for duplicates before posting.