We are a software company and want to run a saved search or report that tells us how many support cases have come in for a specific customer since they took our latest upgrade. Our customers do not all get our latest release at the same time. We want to see how that spike in support calls changes the longer they have had the new release.
I have a custom date field on the customer record called release application date, that we record the date they took their current release. I have another custom text field that I record which release they are currently on.
I need to create a saved search where I can say, "For all customers that are on release 8 (based on the value of the custom record above) I want to see all support cases that were created on or after their release application date." So in other words I want to set my criteria to pull only cases with a dateCreated value greater than or equal to the release application date.
So.... If CaseDateCreated >= ReleaseApplicationDate
And to make this a little more confusing, I would like to group the results by customer, week of CaseDateCreated.
Any advice would be much appreciated. Thank you!!