Hello Dhiren,
Administrators can create percent complete fields, which accept decimal input and appear as progress bars when displayed in lists.
For example, use a percent complete field to set the completion percentage for a task or project in a form and then see that percentage displayed as a progress bar in a list.
Administrators can also configure views that compare actual progress with a target value to determine if goals are being met and then apply color to provide visual alerts where progress does not meet expectations.
Create a percent complete field
You can add a percent complete field to a form.
Role required: personalize_form
- Navigate to any form.
- Right-click the form header and select .
- Create a new field and set the Type to Percent Complete.
- Click Add.
The new field appears at the bottom of the Selected list.
- Use the up and down arrow buttons to move the field to the desired location in the form.
- Click Save.
The form reloads and displays the new field.
Colors attribute
If the target_field attribute is configured, a second attribute called target_threshold_colors enables an administrator to define additional parameters.
The parameters are:
- Different thresholds at which the colored bar should change color
- A specific color for each threshold
The format of this attribute's value is number1:color1;number2:color2 and so on. Use this attribute to apply warning colors to completion percentages that are lower than target percentages. These values are defined as the percentage of target accomplished. For example, a value of 0:red;50:yellow;90:green displays a red bar if the progress to target pecentage is between 0-49. If the percent of target is between 50 and 89, the color is yellow. Percent of target 90 and above displays in green. Completion percentages that exceed target percentages also display in green. Order the color attributes from the smallest percentage to the largest.
If you do not specify a target_field, then a target of 100 is used, allowing you to use the color thresholds with a single field value.
target_field=percent_complete_target,target_threshold_colors=0:tomato;50:khaki;90:lightgreen
The following table lists examples of percent of target calculation using the colors defined above.
Target threshold colors attribute| Target percent | Percent field value | Percent of target calculation | Color |
|---|
| 100 | 40 | 40% | tomato |
| 65 | 59 | 90.7% | lightgreen |
| 15 | 10 | 66.7% | khaki |
For more information please refer the following link:
https://docs.servicenow.com/bundle/geneva-servicenow-platform/page/administer/field_administration/concept/c_CreatingAPercentCompleteField.html
https://docs.servicenow.com/bundle/london-platform-administration/page/administer/field-administration/concept/c_TargetThresholdColorsAttribute.html
Thank you!
Please mark it as Correct/Helpful if this helps you.
Regards,
Shubham
