Row grouping and total row in table view

I am wondering if it would be possible to add the ability to use one of the fields for an entity to group rows and to setup a total row for each group:

This would be similar to the total row in Excel tables where you can calculate some values like sum, count, average, etc.

The board view already has the “row” option which allows cards to be grouped together:

The total row would be great to have regardless of grouping and it would be fantastic if the calculations could be updated based on filtered rows (i.e. if you were counting the rows, the count would get updated when rows were filtered out).

1 Like

@anayericov We do have this idea in mind to set aggregate fields for rows. However it is hard to say when we will implement it.

@mdubakov thanks for considering it. I think it would be a great addition to the tables.

I was wondering if it is possible to allow more field types to be used for the row configuration in the board view (see the second image in my post above). Currently it seems only relations and workflow fields can be used. I know those fields are controlled by more limited/defined terms, but in some cases it might be helpful to group by other fields (like a text/number field for year).

1 Like

@anayericov I concur with building more substance around what are already very solid board views we have in Fibery.

I was wondering with this:

are you talking about something where you’d have a tally next to the Row name, perhaps tally of the total entities in the row? Or something connected with tally of certain fields in the row? Or both? So for example:

  • You could see the total number of entities that this row is filtered for, like Coda does it:

  • And on top of that, you could calculate say a total estimated hours in a Sprint, by calculating for the row the total of a field in the entities that are filtered into the row? So say you set up a field “estimated hours” and then you’d have the total calculated out of those fields showing here in the board?

I’d even take that a step further, hopefully down the road when we get some Automations, to allow you to put in a total you’d like to see, and then next to that total, the “running” total as you add entities into that row. This way you could plan a Sprint by saying “I’d like 40 hours total into this Sprint,” and then as you add entities into the row, you’d see if you go over that desired total. This type of functionality could also become available in a custom App that would be for development that might include some of the other stuff @mdubakov was talking about here: