Question on how to convert the report to Excel using a script.

kishorekrish212
Tera Contributor

‎04-09-2025 11:08 PM

I am currently I developed the report on the metric table for one assignment group. Now report I need to convert to Excel (in additionally I need total duration of one assignment group) Should it possible? if yes, could you please guide me in the proper method

kishorekrish212_0-1744264662451.png

 

Advance thanks.

 

 

0 Helpfuls
  • 321 Views
2 REPLIES 2

Prathamesh26
Tera Expert

‎04-09-2025 11:13 PM

Hello @kishorekrish212 

 

Please go through below link once.

Link - https://www.servicenow.com/community/now-platform-forum/generate-excel-file-xls-or-xlsx-based-on-scr...

 

Kindly mark my answer as helpful and accept solution if it helped you in anyway. This will help me be recognized for the efforts and also move this question to solved bucket. 

 

Regards,

Prathamesh

Nilesh Pol
Tera Guru

‎04-09-2025 11:19 PM - edited ‎04-09-2025 11:20 PM

@kishorekrish212 yes, You can group your report by "Assignment group" and add an aggregation (sum) on Duration to shows  total in the report before export.

Go to the "Configure" tab under "Group by", select Assignment group in "Aggregation", select SUM on the Duration field (make sure it's a numeric type — more on that below) Click Run. You will now see total duration per group.

finally, export your ServiceNow report to Excel and also calculate the total duration for a specific Assignment group by clicking the three dots (⋮) or the "gear" icon in the top-right corner of the report.