Hello! I’m trying to create a competitive analysis matrix that is both dynamic (rows and columns powered by other tables) and interactive (values within the matrix can be set from the matrix).
There are three main datasets:
Competitors pulled from an “All Competitors” table.
Features pulled from an “All Features” table
Status, which is just a Select List
Ideally, the matrix would present as a table that would look something like:
.
Customer 1
Customer 2
Customer 3
Feature 1
Supported
Supported
Not Supported
Feature 2
Supported
Coming Soon
Supported
Feature 3
Supported
Not Supported
Supported
I’m finding trouble ensuring:
The rows and columns expand as new Competitors and Features are added
I can click on any status and change it
When I view a Customer, I can see each feature per status bucket
When I view a Feature, I can see each customer per status bucket
I’m I missing something obvious or am I trying to bend Coda too far? Thanks so much!
Can I suggest the following approach:
Have a table with a customer, feature and supported? column:
(You can create the column and features columns as relation columns to the respective tables, that will not influence the rest of the logic.
I have features along the side, customers across the top, you can easily switch them around, or you can have both along the side. And add a filter as needed.
When I was about to post I saw @Piet_Strydom had already answered the question, but since I built the sample doc already I might aswell just publish it
Thank you both so much for your time and help. @Pablo_DV 's solution nailed exactly what I was looking for but, @Piet_Strydom, your approach actually helped me with a different problem I was encountering. I appreciate you both!
