-
1. Re: Aging Report for Incident open longer than 30,60,90 days
kedar zavarApr 5, 2018 3:34 PM (in response to Tina Thomas)
You need to use this created date or opened date - now() > 60 use formula return type number.
Simple create field 1 to find out no of days passed say created date - now()
Use this in new formula say No days passed > 30 then
Kedar
-
2. Re: Aging Report for Incident open longer than 30,60,90 days
Anne BrockApr 6, 2018 10:16 AM (in response to Tina Thomas)
I don't know if this is useful, but this is a report I did using a bucket field showing how long it took to close tickets. Might be able to do something similar for what you are looking for.
-
3. Re: Aging Report for Incident open longer than 30,60,90 days
Tina Thomas Apr 12, 2018 6:48 AM (in response to kedar zavar) -
4. Re: Aging Report for Incident open longer than 30,60,90 days
kedar zavarApr 12, 2018 6:57 AM (in response to Tina Thomas)
I will post an example here today
Kedar
-
5. Re: Aging Report for Incident open longer than 30,60,90 days
Eric Cobb Apr 12, 2018 7:47 AM (in response to Tina Thomas)Hi Tina,
You can actually do this in the report itself if you would like. You would just have to add the filter logic on each report to only show records that are Greater than 30 but less than 60 days. I have attached a screenshot that may help. You would have to have 3 different reports that would show the different filter criteria to get this.
Hope this helps.
Thanks,
Eric
Eric J Cobb
Oceanforce Solutions
-
6. Re: Aging Report for Incident open longer than 30,60,90 days
kedar zavarApr 12, 2018 8:08 AM (in response to Tina Thomas)
Tina Thomas here is an example , you can make changes as needed
How to Calculate the Age of an Incident and Report on these Values.
Kedar
-
7. Re: Aging Report for Incident open longer than 30,60,90 days
Tina Thomas Apr 16, 2018 2:34 PM (in response to Tina Thomas)This the what I had to set up for the formal field to get it to work.
IF ( NOT(ISNULL(BMCServiceDesk__closeDateTime__c)),
BMCServiceDesk__closeDateTime__c - BMCServiceDesk__openDateTime__c,
NOW() - (BMCServiceDesk__openDateTime__c ))
-
8. Re: Aging Report for Incident open longer than 30,60,90 days
Tina Thomas Apr 16, 2018 2:34 PM (in response to Tina Thomas)Just want to thank everyone for their help