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