# Relation column and chart **URL:** \ **Category:** Ask for Help\ **Created:** [March 15, 2023, 11:00am UTC](https://community.glideapps.com/t/relation-column-and-chart/59187 "2023-03-15T11:00:49Z")\ **Posts on this page:** 20\ **Page:** 1
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 15, 2023, 11:00am UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/1 "2023-03-15T11:00:49Z")
i have a column with a number , you see is “NUMBER” column Is a relation column and is not possible retrive this column into a chart, how can i fix it? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/b/8/b8be4bdd6f2b1cfe5737fea6c047ca48c24d42f8.jpeg) ---
**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\ **Post date:** [March 15, 2023, 11:58am UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/2 "2023-03-15T11:58:45Z")
Relations are links to entire rows. Not a specific column. Glide will randomly choose one column to show you that the relation found a match. If you want a specific value from that related row, then you need to use a Lookup column that refers to the relation. ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 16, 2023, 5:09pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/3 "2023-03-16T17:09:32Z")
Maybe im not explained well. When i create a chart i can’t use the relation column to show data, i sum all value based month on chart but i cant select relation column as value ---
**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 17, 2023, 1:07am UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/4 "2023-03-17T01:07:08Z")
So on a specific row, you want to use that relation as your source of data? What type of chart are you trying to display? ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 17, 2023, 4:00pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/5 "2023-03-17T16:00:39Z")
Yes i wan use those column called NUMBER as chart data, i use column chart ---
**Author:** ![Pratik\_Shah](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/pratik_shah/32/12416_2.png) [@Pratik\_Shah](https://community.glideapps.com/u/Pratik_Shah)\ **Post date:** [March 17, 2023, 4:23pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/6 "2023-03-17T16:23:52Z")
I guess, “Single Value” column will help here or probably a template column. ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 17, 2023, 4:27pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/7 "2023-03-17T16:27:42Z")
I can’t use relation column into template, and single value is not visible into chart ---
**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 17, 2023, 11:50pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/8 "2023-03-17T23:50:17Z")
But do you want multiple rows’ “NUMBER” on a chart. Would you ever have multiple items to return on a relation? Can you explain more on your use case here? ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 18, 2023, 9:12am UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/9 "2023-03-18T09:12:40Z")
Simply i want use NUMBER column value into this chart, but i cant find NUMBER column into chart VALUE to set it so i think is not possible set RELATION column as a value into the chart ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/4/4/4434ba1f6dd04b174fe077f1e3afef1f70e39226.jpeg) ---
**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 18, 2023, 12:54pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/10 "2023-03-18T12:54:51Z")
What do you see when you click on the “Source” choice on the right? I assume you don’t see the relation option there? ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 18, 2023, 1:42pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/11 "2023-03-18T13:42:51Z")
yes correct ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 18, 2023, 1:47pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/12 "2023-03-18T13:47:04Z")
Nope i cant create a template with a relation and “Single Value” is not visible into chart ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 18, 2023, 3:02pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/13 "2023-03-18T15:02:51Z")
Hola Matteo, I think the source of your chart is not configured correctly. It has to point to your relation to find out the Number column. ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/f/5/f5a0e908ff1313c213613e0c0e84fcf59041005e.jpeg) The new setting should look like this: ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/e/8e18b16b695c6389700edacb18ff59c9ed118648.png) Saludos! ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 18, 2023, 3:49pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/14 "2023-03-18T15:49:21Z")
unfortunately it is not the solution, I’ll explain better immediately. The “number” column is used both to create the graph in the front end and to calculate the monthly amount to be subtracted from revenues via another LOOKUP column The Relation column does not allow me to recall the data even to make this last calculation so today I manually copy the data from the NUMBER column into a column with numeric format I use the Relation column because the data is entered by the store manager. Each number is equivalent to a name but the employee enters only the name so through the relation column I can get the correct number based on the name entered by the employee ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 18, 2023, 3:51pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/15 "2023-03-18T15:51:59Z")
basically i need to transform the data in the NUMBER column which is a relation into a normal numeric data ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 18, 2023, 4:29pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/16 "2023-03-18T16:29:04Z")
> [@Matteo\_Alfieri](#): > > Simply i want use NUMBER column value into this chart, but i cant find NUMBER column into chart VALUE Ok, let me rethink and reread your previous statements. Is your **NUMBER column** highlighted bellow, right? ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/0/6/064516259507abf974926b3f38f5f42232d777f3.jpeg) If so, it’s just a relation column and can’t be used to read/show data into chart directly. You need to do: 1. Set your **NUMBER column** (relation) as chart’s data Source 2. In Value parameter (chart) select the desired column found by **NUMBER** relation previously This should be enough to see data on chart. ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 18, 2023, 5:09pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/17 "2023-03-18T17:09:49Z")
> [@gvalero](#): > > Ok, let me rethink and reread your previous statements. Is your **NUMBER column** highlighted bellow, right? Is not possible to create a column that take the “NUMBER” column value and transform into simple number? ---
**Author:** ![gvalero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/gvalero/32/1037_2.png) [@gvalero](https://community.glideapps.com/u/gvalero)\ **Post date:** [March 18, 2023, 6:06pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/18 "2023-03-18T18:06:12Z")
yes, of course (it’s your plan B)! Create a new Lookup column using your relation and choose the column where the your numbers are. Saludos! ---
**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 18, 2023, 11:48pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/19 "2023-03-18T23:48:43Z")
> [@Jeff\_Hager](#): > > Relations are links to entire rows. Not a specific column. Glide will randomly choose one column to show you that the relation found a match. If you want a specific value from that related row, then you need to use a Lookup column that refers to the relation. Basically it’s what Jeff said here, right? ---
**Author:** ![Matteo\_Alfieri](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matteo_alfieri/32/37404_2.png) [@Matteo\_Alfieri](https://community.glideapps.com/u/Matteo_Alfieri)\ **Post date:** [March 23, 2023, 4:10pm UTC](https://community.glideapps.com/t/relation-column-and-chart/59187/20 "2023-03-23T16:10:47Z")
i think it will won’t work, cause i cant use it for margin calculation, i mean into math column [Next page](https://community.glideapps.com/t/relation-column-and-chart/59187.md?page=2)