Report/PA: How to return a date?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-28-2025 01:48 PM
In platform analytics, or for that matter in reporting, how can I show the user the datetime their import ran? I have a scheduled data import and one of the data points I want on the screen is when it last ran.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-28-2025 02:19 PM
Do you want to see when the last report ran? or any screenshot of what you are referring to?
If my response proves useful, please indicate its helpfulness by selecting " Accept as Solution" and " Helpful." This action benefits both the community and me.
Regards
Dr. Atul G. - Learn N Grow Together
ServiceNow Techno - Functional Trainer
LinkedIn: https://www.linkedin.com/in/dratulgrover
YouTube: https://www.youtube.com/@LearnNGrowTogetherwithAtulG
Topmate: https://topmate.io/atul_grover_lng [ Connect for 1-1 Session]
****************************************************************************************************************
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
04-10-2025 07:45 AM
In a word, yes. I want to use a dashboard to give the user visibility into last night's import, but I also want them to see the import date, without devoting a list column to sys_created_on. This would be helpful if we let them repeat the import on demand. It's not obvious to me how you get a dashboard to display a single value like that.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
03-30-2025 05:55 PM
I want the sys_created_on of the most recent import set for this import. So if we are importing device data from supplier X into the hardware table, and we expect to run this import daily, I want the user to be able to put together a dashboard that shows the data that was imported last night, how many rows were skipped, how many inserted and so on. To do that they will need to fetch the sys_id of the most recent import set and filter down to the Import Set Rows where the Set.sys_id matches that value. That's no problem, I can supply them with the necessary scripted filter. But another data point they will want is the datetime the import ran, and I'm not sure how to display that data point in reporting. The Single Score does not seem to contemplate fetching a single data point and displaying it as-is.
