--- sourceDocument: Australia Platform Analytics sourceDocumentLink: https://www.servicenow.com/docs/r/australia/now-intelligence Release : - australia ft:locale : - en-US ft:publication_title : - Australia Platform Analytics ft:clusterId : - par bundleId : - par workflow : - Platform --- # Spotlight interactive analysis # Spotlight interactive analysis {#ariaid-title1} Release version: Australia Updated March 12, 2026 ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 2 minutes to read Summarize ![AI sparkle icon](https://servicenow.com/docs/portal-asset/ai-sparkle-icon) Summarized using AI This content was generated using new OpenAI-powered functionality. Results are provided on an as is basis and are not guaranteed to be accurate or complete. ## Summary of Spotlight Interactive Analysis Spotlight Interactive Analysis provides key insights from a Spotlight job, accessible through a Spotlight Group record. To launch the analysis, users with thepaspotlightoradminroles can click the related link in the Spotlight Group record. This analysis utilizes a database view created automatically when the Spotlight group is established. Show full answer Show less ## Key Features * **Record Insights:** Displays the number of Spotlight records and unassigned fact table records exceeding the Spotlight Group threshold. * **Database View:** Joins Spotlight and facts table records, allowing users to create reports and include them in dashboards. * **Filters:** Users can apply interactive filters such as Priority, Opened Date, Age, Assignment Group, and State to refine the analysis. * **Sharing Capability:** Interactive analyses can be shared via URL, but the recipient must have the **paspotlightviewer** role. ## Key Outcomes By utilizing Spotlight Interactive Analysis, customers can gain actionable insights into their Spotlight job results, create detailed reports, and optimize their performance management with interactive filters. Access to this feature requires specific roles, ensuring that only authorized users can perform sensitive actions. For optimal use, ensure that the necessary database views are generated and that users have the appropriate roles for analysis and sharing. Spotlight interactive analysis shows the key results of a Spotlight job. Access the analysis from a Spotlight Group record. To open the Spotlight interactive analysis, open the Spotlight Group record for the group of interest and click the Launch Interactive Analysis related link. The pa_spotlight or admin role is necessary. Note: Interactive analysis uses the Spotlight database view. Spotlight creates the database view for each Spotlight group when you create the group. If the database view is missing, a warning appears. If you have the pa_spotlight or admin roles, a link also appears for generating a database view. For more information, see [Spotlight database views](https://www.servicenow.com/docs/9Ok7K0rbKxXGPGgaOQ4IJA "Spotlight ensures that a database view joins the Spotlight [spotlight] table and the facts table whose records the Spotlight group evaluates. You need this database view to use Spotlight interactive analysis. Administrators can access this database view to create reports or to diagnose problems."). Using interactive analysis with any table other than incident requires fully enabled, subscription version of Performance Analytics. See [Activating your Performance Analytics subscription](https://www.servicenow.com/docs/mX0Tfg3kcRs96YXiA6o3Og#c_PremiumPerformanceAnalytics "Without a paid Performance Analytics subscription, your use is limited to 180 days of data collection (five months for monthly indicators) and to specific indicators provided by ServiceNow, and you cannot activate Data snapshots. For unlimited access to all features, purchase a subscription to Performance Analytics."). Interactive Analysis contains the following information: * The number of Spotlight records. This value is also the number of corresponding fact table records that exceeded the Spotlight Group threshold. * The number of unassigned facts table records that exceeded the Spotlight threshold. These records have no value in the Assigned To column. * The database view that joins the Spotlight table with the facts table of the main indicator. Each row of this view shows the columns from a Spotlight record and the corresponding facts table record. Note: * If a user cannot see the values in this table, ensure that they have the itil role. * If domain separation is enabled, a user can only see Spotlights records for corresponding fact table records that are included in their domains. * You can create reports by using this database view as a data source. You can include these reports in dashboards. Each of the Analytics and Reporting Spotlight Solutions includes such a dashboard and reports. {#spotlight-interactive-analysis__ul_th1_z3k_bdb} For more information, see [Spotlight database views](https://www.servicenow.com/docs/9Ok7K0rbKxXGPGgaOQ4IJA "Spotlight ensures that a database view joins the Spotlight [spotlight] table and the facts table whose records the Spotlight group evaluates. You need this database view to use Spotlight interactive analysis. Administrators can access this database view to create reports or to diagnose problems."). {#spotlight-interactive-analysis__ul_tkp_q3s_pcb} You can apply interactive filters to the analysis. The following filters are available, for facts tables with the matching columns: * The Priority of the facts table record (tasks only) * When the record was Opened * The Age of the record * The Assignment Group (tasks only) * The State that the record is in {#spotlight-interactive-analysis__ul_nv1_shh_qcb}For information about adding or removing any of these filters, see [Add a filter to Interactive Analysis](https://www.servicenow.com/docs/BJs3xA6iCuhdG8qypksttw "Add a filter to show more refined information in your Interactive Analysis.") and [Remove a filter from Interactive Analysis](https://www.servicenow.com/docs/CyGjOclM7W97zjmY8F_tjg "You can remove a filter from Interactive Analysis and specify whether to remove the filter element from Group by and Stack by lists in the analysis."). Note: If you create an interactive filter for a Spotlight interactive analysis, the filter must be created on top of the relevant Spotlight database view. The admin role is necessary to access the database view. If you do not have this role, contact your system administrator. To share the interactive analysis, share the URL from the Filter Info. The user with whom you share the interactive analysis must have the pa_spotlight_viewer role. For more information about the Filter Info, see [Interactive Analysis information panel](https://www.servicenow.com/docs/6pwqM_UH3GSCOI~cdYG5mw#interactive-analysis-info-panel "The Filter Info panel summarizes what the current filter shows and enables you to edit the source filter condition, bookmark an interactive analysis, and share an interactive analysis with colleagues.").