In the calculation you can give a 'score' based on the value of a different field. In the template below, the calculation field value will be 1 if variable_x is in between 1% and 19%, 2 if variable_x is in between 20% and 39%, etc:
| If variable_x is... | The score is... |
| In between 1% and 19% (incl. 1 and 19) | 1 |
| In between 20% and 39% | 2 |
| In between 40% and 59% | 3 |
| In between 60% and 79% | 4 |
| In between 80% and 100% | 5 |
Template:
var score = 0;
if ({variable_x} >= 1 && {variable_x} < 20) {
score = 1;
} else if ({variable_x} >= 20 && {variable_x} < 40) {
score = 2;
} else if ({variable_x} >= 40 && {variable_x} < 60) {
score = 3;
} else if ({variable_x} >= 60 && {variable_x} < 80) {
score = 4;
} else if ({variable_x} >= 80 && {variable_x} <= 100) {
score = 5;
}
score;