Help

This Product Ideas board is currently undergoing updates, but please continue to submit your ideas.

Ability to create calculated metrics in Interfaces

cancel
Showing results for 
Search instead for 
Did you mean: 
Joel_Lee
6 - Interface Innovator
6 - Interface Innovator

First, let me start off by saying how incredibly important this feature is. The data so many organizations could have by being able to create custom calculated metrics in Interfaces is untellable.

When creating big numbers (like the Numbers widget in an Interface), you are tired to a specific field, then you must select an operator. For example, you tie that Number widget to a field in one of your tables, for example, “Revenue,” then select “Sum” and it gives you the total. Let’s say you did that same thing for “Profit.”

Then, with those two metrics, there is no way to create a third one based off those that calculates, for example, something like: Profit / Revenue (displayed as a percentage (Margin)).

The problem is that the only workaround to achieve the above (something that is a basic feature in, for example, Google Data Studio), is to build in the Profit, Revenue, and Margin fields at the table level which can fail to work if you are dealing with a metric for which there is no workable operator. For example, you cannot use “Sum” in the settings of a Number widget in an Interface in order to sum up all the “Margin” values in your table. That doesn’t make sense.

Long story short, I would love if, in Interfaces, you could calculate your own metrics. The flexibility this would provide would help people who are using Interfaces for basic financial or other number-based widgets, and could give them the insights they need (like the organization I work for!).

57 Comments
tamasratkai
4 - Data Explorer
4 - Data Explorer

Really hope this will be added soon. This is a must to build custom dashboards that can show KPI-s.

matchbox
4 - Data Explorer
4 - Data Explorer

+1 We need this.

niccowan
4 - Data Explorer
4 - Data Explorer

+ 1  - hoping this comes soon 

AK_
4 - Data Explorer
4 - Data Explorer

+1
Please 🙏

umut
4 - Data Explorer
4 - Data Explorer

It has been two years, there are five pages comments but the feature is not implemented. This is sad for a newbie like me. Maybe, some of the commenters are left this platform because of this missing feature which is critical for me, my business and our further plans.

I hope someone considers these comments soon.

normstrongtown
4 - Data Explorer
4 - Data Explorer

+1 - we need this too

Calvin_Young2
6 - Interface Innovator
6 - Interface Innovator

Chiming in a year later... still really missing this feature.  And while I'm here, I'll throw out another related need.  

I just built a new dashboard that has 3 of these "Big Number" elements.  For this particular interface, I want to make a pie chart based off those 3 numbers.  For now, I'm stuck telling folks to do the mental math of comparing the size of those 3 numbers, unless I want to hard-code some hacky method elsewhere in the base.  But even then, I'd somehow have to free up an automation because even at the enterprise level I'm still stuck with 50...

Debbie_Benkovic
4 - Data Explorer
4 - Data Explorer

Adding my +1 here. Can't believe 2 years and not a reply from Airtable. Really need this.

Josh_Horn
4 - Data Explorer
4 - Data Explorer

+1

pkshiu
4 - Data Explorer
4 - Data Explorer

+1 - the interface is not useful, even for a simple KPI type dashboard, for a $240/person/year product.