We’ve recently received a feature request from @artoflogic: COUNTIF Function, with the idea to make it possible to check how many times a certain value in one column already exists in the Baserow table.
The way the database works, it’s impossible to run formulas at the field level; they only work at the row level. However, for simple field calculations, we have a footer aggregations feature: Footer aggregation // Baserow.
As many spreadsheet users are moving to Baserow, we think a feature allowing more advanced data manipulations at the field level could be useful to many users.
We already have some ideas. For example, we could add formula or filter support to the footer aggregations, allowing users to do more advanced analysis on their data at the field level. But in order to make a decision, we’d like to ask for your input.
Share your thoughts and/or use cases about this topic. We’re excited to hear your ideas!
Hi @olgatrykush, thank you for picking up on this idea.
I think there could be multiple ways how to approach this. They probably can complement each other.
Offer a set of simple formulas such as COUNTIF to do a range of useful calculations inside Baserow.
Offer a special field type that allows for more advanced calculations similar to excel. Eventually, you might also want to open a Spreadsheet inside one Cell to where you can link to any other Baserow field and to really complex calculations.
Or you could offer an API so other developer can build their own Field Types and bring more features to Baserow.
Hello, I fully support this request feature! I manage a list of community learning members and this would help me a lot to set up statistics such as percentage of people who decides to develop a specific competency or to share a given expertise among others…
Thank you!
Great idea! I would love to see SUM, AVERAGE, MIN, MAX, COUNT and have them work on formula fields with different output types such as numbers and duration (especially for my usecase managing billable time across collaborators).
Hey @gabrielle, the team shared that an external contributor has started building this feature: Add Distribution aggregation (!2736) · Merge requests · Baserow / baserow · GitLab. It adds a new “Distribution” aggregation type for certain fields that shows the top ten most common values, including their total count and relative percentage. Would it work for your use case?
