Add values to a single column on graph

0
Hello everyone!  I’ve been having trouble with a chart, I want to display just two columns, ok orders and no ok orders. Since I have different reasons why the orders can be no ok (14 in total) when I try to graph it I end with separete columns, something like this: I want to have just one column with the no ok orders, but in a different series than the ok orders.  I tried using the xpath constraint but still have different columns, also tried with a microflow, doing the retrieve and the using operator lists but the graphs stills the same.    Is there a way I can add/sum all the values of the no ok orders in just one column?
asked
1 answers
1

Hi Kenya Castellanos,

Are you using any chart widgets?

If not you can make use of any chart widget from the marketplace. 
You can load the data using JSON Constructed from a microflow.

 

Mendix Any Chat documentation : https://docs.mendix.com/howto7/extensibility/charts-any-usage/

 

 For Stacked Bar charts check the Plotly site for JSON: 

link for your reference : https://plotly.com/javascript/bar-charts/#stacked-bar-chart

 

 Hope it helps!!1

 

answered