Skip to main content

Hi, this should be really simple but there doesn't seem to be a way of displaying percentage of a total (fields meeting certain conditions).

Basically I have a list of leads. Each one is labelled as "converted to customer", "converted to partner" or has a blank field.

Instead of just counting the number of records meeting the conditions above, I would like to know the percentage of conversions to customer and conversions to partner,  and display this on an interface page.

Thanks.

 

My workaround for this is creating a single formula field for each percentage I want to see, and then using "Percent filled".  Hopefully someone else has a better idea!

   

Link to base


Thanks, that is a great simple workaround. However, I would still like to do cross calculations between the columns/fields.

In other words, I want to count the number of non-conversions of all types. So in my one-field example, with the "conversion to client" and "conversion to partner", I can count the empty fields to get my answer.

Ideally, there would be formulas available in the Interface elements, but Airtable doesn't have that. 


Thanks, that is a great simple workaround. However, I would still like to do cross calculations between the columns/fields.

In other words, I want to count the number of non-conversions of all types. So in my one-field example, with the "conversion to client" and "conversion to partner", I can count the empty fields to get my answer.

Ideally, there would be formulas available in the Interface elements, but Airtable doesn't have that. 


Ahh...if you actually want to use those numbers I think you're going to need to create a new table, link stuff up appropriately, and then use rollups I'm afraid

re: Ideally, there would be formulas available in the Interface elements, but Airtable doesn't have that. 
Sigh yeah


@TheTimeSavingCo - Can you share what formulas you used to count the status?


@TheTimeSavingCo - Can you share what formulas you used to count the status?


I'm not using any formulas, just the field summary!


I understand that for the interface. I meant for the base (data) 


I understand that for the interface. I meant for the base (data) 


Ah, right! It's:

IF(Status = "Todo", 1)

For future reference, you can duplicate the base to your own workspace to see formulas!  


Amazing!! Thank you so much!!! 


Reply