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!).

60 Comments
beaunorton11
4 - Data Explorer
4 - Data Explorer

I need this for KPI tracking dashboards. Seems like it should be simple to implement.

shoecrewqc
5 - Automation Enthusiast
5 - Automation Enthusiast

We need this!! Agree, that this is a basic feature that needs to be in Airtable Interfaces so we can do proper dashboard reporting.

madmike
4 - Data Explorer
4 - Data Explorer

+1 - need it as well

korsour
4 - Data Explorer
4 - Data Explorer

Need this ASAP, guys, please provide it to us finally. How many years should we wait?

mikeeTHINK
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 

JulieDox
4 - Data Explorer
4 - Data Explorer

Can I add +1 million? ๐Ÿ˜€

We need this!! Come on Airtable, come up with a solution!

Chris_Welch
4 - Data Explorer
4 - Data Explorer

+1  Please!

csytsma
5 - Automation Enthusiast
5 - Automation Enthusiast

+1 - would be wonderful to stay within Airtable, instead of sending users to a 3rd party site just to view their Airtable data.

smcintyre
4 - Data Explorer
4 - Data Explorer

YES. I can believe that this doesn't already exist, but Airtable would be a much more powerful tool with this option. 

yclee
4 - Data Explorer
4 - Data Explorer

This is critical for making business performance indicator..