Recreate a multi-level pivot table report in platform analytics

samclutterb
Tera Contributor

I have a report I use to show the summary of vulnerabilities and their ages using the vulnerability response module.

samclutterb_0-1721311401820.png

samclutterb_1-1721311415580.png

This works by using the rows vulnerability.vulnerability_age and vulnerability.summary.
However we are trying to transition over to platform analytics which doesn't use reports like you could in dashboards and when I try to recreate this in a data visualisation pivot table there is no vulnerability.summary option for some reason.

samclutterb_2-1721311612368.png

 

Is it normal for platform analytics to be missing elements like this and is there any underlying logic around which element won't be there. Furthermore is there anyway to recreate this report in platform analytics or at least add a copy of the existing report somehow through the advanced technical dashboard?

Thanks

 

 

4 REPLIES 4

Mark Manders
Mega Patron

The Xanadu release notes read:

 

Changed in this release

Analysis cache for indicators on data visualizations You can now cache indicator data as well as table data. Prefetching cached data Cached data with an expiration time of 8 hours or more is refreshed automatically within the 30 minutes before it would expire. You therefore don't have to wait for the dashboard or visualization to load new data the first time you view it for the day. Unloading Platform Analytics dashboards to update sets simplified Unload Platform Analytics inline dashboards to update sets with one click. Migration improvements Migration to the Platform Analytics Experience has added full migration of the following items in the Xanadu release:
  • V1 Pivot reports and pivot reports with multiple columns
  • Indicator scorecards with custom order and label names
  • Top X elements for Performance Analytics widgets for time series breakdowns​
  • Custom URL on-click behavior
  • Act as filter capability
  • Unconfigured reports, Performance Analytics widgets, and interactive filters: These objects are migrated to empty data visualizations and filter elements.
  • Cascading filters
  • Dashboard background colors
  • Chart interactions: drilling down from chart to chart

So probably not yet on your instance. If you are on Washington and you have the existing Pivot report on a dashboard, you could use the migration tool to see what it does with the report after migration.


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Can you share the link to the Xanadu release notes please? I was not able to find them.

Up until yesterday they were on NowSupport (this came from the RTP release notes), but as of now, you can find the Xanadu release notes on Docs: https://docs.servicenow.com/bundle/xanadu-release-notes/page/release-notes/family-release-notes.html

 


Please mark any helpful or correct solutions as such. That helps others find their solutions.
Mark

Thank you!