Help

Show results by percentage from survey

Topic Labels: Formulas
Solved
Jump to Solution
7857 4
cancel
Showing results for 
Search instead for 
Did you mean: 
Mary_Schafrath1
4 - Data Explorer
4 - Data Explorer

Hi there smart people!

I'm looking to show the percentage of improvement since the implementation of our new Figma redlining process from our team survey. Right now, 5/8 people say the process has either improved or greatly improved! Is it possible to show this in Airtable's Interface? Either as 5/8 or 63%? Participants will continue to add to this survey in the coming weeks. So, I need a create a formula that will update the Interface accordingly. 

Please, let me know if anyone has an answer!

2 Solutions

Accepted Solutions
Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

one way is to create a formula which creates a 1 if your condition (improved or greatly improved) is fulfilled and 0 if not.

then create a number element which you set to this field and then make the summary type average

See Solution in Thread

Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

FORMULA 

Russell_Findlay_3-1675691115853.png

 

AND THEN NUMBER 

Russell_Findlay_2-1675691091866.png

 

Russell_Findlay_1-1675691066097.png

IF YOU HAVE BLANK RECORDS THEN YOU NEED TO FILTER THESE OUT AT THE NUMBER PHASE TO EXCLUDE ANY WHICH HAVE NOT GOT A RESPONSE TO THE QUESTION 

Russell_Findlay_0-1675691425696.png

 

See Solution in Thread

4 Replies 4
Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

one way is to create a formula which creates a 1 if your condition (improved or greatly improved) is fulfilled and 0 if not.

then create a number element which you set to this field and then make the summary type average

Thanks so much! Can you let me know what those formulas would be?

Russell_Findlay
8 - Airtable Astronomer
8 - Airtable Astronomer

FORMULA 

Russell_Findlay_3-1675691115853.png

 

AND THEN NUMBER 

Russell_Findlay_2-1675691091866.png

 

Russell_Findlay_1-1675691066097.png

IF YOU HAVE BLANK RECORDS THEN YOU NEED TO FILTER THESE OUT AT THE NUMBER PHASE TO EXCLUDE ANY WHICH HAVE NOT GOT A RESPONSE TO THE QUESTION 

Russell_Findlay_0-1675691425696.png

 

Mary_Schafrath1
4 - Data Explorer
4 - Data Explorer

Thank you! This is magic!!