Dataset in Bar or Pie Char from API result set (in table)

Queries and Resources
1

I am new here, Is it possible to have Bar or Pie chart dataset source from the API result set?

2

Yes that is definitely possible. In your chart you’ll have to edit the values field here:

3

It takes an array of numbers. So if your API call is called query1 and it returns an array of numbers you should be able to just write {{query1.data}} in the values field. If your API call does not return an array of numbers, you could write some Javascript in Retool to quickly transform the data. What does your API call return?

4

Done. but the bar in the chart doesn’t show. My API call return is json.

5

and from json, i put in the table…

6

Done! I am using bulk insert. wow you guys great! thank youuuuu!

7

not yet the bar chart

8

So the bar chart needs to take an array of numbers – you need to either pick out the array of numbers from your json object or run some javascript over the json object to construct the array of numbers – does that make sense?

9

Thanks for the help here @david-dworsky–How do I return only the score (i.e 453)?

10

@taylor In that screenshot, {{score_conversion.data.conversion_score}} would return “453”. Is that what you were looking for?

11

@alex-w --have tried that but continue to get ‘undefined’

12

@Taylor try {{score_conversion.data[0].conversion_score}}, I missed that it was inside an array of one

13

@taylor Did that work for you?

14

Yes, thanks. Looks like the color editor for pie charts isn’t working–it is working on other chart types. I’m using the standalone pie chart option, but it didn’t work in the charts beta either.