I’ve created a dashboard for a research I’m doing using Coda.
I have a main data table with lookup several lookup columns. I’m working along the lines of the great MEGA TRICK: Dashboard design — Two columns, smaller charts
My dashboard is called “Analysis_Table”. It has one row, several lookup columns, and a multiselect column that gets its values from another table, that aggregates data from the raw data table I’m using. The multiselect is used to filter data on the other tables, and consequently, on the dashboard.
Here is the formula for one of those tables: Main_Table.Filter([Currentvalue.type]contains([Analysis_Table.BType]))
It works great when selecting one option from the multiselect column. When choosing two options, data on the tables goes blank.
The strange thing is that it only happens when I’m using it to on another table. It works fine when I’m doing the same to filter columns in the analysis table itself: Main_Table.Filter([Currentvalue.type]contains([thisRowt.BType]))
What am I doing wrong?
I tend to think it’s not a bug.
Big thanks to all tips.