Footer aggregations in shared view : sum bug for duration field

Technical Help
,
1

Please fill in the questionnaire below.

Self-Hosted Installation and Setup Questions

How have you self-hosted Baserow.

Cloudron

What are the specs of the service or server you are using to host Baserow.

20 GB RAM

Which version of Baserow are you using.

Baserow 1.25.1

Describe the problem

Describe, step by step, how to reproduce the error or problem you are encountering.

I have very simple table which is responsible for counting time my kids are spending on games.
One of the column is duration.
In footer there is sum of all rows in column duration.
It works great.
However when I share view publicly, then footer shows incorrect value (same one) for all shared views:

Provide screenshots or include share links showing:

image
image107×592 5.88 KB

image
image126×599 3.9 KB

I installed baserow 1.25.2 and bug is still there.
The problem is that, aggregation footer doesn’t take into account filters.
Instead it display sum for all rows.

How many rows in total do you have in your Baserow tables?

427

2

It could be related to Aggregation formulas ignore filter inside (#2666) · Issues · Baserow / baserow · GitLab

3

Hi, thanks your noticing this. I just checked with the team and it seems not te be related to the issue about the formula.

I created a new issue for this: Aggregations do not filter records in public shared views (#2760) · Issues · Baserow / baserow · GitLab

4

I see there is no work on this item.

It is quite problematic, when sharing with team some tables and aggregation footer doesn’t work.

Any ETA ?

5

@frederikdc
Any ETA ?

It is important as users of my app see incorrect footer aggregations :confused:

6

Hi,

The issue has been checked and should be solved in the next release