Find your people. Pick a challenge. Ship something real. The CreatorCon Hackathon is coming to the Community Pavilion for one epic night. Every skill level, every role welcome. Join us on May 5th and learn more here.

How does the ‘Show Records’ option work in Analytics Hub?

NadaE5036861430
Giga Contributor

Does it display:

  1. The current live records that match the widget conditions,
    or
  2. The exact set of records captured at the time of the snapshot used to calculate the widget score?

For example, I have a widget called ‘Weekly Project Status Trend - Red & Yellow’, which shows the number of projects with Red or Yellow status per day based on Performance Analytics snapshots.

On March 9, the widget shows that there were 9 projects with Red status.

 

When I click on that score and open ‘Show Records’ in Analytics Hub, what should I expect to see?

  • The 9 Projects that got captured at that day keeping old data?
  • The 9 Projects that got captured at that day but with their current state? (so if one of these 9 projects current status is now green i will still see it but status will be displayed as green) opposite of first point
  • Only what from 9 Projects captured on that day that their status is still red?

Widget.png

 

1 REPLY 1

Tanushree Maiti
Kilo Patron

As per Servicenow Documentation:

 

Showing records in the Analytics Hub

You can toggle between showing a time series of indicator scores and a list of the records used to calculate those scores.

Click Show Records or Hide Records in the upper right corner to toggle. In either case, the scores or records are shown for the time period that is chosen at the top of the tab. The scores or records are also filtered by any breakdown/element pairs that you selected.

If you opened the Analytics Hub from a breakdown dashboard with multiple elements selected, what you see depends on the dashboard widget. If the widget displays each element value separately, you see the records that match the element you selected. If the widget displays an aggregate score of the elements, you see the records that match any of those elements.

Note:
  • Records are shown only for automated indicators.
  • The Show Records function is not supported for real-time scores of unmatched breakdown elements. If you are viewing scores in real time, records that are not assigned to any breakdown element are not displayed.
  • You can change the view of the list of records in the context menu of the Records list, depending on the views available to the facts table. The default view is set on the indicator source.
  • In some cases, when you collect second-level breakdowns, the score and the number of records do not agree. When these values do not agree, the score is correct. For more details and an example, see KB0748969.

 

 

Refer these links as well:

KB1001542 In Performance Analytics, clicking on Show Records button for an indicator in Analytics Hu... 

Please mark this response as Helpful & Accept it as solution if it assisted you with your question.
Regards
Tanushree Maiti
ServiceNow Technical Architect
Linkedin: