Platform Analytics forum
cancel
Showing results for 
Show  only  | Search instead for 
Did you mean: 

Forum Posts

Resolved! Report making: add columns from other table

Hi, I'm trying to make a report from table "Computer (cmdb_ci_computer)" but I'd like to add columns from another table "requested Item (sc_req_item)" like this ones: Number, name, activity for, item, etc..   But if I go to the colomn selector and ad...

KateN_2-1711552760537.png KateN_3-1711552856856.png
KateN by Tera Contributor
  • 2059 Views
  • 4 replies
  • 1 helpfuls

Creating a fixed date period filter

I want to create a fixed date period, for example in the attached image, if I choose the last 60 days, that 60 days is as of the current date and changes daily, however if I wanted to choose an exact period, i.e., a previous month, that will change a...

lebotlhabanyane_0-1709880656154.png

Resolved! Dashboard List Reports - Not Interactive Filters

Hi there, I'm wondering if there is any way (perhaps an iFrame or Java Script) to embed a list report (example incident.list) with that list's standard every field filtering functionality into a dashboard?  I do know that interactive filters are avai...

AN2023 by Kilo Guru
  • 1369 Views
  • 6 replies
  • 3 helpfuls

Embed list as Images in Scheduled Report Emails

Hello,I followed this great article (https://www.servicenow.com/community/performance-analytics-blog/embed-list-reports-in-a-scheduled-report-email/ba-p/2269771) to create the business rule, scheduled report with type selected as Png .For the Message...

Shree Nag by Tera Expert
  • 821 Views
  • 2 replies
  • 0 helpfuls

Report on Change approval ??

Does anyone know how to report on at risk changes with an approval? For example, I can report on the table sysapproval_approver to find the workflow activity name and the approval I need to find, but can't report on the details of the change (short d...

Gemma4 by Mega Sage
  • 485 Views
  • 3 replies
  • 0 helpfuls

Resolved! How to save a scheduled report output to a file share

We have a requirement to create a scheduled report to run monthly on open incidents and save the output to a file share for audit purposes.  We have looked at several Community articles but not seeing a solution. We do not want to email to have someo...

Colleen1 by Tera Contributor
  • 2106 Views
  • 3 replies
  • 1 helpfuls

Resolved! How to get the SUM of catalog variables in Report

Hello, I have a report requirement that need to get the SUM of all variables values using native reporting. The variable name is Total Cost for Dispatch. This variable is not available (tried dotwalk as well) from the Aggregate field in the report, h...

Report show the latest record

Hi all,One employee have multiple records in the table(Voluntary Agreement to Work Extra Hours), but I would like to only show the latest one in report. Could anyone help on this.Thank youBest Regards,

Screenshot 2024-03-21 175026.png
Jeff42 by Tera Contributor
  • 727 Views
  • 2 replies
  • 0 helpfuls

Resolved! Count Distinct on Incident_Metric -> Number column

HelloI would like to count distinct on the Number column in this table. Unfortunately it's not an option when I go to review the list of Aggregates. I saw another post about creating a new Indicator and Source for this to work. This seems like a lot ...

find_real_file.png
brandimore by Kilo Expert
  • 11097 Views
  • 21 replies
  • 3 helpfuls
Labels