Hi Larry,
I had the same issue. ServiceNow is creating a problem and will fix it sooner or later.
In the meantime, here is how I fixed it:
Changing the value in the DATA metrics table, won't resolve this issue permanently.
The script that populates the Metrics is actually deleting the scores and re-create them every day.
Therefore, in the script include "CMDBGetWellBase" at the line 87 to 97, you can find the constants the developer teams have created :
_STAGES: { CRAWL: 1, WALK: 2, RUN: 3, FLY: 4 },
_CMDB_TABS : { TAB_ONE: 1, TAB_TWO: 2 },
As you can see the value are INTEGER.
However the value expected by ServiceNow is most of the time a String.
So I changed the those lines of script with:
_STAGES: { CRAWL: "1", WALK: "2", RUN: "3", FLY: "4" },
_CMDB_TABS : { TAB_ONE: "1", TAB_TWO: "2" },
In brief, the script is deleting the metrics and re-creating them every times it runs so the change has to be at the script level or as said Hnin, you could change it at the report level, but it is more difficult to revert multiple reports to the base line compare to changing the script to the base line.
And the actual issue was that the script tried to set a String with an Integer which sometimes result into unexpected results as we have both experienced.
I have tested this fix on my dev, test and production instances and it is working fine.
I hope it can help you, mark the answer as helpful if it did.
Best regards,
