Percentage Score
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.
Required 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
Optional Fields
good_score - either Low, High, or N/A representing coloring based on the threshold chart option
Return Data
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
Example Payload
A Javascript Object:
A screenshot of the data in ServiceNow:
Last updated
