Getting averages/info of tables with filtered rows

1

Hello, is there a way to gather averages/info with formulas from rows that have been filtered out in the options settings of a table?

For some background, I like to filter information by month so that my page won’t lag. I keep a yearly log with an entry per day. So having 365 rows per year starts to make the page lag, and filtering out by month keeps the lag away. My issue is I still want to get the information off of the filtered out rows to display at the top so I can compare numbers.

2

Hey @Sleepychomps - Yep you can do this. Here’s how Coda works with formaulas & filters

  1. Formulas using the source table (not a view but the actual table) will work from all rows, even if there is a filter applied to the table.
  2. Formulas using a view of a table will only work from the visible (non-filtered) rows from the view.

So just point your formula to the source table instead of the view and that will do it.

2 Likes
3

AH! Yep! I wasn’t using the source table. Thank you very much for the help!