# 🟢 How to pass array column to Donut chart source? 🟢

**URL:** <https://community.glideapps.com/t/how-to-pass-array-column-to-donut-chart-source/40875>\
**Category:** Ask for Help\
**Created:** [April 19, 2022, 6:27am UTC](https://community.glideapps.com/t/how-to-pass-array-column-to-donut-chart-source/40875 "2022-04-19T06:27:05Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [April 19, 2022, 6:27am UTC](https://community.glideapps.com/t/how-to-pass-array-column-to-donut-chart-source/40875/1 "2022-04-19T06:27:05Z")

</div>

I have 2 Array Columns, called as **1.** Name **2.** Tip, now i want to show this data using the donut chart. So on the left side it should contain names and on the right side it should contain the tip values.  
\*\*

**How to do that?**

\*\*

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/1/c/1c110119c84b6a834836bda92844b4e5d7f0ad05.png)

This donut chart shows column wise values, but i want row wise, and the source values should come from the above mentioned 2 array columns.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/0/0044d7193fe37e6e6f727a2e42a86852fc9d9db7.png)

---

<div class="post-metadata">

**Author:** ![Darren\_Murphy](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/darren_murphy/32/47326_2.png) [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)\
**Post date:** [April 19, 2022, 6:46am UTC](https://community.glideapps.com/t/how-to-pass-array-column-to-donut-chart-source/40875/2 "2022-04-19T06:46:54Z")

</div>

You would need to coerce the arrays into lists. Check out the “Miracle Method”

> [@fishbaguette\_breadbasket Transpose Columns to an Inline List: The Miracle Method](https://community.glideapps.com/t/transpose-columns-to-an-inline-list-the-miracle-method/32766):
>
> 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] ](https://www.youtube.com/watch?v=t-sh_Q3WbQc)

---

<div class="post-metadata">

**Author:** ![Th.Nitin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/th.nitin/32/72291_2.png) [@Th.Nitin](https://community.glideapps.com/u/Th.Nitin)\
**Post date:** [April 19, 2022, 12:09pm UTC](https://community.glideapps.com/t/how-to-pass-array-column-to-donut-chart-source/40875/3 "2022-04-19T12:09:53Z")

</div>

thanks @Darren_Murphy , but the above solution this is not my answer, the charts takes a column as a source, **but i want it to be row oriented** **(where it takes values from the rows rather than the column)**. So i have a 2 row array where one is name and other is tip received, and i want to show that row oriented data like this.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/2/a290d10386ab5f11f71cfc879bf6a7551282f68f.png)

**Use Case** : Suppose a manager has a 2 dummy accounts, and these dummy accounts need to be user specific, So the components for this dummy accounts are mentioned in the column, as can be seen in the below image. 👇

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/0/c078dec396aeea4b0595f9e57554e673e779e431.png)

Now, when the manager if finished with tipping, i want to show him regarding the amount tipped and to whom

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [April 19, 2022, 11:49pm UTC](https://community.glideapps.com/t/how-to-pass-array-column-to-donut-chart-source/40875/4 "2022-04-19T23:49:07Z")

</div>

Why do you have your data in multiple columns like that instead of an external table to store just tips?

It can be:

Tipped by | Tipped for | Tip amount  
[manager1@example.com](mailto:manager1@example.com) | [john@example.com](mailto:john@example.com) | 15  
[manager1@example.com](mailto:manager1@example.com) | [jacob@example.com](mailto:jacob@example.com) | 10

Then you just need a relation to power the chart.
