Show the most recent row in chart

[zekazak]

Hello,

I've got the chart like this:

Email	Account ID	Date Created
Email1	11111	05/05/11
Email1	11112	06/05/11
Email1	11113	07/05/11
Email2	22222	12/05/11
Email3	33333	04/05/11

The question is how to display  "Email | AccountID | Date Created" where Date Created is the most recent. Is it possible to be setted up with expressions? So basically I want to see the result like this:

Email	Account ID	Date Created
Email1	11113	07/05/11
Email2	22222	12/05/11
Email3	33333	04/05/11

Any idea will be helpful.

Thank you in advance!

~Sergejs

[#2 · Accepted solution]

If you can do it in the load script with a preceeding load it would be ideal. It would look something like this.

LOAD email,[Account ID],MAX_DATE as [Date Created];

LOAD email,

     [Account ID],

     max([Date Created]) as MAX_DATE from table1 group by email,[Account ID];

[nagaiank]

As suggested by trey701, this can be done using load script. Example is attached.

[zekazak]

Hi both,

Thank you for your help. Very helpful and understandable explanation.

Best Regards,

~Sergejs