Is there a way to create a pie chart from columns of one row ?

[estelle-d]

Hello,

I would like to create a pie chart for the data within one row:
score | serie 1 | serie 2 | serie 3 | serie 4

the score is the full circle and the pie are the "serie n"

that chart will go in the /screen/:id screen

Is it possible?
Thank you
Estelle

[estelle-d]

To give you the context, one row represente a match with the score and number one point in each series, and I would like to create a pie chart for each match without having to create a new table foe each match.

Thank's
Estelle

[melohagan]

Hey @estelle-d

If you are using an external datasource, then you can use a custom query with a transformer to get the data in the shape you need.

If you are using the internal Budibase DB, then there is no way to use multiple column values as segments in the Pie chart. Instead you could use the JSON data type like so:

[estelle-d]

Thank you very much!!!! I thought it may have been possible with an external DB but I couldn't found the info, it's a great news!!!!
I am going to try it out soon... I have reach my passe limitation for this month :(

[phamalda]

Hi, @estelle-d. I know it's been a long time since you posted this thread. Just wanted to check in to see if you were able to get this to work in creating that pie chart. Thanks.