Help

How to count single record's completion rate

Topic Labels: Data Formulas
Solved
Jump to Solution
721 3
cancel
Showing results for 
Search instead for 
Did you mean: 
yuannc12
5 - Automation Enthusiast
5 - Automation Enthusiast

Hey I would like to know if there is a way to create a  summary per record instead of per filed? like, how may empty per record? Many thanks!!

yuannc12_0-1676295466668.png

 

1 Solution

Accepted Solutions

Okay, so from what you're describing, I'm imagining something like this:

Ben_Young1_0-1676568152237.png

Here's the formula I used:

IF(
    OR(
        {Field 1}, {Field 2}, {Field 3}, {Field 4}, {Field 5}
    ),
    SUM({Field 1}, {Field 2}, {Field 3}, {Field 4}, {Field 5}) / 5,
    0
)

Naturally, if you decide to add additional fields later on, you'll need to update the divisor in the equation.
Additionally, the 0 in the falsy parameter for the IF() function is optional.

If you want the formula to return nothing if the fields are all blank, then you can omit the 0.
If you always want a value to be returned, in this case a 0%, then you can just leave it in.

Be sure to confirm that your formula formatting is correctly configured.

Ben_Young1_1-1676568431470.png

 

See Solution in Thread

3 Replies 3

Hey @yuannc12

Without having many details about exactly what you're trying to do, it would seem that you first need to create a formula field that will return a summarized value for each record.
Then you would be able to use the values of that formula field to return the view-summarized metric that you're looking for.

Hey Ben! thanks for your reply 

An example of my questions is, if I have a record (field 1(filled), field 2(empty), field 3 (filled), field 4(filled), field 5(filled)), how to create field 6 to calculate the percent filled of this singe record (filed 1-5) which is 80%? 🙂 
with the formula, I'm not sure how to best compose the code, which I am looking for help as well 

Okay, so from what you're describing, I'm imagining something like this:

Ben_Young1_0-1676568152237.png

Here's the formula I used:

IF(
    OR(
        {Field 1}, {Field 2}, {Field 3}, {Field 4}, {Field 5}
    ),
    SUM({Field 1}, {Field 2}, {Field 3}, {Field 4}, {Field 5}) / 5,
    0
)

Naturally, if you decide to add additional fields later on, you'll need to update the divisor in the equation.
Additionally, the 0 in the falsy parameter for the IF() function is optional.

If you want the formula to return nothing if the fields are all blank, then you can omit the 0.
If you always want a value to be returned, in this case a 0%, then you can just leave it in.

Be sure to confirm that your formula formatting is correctly configured.

Ben_Young1_1-1676568431470.png