How to generate report based on some calculation.

[Manish2]

Dear Team,

I am looking for feasibility/solution for one of the requirement based on excel calculation and how i can implement the same in  snow reporting module.

Here is the ticket data which is pulled from service now manually to apply some filter criteria.

Calculation which derive all the % values in the excel.

I would like to understand is there any possibility to create such report in service now and it has Incident as well as the SR data. 

Thanks,

Manish 

[Sanjay Bagri1]

Hi ,

 Yes, You can create a report based on the your requirement but first you have to load the your excel data into Service now.

So you can create one table with same fields which is in excel file for this activity in service now  and import/load the data into service now table. after that you go to report module and create the report .

but you have to do manual this process.

For importing Data follow the link:

Import a translation from an Excel spreadsheet

Mark as correct and Helpful if my suggestion helped to you. So others will be benefited for same kind of thread and remove this thread to unanswered list of community.
Thanks
Sanjay B.

[Manish2]

Hello Sanjay,

Thanks for reply.

Ticket & SR count is already there in service now and we can pull this data from the table to apply some filter criteria and if i have  to upload this data with all calculation then there is always manual effort and no point to use the reporting module. I want to generate such calculated report from service now itself weekly basis to avoid the manual/human interfere.

Thanks,

Manish

[ARG645 · Accepted solution]

Create a new field and Populate it with the calculated values via a Business Rule. You cannot build a virtual field on the report, so you have to create a column on the table physically. Note:- filed of type ‘calculated’ cannot be used in reports, so you have to use business rules.