How to create a report which are created and resolved in 24 hours

[Chandu Telu]

Hi Team,

How to create a report which are created and resolved in 24 hours do we need to create a custom report for this

Please help me on this

Thanks

Chandu Telu

[larstange]

Hi

There is an out of the box metric called "Create to Resolve Duration" running on the incident form. You can report on this on the "Incident Metric" table.

Something like this:

[sb1186 · Accepted solution]

Hi Chandu,

Try creating a report on Incident table with the following query and let me know if you get the expected results.

PS: Mark this answer as Correct if it solved your query or hit Like/Helpful depending upon the usefulness of the response.

Regards
Supriya Bisht

[Rajesh Mushke]

Hi Chandu,

add filter in your report below like i shared,

Report Saved: Created and closed Incidents in 24 hours

RunShow OtherAdd Filter ConditionAdd "OR" ClauseAdd Sort Field

All of these conditions must be met

Active KeywordsActiveActivity dueActual endActual startAdditional assignee listApprovalApproval setAssigned toAssignment groupBusiness ServiceBusiness durationBusiness resolve timeBusiness serviceCallerCategoryCaused by ChangeChange RequestChild IncidentsClose codeClose notesClosedClosed byCompanyConfiguration itemContact typeCorrelation IDCorrelation displayCreatedCreated byDelivery planDelivery taskDescriptionDomainDomain PathDue dateDurationEscalationExpected startFollow upGroup listImpactIncident stateKnowledge AricleLocationMade SLANotifyNumberOpenedOpened byOrderParentParent IncidentPriorityProblemReassignment countRecord ProducerReopen countResolve timeResolvedResolved bySLA dueService offeringSeverityShort descriptionSkillsStateSubcategorySys IDTagsTask typeTime workedUpdatedUpdated byUpdatesUpon approvalUpon rejectUrgencyUser inputWatch listWork notes listknowledgepriorityQuestionsShow Related Fields isis notis emptyis not emptyis anythingis sameis different ANDOR 'Delete'

Created KeywordsActiveActivity dueActual endActual startAdditional assignee listApprovalApproval setAssigned toAssignment groupBusiness ServiceBusiness durationBusiness resolve timeBusiness serviceCallerCategoryCaused by ChangeChange RequestChild IncidentsClose codeClose notesClosedClosed byCompanyConfiguration itemContact typeCorrelation IDCorrelation displayCreatedCreated byDelivery planDelivery taskDescriptionDomainDomain PathDue dateDurationEscalationExpected startFollow upGroup listImpactIncident stateKnowledge AricleLocationMade SLANotifyNumberOpenedOpened byOrderParentParent IncidentPriorityProblemReassignment countRecord ProducerReopen countResolve timeResolvedResolved bySLA dueService offeringSeverityShort descriptionSkillsStateSubcategorySys IDTagsTask typeTime workedUpdatedUpdated byUpdatesUpon approvalUpon rejectUrgencyUser inputWatch listWork notes listknowledgepriorityQuestionsShow Related Fields onnot onbeforeat or beforeafterat or afterbetweentrendrelativesince baselineis emptyis not emptyis anythingis sameis differentis more thanis less than TodayYesterdayTomorrowThis weekLast weekNext weekThis monthLast monthNext monthLast 3 monthsLast 6 monthsLast 9 monthsLast 12 monthsThis quarterLast quarterLast 2 quartersNext quarterNext 2 quartersThis yearNext yearLast yearLast 2 yearsLast 7 daysLast 30 daysLast 60 daysLast 90 daysLast 120 daysCurrent hourLast hourLast 2 hoursCurrent minuteLast minuteLast 15 minutesLast 30 minutesLast 45 minutesOne year agoLast Fiscal QuarterThis Fiscal QuarterNext Fiscal Quarter22/06/2017 ANDOR 'Delete'

Closed KeywordsActiveActivity dueActual endActual startAdditional assignee listApprovalApproval setAssigned toAssignment groupBusiness ServiceBusiness durationBusiness resolve timeBusiness serviceCallerCategoryCaused by ChangeChange RequestChild IncidentsClose codeClose notesClosedClosed byCompanyConfiguration itemContact typeCorrelation IDCorrelation displayCreatedCreated byDelivery planDelivery taskDescriptionDomainDomain PathDue dateDurationEscalationExpected startFollow upGroup listImpactIncident stateKnowledge AricleLocationMade SLANotifyNumberOpenedOpened byOrderParentParent IncidentPriorityProblemReassignment countRecord ProducerReopen countResolve timeResolvedResolved bySLA dueService offeringSeverityShort descriptionSkillsStateSubcategorySys IDTagsTask typeTime workedUpdatedUpdated byUpdatesUpon approvalUpon rejectUrgencyUser inputWatch listWork notes listknowledgepriorityQuestionsShow Related Fields onnot onbeforeat or beforeafterat or afterbetweentrendrelativesince baselineis emptyis not emptyis anythingis sameis differentis more thanis less than TodayYesterdayTomorrowThis weekLast weekNext weekThis monthLast monthNext monthLast 3 monthsLast 6 monthsLast 9 monthsLast 12 monthsThis quarterLast quarterLast 2 quartersNext quarterNext 2 quartersThis yearNext yearLast yearLast 2 yearsLast 7 daysLast 30 daysLast 60 daysLast 90 daysLast 120 daysCurrent hourLast hourLast 2 hoursCurrent minuteLast minuteLast 15 minutesLast 30 minutesLast 45 minutesOne year agoLast Fiscal QuarterThis Fiscal QuarterNext Fiscal Quarter ANDOR 'Delete'

Minimize