June 27, 2024 / 💜 Workspace Q&A, Totals row in Table View for numeric fields (experimental)

I’m trying to using this model to consumed events from bookmarked article in Periodic database daily, What condition should I set in “On schedule” to trigger this for each day only so that will not be duplicated automation for those triggered

I’ve got a lot of fields that are named the same across multiple databases so they can be merged under a single column in a table view to save screen real estate. However, when that column gets summed up in the total row, it counts everything in the column, when I often only want to count the values from one database. Could you add the ability to filter databases out of being included in the total row counts?

Any plans to extend Totals Row in Table View to support SUM, AVG, etc. for Single Select / Multi Select Fields where a numeric value is specified?

4 Likes

If I understand correctly, you could make a formula to get the select field value, and then this field can be aggregated (SUM, AVG, etc. ) in table view.

I agree would like to do this natively, have tried to do a formula per @ChrisG but it’s too technical without a developer!

My use case: I have a one-to-many relation where I have a # field in the many related entities. I’d love to be able to get built-in a sum of that # in the relation via lookup. Then display that in a table. In fact I have a big project right now where I could really use this adding up at a glance in said table!

Thanks.

1 Like

Agreed; I have seen this done. My question is really roadmap: seems a fairly straight forward feature to include.

I think SUM is relatively simple. However, I’m not sure what the expected behaviour would be for AVG.

For example, if I have a multi-select field, with options A, B, C, D, E with values 1, 2, 3, 4, 5 what would you expect a table view to show in the following situation:

Name Multi-select AVG
Thing A, C 2
Another thing B, C, D 3
Third thing - -
More stuff A, E 3
AVG: ?

Agreed would love to see this feature. And to @Chr1sG’s point, I’d be happy with just SUM right now…

1 Like

I see what you are saying. AVG of AVG column and MED of MED column are a bit more difficult (and AVG of MED column and MED of AVG column probably shouldn’t be supported… messy). I would expect all the values would need to be considered (not AVG of AVG or MED of MED):

  • Row AVE would include all selections for each Row; as shown in your example
  • Total AVE would include all 7 selections across all 4 Rows; e.g., ((1+3)+(2+3+4)+(1+5))/7 = 2.7
  • Row MED would include all selections for each Row
  • Total MED would include all 7 selections across all 4 Rows; {1, 3, 2, 3, 4, 1, 5} → {1, 1, 2, 3, 3, 4, 5} = 3
Name Multi-select AVG MED
Thing A, C 2.0 2
Another thing B, C, D 3.0 3
Third thing - -
More stuff A, E 3.0 3
2.7 3

AFAIK, this approach is statistically valid and hopefully how most users would expect the calcs to work.

2 Likes