This is a very basic functionality I’m looking for, but I can’t seem to figure out how to make it work yet.
Let’s say I have the following table:
TABLE 1 (Data):
Type | Value
Cat | 1
Cat | 0
Dog | 2
Bird | 1
Dog | 0
Dog | 4
I want to create a summary section at the top of my table to aggregate information (pretend it’s some complicated formula that’s more than just sum or avg). In a normal spreadsheet, I normally can just create a new row at the top and create custom formulas to aggregate the information for that column below.
[REQUEST TO CODA DEVELOPERS: Please add a better way to create custom summary information–the ones at the bottom now are very limited in their basic functions rather than my custom formulas. And it would be nice if the summary information was displayed at the top instead of the bottom since that’s where I want to read that information quickly.]
Anyway, since I can’t currently do that in Coda, I decided second best option was to create a separate table to summarize the information. I want to create a table that pulls in all the information and aggregates the data using my own custom formulas. So the summary table should look something like this:
TABLE 2 (Desired Summary):
Type | Avg Value of Each (example formula = SUM(Value)/COUNT(Type))
[Cat] | .5
[Dog] | 2
[Bird] | 1
CHALLENGE: I can’t figure out how to make it so that the summary table automatically pulls in each of the Type values from the first table and only pulls in the unique instance. If I use the formula =UNIQUE(Type), it lists the list [Cat, Dog, Bird] into each new row so it becomes:
TABLE 3 (Bad):
Type | Avg Value of Each
[Cat, Dog, Bird] | .5
[Cat, Dog, Bird] | 2
[Cat, Dog, Bird] | 1
I want it to list each separate [Cat], [Dog], [Bird] as its own row like in TABLE 2.
Hope this makes sense! If anyone needs to make a sample doc, I can, but hopefully this is enough.