Pie chart using data from two columns

[dias]

Hey there,

I was looking to make a pie chart using data from two columns on the same table, more specifically Upvotes and Downvotes to make it easier for posters to visualize such things.

Is there a way to display these two columns in the pie chart? I can’t add more than one value source, as is pictured below.

I’ve tried arrays, split text and joined lists but to no avail.

Thanks,
— Dias

[ThinhDinh]

The pie chart reads data vertically (row-by-row), whilst you are trying to read it horizontally (column-by-column).

Quickchart.io: the Cloudinary of Charts —on the fly charts!

GAME CHANGER! Stumbled upon this site today—a way to create on the fly charts using data from your Glide tables. Images render instantly and you can select one of 14 different charts, customize colors, styles etc all through URL parameters! The video below shows my first attempt to create a chart from scratch and implement it in Glide. Took me less than 5 minutes. End result: [Screen Shot 2020-09-17 at 10.10.46 AM] Direct Loom link

I would suggest looking into Quickchart.

[Darren_Murphy]

What is the context in which the chart is displayed?
Is it on a details screen, ie. for just a single row of data?
If that’s the case, what you could do is use a 2 row helper table to transpose the data and use that as the source of the native chart component.

[ThinhDinh]

Transpose Columns to an Inline List: The Miracle Method

I’m often asked how to take columns of data (say form responses) and display them in an inline list. Here’s one way to do it—the MIRACLE METHOD. [Glide: Transpose Data Columns into an Inline List with the MIRACLE METHOD]

Here’s an approach to transpose data.