Hi! I have a large table for which I need to track the completion of information within each row
The rows are countries; the columns are dozens of attributes of different types that are being researched by a team. I need a way to somehow see that e.g. for Austria 80% of the columns contain some information, and for Australia only 60% (and do something with that information)
I have only been able to do that by manually adding each column’s name to the formula; the problem is that there are multiple people on my team, and if one of them decides that e.g. average humidity is an important metric for our project, they should be able to add a new column for that without me going and manually changing the formula
Is there a way to do something to that effect?
I understand that the standard advice here would be to just transpose the table – but in my case it would not make sense; the rows are entities of one type, and the column types are all over the place, including multiple relations
Hi @Dan_Reitman,
Welcome to the community!
You cannot select columns programatically on Coda or somehow check if all columns are empty or not. So you do need to change your data structure in order to solver your problem.
In this thread, the data was similar (cities with multiple metrics) so the solution proposed there would probably fit you too.
New formulas for columns - Suggestion Box - Coda Maker Community
You can still visualize all the attributes as columns by grouping the table the way I demonstrated in the example.
Hope this helps,
Pablo
2 Likes
Thank you! That’s a great solution – I see two main problems with it in my case, but will certainly return to it for other scenarios.
The smaller problem is adding new metrics; I can go with automations/buttons to populate the table and create new rows to the main table when a new metric row is added.
The bigger problem that I don’t understand how to tackle is connected to the data types. In your example every metric is ultimately displayed in a number column; this makes it easier to work with. In my case, there are multiple column types, including canvases and relations to other tables.
If I come up with some solution, I’ll write about it here!