This content has been marked as final. Show 2 replies
I have a problem, that cant solve.
I have this table
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.