Dear All,
I have table as you can see in the attached file. Each ID has a history action as below :
Analyst_Test
Waiting_Information
IT_Under_Development
IT_Under_Planning
Delivery_Bekleniyor
Postponed
Developing
Case_Closed
User_Test
Waiting_Authorization
Rejected
Drop_Out
I would like to show below issues on a chart.:
- To count the ids which are under user_test over 3 (or n) days.
- To count the ids which are under analyst_test over 3 (or n) days.
- To count the ids which doesn't have any action more than 2 weeks.
- To count the ids which has IT_Under_Planning state and has not Case_Closed state for more than 6 weeks.
Please note that each id has several action type with different dates. So the above requirements must be based on ids which has the latest action.
Thanks for your support.
Best Regards,
