Currently, from my understanding, Noloco’s charts allow only basic statistical functions (count, sum, average, min, max) at the record level, which limits the ability to display dynamic percentages based on aggregated data.
The Problem:
For example, when calculating a positive reply rate, we need:
∑Positive Replies / ∑Total Replies ×100
We can do this on a formula level and then produce an average however, that would give us an average positive reply rate rather than the true number.
Proposed Solution:
- Allow custom aggregation functions in Noloco charts (e.g., sum totals before applying a formula).
- Add support for computed fields in charts that work at the dataset level instead of per record.
- Introduce Custom Formula Metrics" where users can define calculations using sums or rollups (e.g.,
SUM(positiveReplies) / SUM(totalReplies)).
Not sure if a workaround already exists - please feel free to drop any suggestions in the comments.
A potential workaround could be to create an aggregate table but then we wouldn’t be able to use filters like date, campaign, project etc to get a deeper insight into the data.