How to Export Formula Indicator Scores from Platform Analytics (PA)?

[AnupriyaC]

Hi Everyone,

I'm trying to export the scores of indicators from ServiceNow Platform Analytics, but I haven't been able to find a working export option for the Indicator Scorecard.

I've tried the following approaches:

• Downloading the dashboard.
• Sharing the visualization through a scheduled report.
• Sending the visualization as a ZIP file.
• Exporting directly from Data Visualization, but it fails.
  
  

I also checked the underlying score tables:

• pa_scores appears to be empty.
• pa_scores_l1 contains data, but I can only find scores for automated indicators, not formula indicators.
  
  

Could someone please clarify the following?

• Is there a plugin, system property, or supported method to enable exporting indicator scores from the Indicator Scorecard?
• Where are formula indicator scores stored, particularly when pa_scores is empty?
• Is there a way to retrieve at least the latest score for each formula indicator, preferably through a combined export rather than exporting each indicator individually?

Any guidance on the supported approach or the appropriate tables to query would be greatly appreciated.

Thank you!

[Dr Atul - LNG]

HI @AnupriyaC 

What are you looking for? It doesn’t seem possible. It would be better to log a support case with the team, as you’re asking the same question in multiple places, which isn’t ideal.

[AnupriyaC]

Hi @Dr Atul - LNG , 

I’m looking for a way to export an indicator scorecard or the formula indicator scores, nothing else. I haven’t posted the same question multiple times. I’ve only been editing my original post to add more details.

[SasibhushanC604]

Hi Anupriya,

Based on your description, the behavior you are observing with pa_scores, pa_scores_l1, and formula indicators is expected in Performance Analytics.

1. Why are formula indicator scores missing from the score tables?

Formula indicators work differently from automated indicators.

Automated indicators collect and store their scores in the Performance Analytics score tables, whereas formula indicators calculate their values dynamically using the scores of their contributing indicators.

According to ServiceNow documentation, formula indicator scores are calculated when they are accessed through a dashboard, KPI Details, or Analytics Hub.

Therefore, formula indicator scores are not normally stored as independent records in pa_scores_l1 or pa_scores_l2.

Also, pa_scores is the legacy score table. Newer instances use pa_scores_l1 and pa_scores_l2, so finding pa_scores empty is not necessarily an issue.

2. Is there a plugin or system property to enable formula indicator export?

I am not aware of a documented plugin or system property that enables direct bulk export of calculated formula indicator scores from the Indicator Scorecard.

Since formula indicator values are calculated dynamically, enabling an export option would not automatically create stored score records.

3. How can formula indicator scores be retrieved?

I recommend investigating the Performance Analytics Scorecard API.

A ServiceNow employee previously recommended this API for retrieving formula indicator scores.

You can check the available operations through REST API Explorer:

System Web Services → REST API Explorer → Performance Analytics Scorecard API.

Test the retrieval with one formula indicator first and compare the returned value with the score displayed in the Scorecard.

Ensure that the reporting period, indicator frequency, and any breakdown selections match.

4. How can multiple formula indicator scores be exported together?

If your requirement is to retrieve the latest score for multiple formula indicators in one export, I would recommend the following approach:

1. Identify the required formula indicators.
2. Retrieve their calculated scores using the supported Scorecard API operations.
3. Extract the indicator name, identifier, reporting period, and score.
4. Combine the responses into a single dataset.
5. Export the combined results to CSV or JSON.

This can be automated through a scheduled integration or an appropriately designed server-side process.

If recurring reporting is required, another option is to store the retrieved results in a custom reporting table and export them from there.

5. Recommended approach

Since your requirement is specifically to export formula indicator scores rather than the underlying automated indicator scores, I would not recommend querying pa_scores_l1 directly for the final formula values.

The most appropriate starting point is the Scorecard API, because the formula results are calculated rather than independently stored.

Please test the API with one formula indicator before implementing the combined export, as supported operations and parameters can vary by ServiceNow release.

References:

ServiceNow – Formula Indicators:
https://www.servicenow.com/docs/r/now-intelligence/performance-analytics/formula-indicators.html

ServiceNow – Migrating Indicator Scores:
https://www.servicenow.com/docs/r/now-intelligence/performance-analytics/pa-scores-migration.html

ServiceNow Community – Export Scores of Formula Indicator:
https://www.servicenow.com/community/platform-analytics-forum/export-scores-of-formula-indicator/td-...

ServiceNow Community – Export PA Scoresheets:
https://www.servicenow.com/community/platform-analytics-forum/is-it-possible-to-export-pa-scoresheet...

[AnupriyaC]

Hi @SasibhushanC604 , 

Thanks for the detailed response! Could you please share more details about the Scorecard API? The community post is a bit vague, and some of the links don't seem to work.

Also, is there a way to export data directly from the Indicator Scorecard data visualization? I’m specifically looking to export formula indicators, but I couldn’t find their scores in pa_scores, pa_score_l1, or pa_score_l2.

Would the Scorecard API help retrieve these formula indicator scores, or is there another recommended approach?

Thanks for your help!