Percentage Score
Last updated
Last updated
The Percentage Score generates a percentage based on the two sets of conditions defined. The first set of conditions acts as the numerator, while the second set acts as the denominator. If you want to change the score color based on a value, use the 'Good score' and 'Benchmark' fields.
table - the table to query.
conditions - the first set of conditions to compare to
second_conditions - the second set of conditions to compare to
good_score - either Low, High, or N/A representing coloring based on the threshold chart option
An array containing two other arrays with a single value each. The first array contains a string representing the percentage and the second array contains a string with either "good", "bad" or "neutral" representing the relation to the threshold and good score
A Javascript Object:
A screenshot of the data in ServiceNow:
