# Data sourcing from multiple tables?

**URL:** <https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148>\
**Category:** Ask for Help\
**Created:** [March 29, 2024, 2:13am UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148 "2024-03-29T02:13:01Z")\
**Posts on this page:** 10\
**Page:** 1

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [March 29, 2024, 2:13am UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/1 "2024-03-29T02:13:01Z")

</div>

I need to pull data from two different tables in order to complete my charts.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/3/3/337c8aa198959e98e624d7c75c3de454333d83d8.jpeg)

However, if I try to switch a components source to a different table, the component will disappear no matter how I arrange the content. Am I missing something?

---

<div class="post-metadata">

**Author:** ![Himaladin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/himaladin/32/71023_2.png) [@Himaladin](https://community.glideapps.com/u/Himaladin)\
**Post date:** [March 29, 2024, 4:06am UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/2 "2024-03-29T04:06:03Z")

</div>

Try removing that component and replacing it with a new one, does the issue still occur?

---

<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:** [March 29, 2024, 2:37pm UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/3 "2024-03-29T14:37:54Z")

</div>

Why do you need to pull data from two different tables in the first place?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [March 29, 2024, 7:39pm UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/4 "2024-03-29T19:39:42Z")

</div>

Some of the data I was able to pull right from the GA source table, but some of the data I needed to make averages that required a pivot table.

For example “total views” vs “average time spent on profile per user”

---

<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:** [March 29, 2024, 11:04pm UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/5 "2024-03-29T23:04:50Z")

</div>

So ultimately what type of chart do you want to make with those pieces of data?

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [April 1, 2024, 12:43am UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/6 "2024-04-01T00:43:12Z")

</div>

I’m currently just trying to re-create my analytics dashboard for each user from the old app to the new one.

This is what I doing previously:

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/c/e/ce3a85f75f97c53651ce739f904b0c606a68fdbf.jpeg)  
 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/4/848111a713d7b13bae8cf2e01aee09c39df454b5.jpeg)

And as you can see here, I was pulling from 2 different tables, so that’s why I was confused why I was struggling with it!

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [April 1, 2024, 12:45am UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/7 "2024-04-01T00:45:29Z")

</div>

I was also able to capture a top ten list on the pivot table as well which was cool!

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/a/c/ac3b876470e22fb56257d8b728997b1507543bdf.jpeg)

---

<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 1, 2024, 11:40pm UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/8 "2024-04-01T23:40:49Z")

</div>

Can you record a video of the problem you mentioned in the original post? I can’t see why it doesn’t work, do you have any filters for the chart? Try removing any filters to see if it helps.

---

<div class="post-metadata">

**Author:** ![Katelyn\_Alberts](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/katelyn_alberts/32/44421_2.png) [@Katelyn\_Alberts](https://community.glideapps.com/u/Katelyn_Alberts)\
**Post date:** [April 2, 2024, 2:48am UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/9 "2024-04-02T02:48:17Z")

</div>

I figured out what the problem was.

On the button click, I had the data listed as “this item” instead of one of the tables I was using.

However, I’ve now run into other issues because the components options are definitely not the same, and are surprisingly more limiting given that I thought this was more what Glide was used for? like charts and whatnot.

I can’t re-create a ton of the charts I had before!

---

<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 2, 2024, 11:33pm UTC](https://community.glideapps.com/t/data-sourcing-from-multiple-tables/72148/10 "2024-04-02T23:33:47Z")

</div>

> [@Katelyn\_Alberts](#):
>
> However, I’ve now run into other issues because the components options are definitely not the same, and are surprisingly more limiting given that I thought this was more what Glide was used for?

So the chart types are not the same? Yeah…

I don’t think Charts has had much love over the years. I usually create custom charts using code.
