Hello, working in salesforce spring17. I am trying to create a 3 different report that show ticket open 30,60,90 days over create date. I would like for one report to show 30 >and <60 only, >60 and <90 only, 90> and <120 only. I tried creating a formula field but I am not sure if this works
Apr 5, 2018 3:34 PM
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
Apr 6, 2018 10:16 AM
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.
Sorry I was Out of the office ..This is what I am getting when I try and duplicate
Apr 12, 2018 6:57 AM
I will post an example here today
Kedar
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
Apr 12, 2018 8:08 AM
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
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 ))
Just want to thank everyone for their help