what I did :
I created a formula date field on the Case object displaying the open date if the case is still open and the close date if closed.
I created a report and put filters on date : open in the last 30 days OR closed in the last 30 days.
I group my cases by my formula date field and sub group them by status (open or close). So I have a nice bar chart where i can see where I close more than new case are created by my customers and vice versa.
The problem is :
how to display a case that have been open AND closed on the same date ?
The only idea I can find is creating a formula field with 3 values : Open, Close, Close on open date. So i could have a bar chart with a specific bar for those cases. It gives another level of information but i would like to keep my chart simple with just two bars.
Have you any idea ?
2 respostas
Hi thanks for the fast answer !
But it means my whole chart is impossible since every case open in the last 30 days and closed in the same day range will only appear has closed. any idea on how to proceed ? I really would like to compare new case to close date.
