Pie Charts

[thorinas]

Hi,

I wonder if anyone can help I'm trying to make a pie chart that shows the percentage of vehicles that have a cretin tag ie, vor, in service, mot, ect.

Iv made the field an option field where they just chose the correct tag and created a pie chart but its not displaying the data correctly, do i need to add code to the block?

[ConorWebb96]

Hey @thorinas,

You likely will need change the option you've selected for the data column. This needs a number for it to work. Your best bet would be including these numbers somewhere within your table row, so these can then be used to populate your pie chart.

Your field may be called percentage_of_vehicles with the number contained within that will be used to populate the pie chart.

I hope this helps.

[thorinas]

Sorry how would that work. As all I need it to do is to count the number of times that word is found.

[ConorWebb96]

Sounds like you need to use custom queries.

You may be able to do grouping using the rest api along with the public api. As you are able to write JS that could do the grouping of data for you within the transformer.

[phamalda]

Good day, all. I just created a new thread around creating a pie chart. @ConorWebb96, I'm really curious if you have any documented steps in employing those rest api and public api steps. Not sure if that's possible with an existing Budibase table. Thanks a ton for everyone's time and effort.