My aggregate is taken from an external database.
For a Label I get different values, as I want to show them in two different charts with different DataSeriesName. Using Stacked I was assuming, that the charts takes to overall SUM for a label.
Chart 1:
Chart 2:
In Excel Pivot Tables are supporting this. My hope was, that if I use Entities.StackingType.Stacked it would work, but it doesn't
Hi Jens,
Not exactly sure what your question is. In fact, I'm not sure what you mean: you are talking about two charts, but then you seem to talk about two different series in the same charts?
I want to use the data for two different Charts without creating two specialized aggregates.
Reason for that is, to reduce maintenance of the query itself.
and
It seems, that OutSystems charts does not sum up all the values which for a label.
Having a real Pivot-Chart available would solve many problems.
I would expect this is a must-have functionality OutSystem should work on.
Well, let's start with getting a misconception out of the way, OutSystems Charts does very little - under the hood it's Highcharts that's used, so if Highcharts doesn't support something, so doesn't OutSystems charts.
That said, Highcharts does support this, using the stackLabels yAxis property. Here's an example I found. It may visually not be exactly what you need, but Highcharts is highly customizable, so no doubt you can tweak it to make it look like you want. Use the AdvancedFormat property of a chart to add these customization options.
Hi Jens Vogelgesang ,
please go with this post https://www.outsystems.com/forums/discussion/59712/y-axis-for-multiple-data-series/
Hope this will solve your problem.
Hi Ashish,
Please read the question before replying! That post has absolutely nothing to do with OPs question!
Hello OP, if I am understanding your post correctly you want to have 2 Charts with both of them are stacked and have a total be displayed?
Then I would suggest using the OutSystems Charts HighChartsJSON and customize it according to your needs.I have attached a link on how you can do it.https://jsfiddle.net/ramayjendale/r7640ysc/14/