How can I optimize my reports loading time

[Marcia2]

I have a report reporting on the Incident table, to do the count of how many p1 incidents were resolved this month, last month, and this year, these are different reports. Problem these reports takes very long time to return the results. I have tried to play around with the query but I am not seeing any improvement. So my query also does a dot walk to the Assignment group table to filter by assignment group owner custom field and also dot walk to Assignment group then User to get Division. Those are the only 2 filters that I do the dot walk. Could this be the cause of the slow loading of the report?

So my query would like 

Resolved on 'Last Month' AND Contact type != 'External System' AND Closed code != 'Close Cancelled' AND Priority is 'Critical' AND Assignment Group.SDM.Accountable Division in(...) AND  Assignment.Group Ownership is " ownership"

For this query to load it is taking about 1 and half minute. How can one make the query respond a bit faster?

Thanks

Marcia

[Musab Rasheed]

Hi Marcia,

First add 'Active' false in your filter condition and see if that improves.

Regards

[Marcia2]

Thanks Musab, I tried adding that, but unfortunately I am not seeing any difference

[Tsura Andreeva]

I would suggest creating data source and using that instead of the incident table, here is an article that talks about best practice:

https://community.servicenow.com/community?id=community_article&sys_id=0c3c6661dbd0dbc01dcaf3231f961947

hope that helps

[Marcia2]

Thanks Tsura, so I tried using an existing data source and add additional conditions to it, however the response is still the same