I have a dataset here and I'm not sure what the correct approach here is:
There is a base table, let's say "orders".
Each record of these orders have historical data in a linked table: "Status-History" with fields "status" and "date".
So for example for order 1 you find:
10/04/2011: Opened for review
11/04/2011: Adjustment made
19/04/2011: Review closed
03/08/2011: Appeal Denied
(any combination of these statusses are possible)
How would I load this so I can show things like:
- All orders opened or opened for review in a month and how many of them have been closed meanwhile.
- How many orders are removed which did not have had an appeal before
- How many tickets are in the status of their first Appeal
If someone has some idea's he'd like to share !
Thanks in advance