I have a table that contains columns like name, value1,value2,value3. Based on a drop down choice of which name I would like to use line chart to display the values. While Glide is great at filtering out data the line chart reuires that the selection be transposed. However, Glide isn’t good at filtering out data once it has been transposed. Any ideas on how to be able to dynamically be able to use a choice drop down to pick the name and then use line chart to chart the associated data?
There is always the alternative of using something like quickchart if you want to avoid transposing the data.
However, I’m curious why you say that Glide isn’t good at filtering the transposed data. How are you transposing it?
once the table is transposed to name1,name2,name3 columns the glide filtering lets you filter rows out not columns. Ultimately I have a lot of columns of different data runs. I want the user to be able to use a drop down to select the one they are interesetd in and then i’d like a line chart to show those values. I can actually build a data set up using hlookups but now can’t seem to bring the user_name back in from glide to the spreadsheet that is building up the table for the line chart.
If i keep the data in rows then i can use the filtering option in glide to filter down to the row but then I have a row with name, value1,value2,value3 etc across as columns. Line chart wanted the values in just 1 column
| Makai Nguyen bEpee raw blade take go | Nathan Li bEpee raw blade take go | Isabel bSaber boulder to flank or plus deep |
|---|---|---|
| 550 | 1252 | 1123 |
| 553 | 1104 | 1225 |
| 570 | 856 | 796 |
| 1679 | 754 | 924 |
| 931 | 840 | 773 |
| 541 | 839 | 960 |
| 576 | 888 | 670 |
| 534 | 748 | 1370 |
| 594 | 634 | 766 |
| 482 | 848 | 807 |
| 530 | 872 | 1280 |
| 609 | 772 | 1330 |
| 537 | 568 | 1480 |
| 663 | 699 | 1527 |
| 430 | 537 | 1179 |
| 348 | 1230 | 1195 |
| 432 | 1204 | 1154 |
| 1339 | 919 | 1371 |
| 393 | 967 | 1338 |
| 543 | 397 | |
| 514 | 1004 | |
| 305 | 506 | |
| 1071 | 1180 | |
| 364 | 1073 | |
| 295 | 813 | |
| 905 | ||
| 960 | ||
| 345 | ||
| 1189 | ||
| 386 | ||
| 554 | ||
| 328 | ||
| 334 | ||
| 511 | ||
| 362 | ||
| 365 | ||
| 908 | ||
| 355 | ||
| 341 | ||
| 399 | ||
| 379 | ||
| 390 | ||
| 391 | ||
| 391 | ||
| 342 | ||
The above is 3 columns out of the dataset. The first row is comprised of a name and then their benchmark. In glide depending on which user is looking at the app and which benchmark they have chossen (drop down). I’d like to chart the correct set of data. The example above is with the data set up in columns already for chart but it’s easier in Glide filtering if each row has name,benchmark, value1,value2 etc…
Ok, when you said transposed I thought you meant that you transposed your separate columns into rows.
So am I understanding correctly that you want to choose one column of data and display the data in all rows for that one column in a line chart?
I think I would create 3 separate charts (one using each individual column) and then set the visibility condition on each chart based on maybe a choice component value or something like that.
Unfortunately I have about 300 combinations. I just showed 3.
Ray Parker
Yeah there really isn’t a way to filter columns like you want and Glide charts are primarily row based. Short of restructuring your data to have one Name, Benchmark, Value per row (at least 13,500 rows if you had 45 rows per combination * 300 columns, but I would assume less), your other option is probably to use something like quickchart to build a url with the data you need. Only problem is that you’re still going to have a mess of computed columns to conditionally aggregate the data from each column. Most likely a massive 300 condition IF column, followed by a Joined List column to get a comma delimited list of numbers from that IF column to use to build the url.
I don’t know what’s best. My instincts say to restructure your data. It’s just better database normalization in the long run, but will use more rows.
1 Like
I can restructure the data but I’m not quite following: Are you suggesting
Makai, benchmark1, value 1
Makai, benchmark1, value 2
.
.
Makai, benchmark2, value1
Makai, benchmark2, value 2
.
Nathan, benchmark1, value1
Nathan, benchmark1, value2
and then filtering to:
Makai, benchmark2, value1
Makai, benchmark2, value2
and then the line graph would work?
Yes, that is what I was thinking, but before I confirm, can you explain how your filter would work?
Jeff,
I resturctured the data and it works perfectly! I can then use the filter on the screen to limit to current user and to a drop down value (benchmark). That reduces the data set to just the values that need to be charted. Thank you for such a prompt reply and helping me work thru the problem. I think the epiphany for me was while I had name, benchmark, value1,value2,value3 etc… already in a prior iteration I didnt think to break that into 3 separate lines and chart wouldn’t let me pick data that was running horizontaly.
Thank you again! I played with it for 2 days before dropping you a line and you helped me solve it in hours.
2 Likes
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.