2 Replies Latest reply: May 23, 2013 9:24 AM by Rodrigo Giner

# Problem with Set Analysis and Max

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

• ###### Re: Problem with Set Analysis and Max

See attached qvw

• ###### Re: Problem with Set Analysis and Max

Thx, cant believe it was that simple. It seems I have a real problem undestanding when to use expression and when dimension.