Jul 29, 2023 07:33 AM
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.
Jul 30, 2023 02:30 AM
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!
Aug 01, 2023 10:03 AM
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.
Aug 01, 2023 08:50 PM
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
Feb 15, 2024 07:13 PM
@TheTimeSavingCo - Can you share what formulas you used to count the status?
Feb 15, 2024 07:31 PM
Feb 15, 2024 07:33 PM
I understand that for the interface. I meant for the base (data)
Feb 15, 2024 07:39 PM
Ah, right! It's:
IF(Status = "Todo", 1)
For future reference, you can duplicate the base to your own workspace to see formulas!
Feb 15, 2024 07:41 PM
Amazing!! Thank you so much!!!