Hello Community,
I have a table in ServiceNow where every month data gets loaded related to a few KPI from an external source. The value of that KPI (It can be anything - string, date/time, duration, number, percentage) I am storing in a string type field called 'u_value'. Now the requirement is I want to create report for each KPI where I want to just display whatever is there in that value field. But I am unable to figure out how to do that using normal reports or Automated Indicator, as only count, count distinct, average, sum etc. functions are available for the score type report and it doesn't support string fields.
Also, I am open to try manual indicators but it's not possible for us to feed the data one by one in pa_scoresheet table. If any automation or scripting possible so that I can push the data from my custom table where we are storing the data from the external source to the manual indicator scoresheet.
Any help will be much appreciated.
Regards,
Debjit
