Hello guys,
I'm using the component XYChart in perspective, I'm getting data from query binding as dataset
Is possible to create series dynamically based in the amount of columns, in the dataset? because my columns can go from 3 to 26.
If you guys can point me in the right direction i will appreciate, also I'm no sure if this is the right approach.
thanks.
You would need to make a project script that will loop through your dataset and then build the series array to apply to the chart. Then you would call this script via a runscript call or a script transform on a binding to the series property.
The other way is to install the Integration Toolkit from pturmel and utilize the forEach() expression method coupled with the columnsOf() method to build the series in an expression binding.
