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 ?