181
Views
8
Comments
Bar charts
Question

Hello Everyone...

Can you guys please help me with the usage of charts... I have data in Excel sheet which i want to plot using Bar or Column chart

mvp_badge
MVP
Rank: #39

Hi Poorvi,

Have you checked out this link?

https://success.outsystems.com/Documentation/11/Reference/OutSystems_APIs/Charts_API/Create_Column_and_Bar_Charts

Do you already have the data within your application? What is your current status?

Rank: #17446

Sir i Am trying to import the data in the sourceDataPointList (Its in the Property Pane of Column Chart)....But on selecting the Entity it is Showing error.....Can you tell me what should i fill in it


mvp_badge
MVP
Rank: #2

Hi Poorvi,

What Entity do you "select" and how? What kind of error is showing?

Rank: #17446

Sir 

i was trying to plot sales vs target (consisting of 30 points,Values were specified in excel table) But its not working as the chart asks for SourceDataPointList and on selecting sheet1 it shows error that incorrect datatype or Getsheet1 identifier should be determined  ........Please guide me Sir I have to Plot the chart for this data ....I am new to Outsystem 

Thank you

Datapic.PNG

Rank: #17446

the data is shown in image for which i need graph


mvp_badge
MVP
Rank: #39

Hi Poorvi,

The chart asks you for a DataPoint List and you're trying to feed it your Excel directly. You'll need to convert the data in your Excel into a DataPoint List that you can then feed into your chart.

Create a local variable of the DataPoint List type, cycle through the data in your Excel, fill out the List, and then feed that List to your Chart widget on the screen.

mvp_badge
MVP
Rank: #2

@Afonso: that's bad advice! You can directly assign + map the Excel output to a DataPoint List! And even if you couldn't you wouldn't "cycle through the data", it's inefficient and unnecessary!

mvp_badge
MVP
Rank: #39

While you can directly map the Excel output into a DataPoint List, if you want to create different data series and customise sets of datapoints, it's clearer inside an explicit cycle. Normally, I'd just offload that logic work to the database and have it send out the list, but if Poorvi is working with an Excel file, it's going to depend on wanting to have that extra step of saving the results to an Entity.

I wouldn't recommend it if you're holding a list with half a million DataPoints, but there are plenty of cases where I'd gladly cycle through a few dozen records to make an action more legible. I should have made this clear in the original comment!

But I do agree that directly mapping those attributes in simpler cases is the best. Thank you for the heads up.