[Jennifer Häfner]

3 years, 9 months ago #29699

Up

0

Down

::

Hi Christian,

To visualize data with the charts widget, it does not matter from which data source (SQL, SAP, REST, …) the data is loaded. However, the data needs to have a certain structure (depending on the charts type that you want to use, typically an array of ‘labels’ and an array of ‘datasets’ with ‘datapoints’) so that the charts widget can work with it.

In our knowledge base, we have an article that describes how to use the charts widget, and you can also see the necessary data structure there: https://community.simplifier.io/knowledge/using-the-charts-widget/

So in your case: you need to format the data after retrieving it from the SQL connector. You can call the SQL connector directly in a Server Side Business Object and then format the output so that it’s suitable for the charts widget.

Or you can format the data that you have stored in the global variable using a script or a Client Side Business Object.

Let us know if you need further help on this topic.