I have a table with data on people and want to have analytics done on one person.
It looks sth like this:
Person A: Data point A1, Data point A2, Data point A3, Data point A1 + A2 + A3 Person B: Data point B1, Data point B2, Data point B3, Data point B1 + B2 + B3 Person C: Data point C1, Data point C2, Data point C3, Data point C1 + C2 + C3 Person D: Data point D1, Data point D2, Data point D3, Data point D1 + D2 + D3
Asking ChatGPT about the entire table to look for insights looks great.
What I want to do is ask ChatGPT to have a look at one specific row. Letâs say the user clicks on Person C. I want to be able to show a chart that is Data point C1 / Data point C1 + C2 + C3 and have ChatGPT give a short explanation of the data of that one person not of the entire table*.
Ofc I have much more data and I have found that with the right instructions and context ChatGPT can give a nice explanation on it, but I canât get it to only take one row into consideration.
Any ideas?
Thanks in advance!
*Ideally comparing that one row to the entire table as well but one step at a time
I think glide AI would work here. Youâd have two AI columns (C1 and C1+C2+C3), and then youâd prompt it.
Unless you donât want to use this, use GPT integration instead. Then, youâd send the data, and chatgpt would respond.
but the columns wouldnât be c1 and c1+c2+c3, they would be 1 and 1+2+3. If I would tell GlideAI or ChatGPT to take a look at those columns, it would look at the columns for Person A, B, D as well
Iâm not sure if I understand this fully, but what would your inputs be? A column of c1, and a column that is the calculation of c1+c2+c3, then you want to compare that to the same numbers in other rows?
Now I want that when people click on Johnâs profile I can prompt AI to look at only the data on Jim, and maybe compare that to the scores of other maybe not. But the most important thing would be to have ChatGPT or Glide AI look at Jimâs weight, height, and the ratio and maybe compare it to others.
I want the same thing to happen for Ben, Maria and Tim when the user goes to their page and presses the button to ask ChatGPT on it.
Imagine that there will be hundreds of people with tens of columns so a manual solution wouldnât be feasible.
Yes what you are asking for is for users to see the rows in a page.
If they click on John - they see Johnâs height and weight right?
If they click on Tim - they see Timâs height and weight.
Along with their Weight/height ratio
You have a collection component that points to the table then âthis rowâ
Then if you want to compare the height and weight with others use a query to filter the rows, of that whole column, have a roll up and compare it.
Infact for this specific use case a template column would work perfectly and you wouldnât need ChatGPT or GlideAI - just some math column and a few others
I guess I am being very unclear. I donât want them to only see the height and weight. I have already done that. I want for them to be able to click on a button and have ChatGPT explain to them what the height and weight mean. I want to ask ChatGPT sth like:
Analyze the data of John in a short and concise manner comparing him to the others as well as talking about what these numbers show about him. Donât go on for two long just 2-3 sentences.
And it would say sth like:
John, at 179 cm and 78 kg, has a Weight/Height Ratio of 0.44, which is on par with Tim, the tallest in the group. His ratio is higher than Ben and Maria, indicating he carries more weight for his height compared to them. This suggests that John has a balanced physique similar to Tim, but slightly heavier relative to his height when compared to Ben and Maria.
So the users would have a short description of the data and what it shows about John. This would come in handy considering that there will be hundreds of people and they may want to compare John to the others.
Edit: Just found a solution that made me feel kinda stupid. I can use a Template and have sth like PERSON_NAME in the question and replace that with the person name in the column. Seems like kind of a workaround and I donât get why you cannot reference a row inside of Glide.
Ohh this is what you meant I can provide you with different solutions as to how this would work.
Letâs start:
Using AI | Glide AI or chat gpt
After getting the columns
Name - height and weight
Create a template column that follows this:
Micheal - 180cm - 15kg - 0.035 ratio
Then have a lookup of that Column so the new column each cell would be
Micheal - 180cm - 15kgâŚ
John - 120cm - 12 kgâŚ
Jim - 155cm - 23 kg
Basically all the people data
Then have your AI collect the data of the person and the data of the group.
Then you can compare it using your prompt
Just know if a row is added or updated you use an update
Glide works mainly on rows - so what we did here was get all the data in a row
The second way would be using a template column this would be more complex because the rows in the table can vary and the people data isnât standard.
If youâre following this path do you plan on including all the people in the output or just a few that meets a certain criteria. Because this might get complex
So you would need to create different columns (e.g math, templates etc)
Youâd have a column for âon parâ that finds a case that a person matches Micheal data.
Itâs not a workaround, itâs the standard way to do it because you have to kind of specify what type of information you want to feed to Glide AI/ChatGPT. There can be a lot inside a row, and using too much would lead to you being over the limit for a âquestionâ.