Forum Discussion

amitpatil's avatar
amitpatil
Data Storage
05-05-2025
Solved

Extract Object Data from the column

Hi, My data is in an Object in a column. I want to use that data to showcase in the Line chart. Currently I am using compose SDK to create a Line chart. Could anyone can help me to extract that data...
  • bogdan-karlenko's avatar
    bogdan-karlenko
    05-05-2025

    Hi amitpatil, thanks for your question!

    Based on the format of your data, it looks like you're not querying directly from a Sisense instance but using an external data source instead. In that case, you'll need to ensure your data is structured appropriately for the Line chart component.

    Here’s a simple example, assuming you’d like to build a double Line chart (since you have two values per data point) plotted over time:


    You can use standard JavaScript methods to extract and manipulate data from objects and arrays. Since your column contains objects like `{"sales": [1570.73, 1020.58]}`, you can access the sales data using something like `row.sales` (assuming each row is an object). You might want to look into `map()` to transform your dataset into the required format.

    Hope this helps!

  • AssafHanina's avatar
    AssafHanina
    05-07-2025

    Hey amitpatil ,

    If the data is being pulled directly into the Sisense ElastiCube, you can apply the transformation using the Custom Code feature.
    Custom Code Feature allows you to run a Jupyter notebook during the build process to transform the data, such as modifying the Object column, and return a DataFrame that can then be used in a Line Chart.

    Best regards

bogdan-karlenko's avatar
bogdan-karlenko
Sisense Employee
05-05-2025

Hi amitpatil, thanks for your question!

Based on the format of your data, it looks like you're not querying directly from a Sisense instance but using an external data source instead. In that case, you'll need to ensure your data is structured appropriately for the Line chart component.

Here’s a simple example, assuming you’d like to build a double Line chart (since you have two values per data point) plotted over time:


You can use standard JavaScript methods to extract and manipulate data from objects and arrays. Since your column contains objects like `{"sales": [1570.73, 1020.58]}`, you can access the sales data using something like `row.sales` (assuming each row is an object). You might want to look into `map()` to transform your dataset into the required format.

Hope this helps!

amitpatil's avatar
amitpatil
Data Storage
05-06-2025

Thank you for the response bogdan-karlenko.

I am using compose SDK to embed the Line chart in my application. I connected the DB to Sisense and from the Sisense I am using following command to generate the data model representation of the table.

npx @sisense/sdk-cli@latest get-data-model --username "<username>" --output src/sample-ecommerce.ts --dataSource "Sample ECommerce" --url <your_instance_url>


Using this data model to plot the Line chart like this

<SisenseContextProvider
url="<instance url>" // replace with the URL of your Sisense instance
token="<api token>" // replace with the API token of your user account
>
<Chart
dataSet={DM.DataSource}
chartType={'line'}
dataOptions={{
category: [DM.Commerce.AgeRange],
value: [measureFactory.sum(DM.Commerce.Revenue)],
breakBy: [],
}}
styleOptions={{
legend: {
enabled: true,
position: 'bottom',
},
}}
onDataPointClick={(point, nativeEvent) => {
console.log('clicked', point, nativeEvent);
}}
/>
</SisenseContextProvide


As my data is in an Object {sale:[123,1212,232, 564]}. It is not working properly. So I just want to know is there any way we can extract the data from the generated Data Model?