I understand this could be more on the SQL side but worth a shot on here.
I have a field (caseStatus) where it tells me the status of a case. The 5 case statuses are:
Case Opened
Case Awaiting Check
Case Awaiting Confirmation
Case Rejected
Case Accepted
I want a way to save the date the case status changes between these three options.
This may be more of an SQL thing rather than a QuickSight job.
The reason for this is that if a case is on “Case Opened” for a day, then moves to “Case Awaiting Check” and stays like that for a week, we know it’s not worth chasing a case which has been idle for a week.
Whereas if we see a cases which has go from “Case Opened” to “Case Awaiting Confirmation”, in a day, and then two days later it goes to “Case Awaiting Confirmation”, we know it will be worth chasing this case.
The end result should be a caseID, by the date the case moved to that stage.
