I have a problem, that cant solve.
I have this table
| Ticket | Count | Date | Status | Side |
|---|
| 1000 | 1 | Feb 2013 | Open | Me |
| 1000 | 2 | Feb 2013 | Question | Client |
| 1000 | 3 | Mar 2013 | Process | Me |
| 1001 | 1 | Feb 2013 | Open | Me |
| 1001 | 2 | Feb 2013 | Question | Client |
| 1002 | 1 | Mar 2013 | Open | Me |
| 1002 | 2 | Mar 2013 | Question | Client |
| 1002 | 3 | Jul 2013 | Process | Me |
| 1003 | 1 | Jul 2013 | Open | Me |
| 1003 | 2 | Jul 2013 | Process | Me |
What I need is a Bar Chart with 2 columns (Me and Client) discriminated by month/year. Where I have to show How many tickets do I have for each month, but only I have to Count the last status ( the Max Count field)
So based on this example:
| Should be 4 in total, cause I have only 4 distinct tickets, 1 in "Client" on Feb 2013, 1 in "Me" on Mar 2013, and the last 2, 1 in "Me" and 1 in "Client" on Jul 2013 |
I cant find the way to only show the last status for each ticket, It can be solved only with set analysis or I should have to use aggr ?
I leave the example.
Thx
