I am having issues wrapping my mind around how to do this.
Say I have a thing… called Cases
A user creates new a case, there is a field called Case Status which has two options - open or closed.
I need to show on a dashboard the average number of days to closure for the cases…
But #1 I am not sure where/how to store the date/time when the case status field changed to close
and
#2 I don’t know how I can show on the dashboard page, what that average days to case close is (among all of the case statuses)
I hope this makes sense, can anyone help?