Hello ServiceNow Community,
I am newer to the ServiceNow Dev space and had a question specifically about if there is an easy way to access formula indicator scores? They don't show up in either the pa_scores_l1 or pa_scores_l2 tables. I think I saw somewhere that SN automatically blocks them.
The end goal is to create a task when a daily formula indicator exceeds three standard deviations beyond an average. In this case, the average and standard deviation are based off the prior month's daily rates. E.g., all of June's scores (3.5, 3.0, 2.7, 1.8, 1.7, ect.) would be the array that the average and standard deviation are derived from. Accordingly, if in July of 2023 a daily formula indicator score were to exceed three standard deviations of the configured prior month's average, a task would be created. This dynamic needs to be applied to each breakdown element ('vendor_name' in this case). And just for reference, the data that informs the formula indicators (all the indicators for that matter) is a custom table that houses vendor orders and if they are delivering the order on time. Ultimately, we are just trying to take action quickly if they have a daily order rate spike significantly.
I know about the Scorecard API, but was hoping to avoid going that route in case there is an easier solution of accessing the formula indicator scores data, but very much open to suggestions!
