Issue with Aggr function

[Anonymous]

Hi everybody,

i have this example:

ID	DOC	STATE	DATE
123	1	OPEN	01/04/2016
123	2	CLOSE	30/03/2016
123	3	PROGS	15/03/2016
124	1	OPEN	03/04/2016
124	2	CLOSE	15/05/2016

I need to create a bar char that counts:

To ID=123 ---> bar char shows 1 in 01/04/2016 (in max date)

To ID=124 ---> bar char shows 1 in 15/05/2016 (in max date)

I dont know if use an aggr function to group by ID, and use max(Date) to show data.

Besides, in another char, i have to group by state (the state of last date).

I only use char Expressions,

Can anyone help me?

Thanks a lot!!

Regards,

Paula.

[Anonymous]

Thank you Sunny,

i have resolve that problem with:

=sum({<DATE>} Aggr(If(DATE = Max({<DATE>}TOTAL <ID> DATE), 1, 0), ID, DATE))

and for STATE, i think is the same adding the STATE you want... Right??

=sum({<DATE=, STATE={'OPEN'}>} Aggr(If(DATE = Max({<DATE=, STATE={'OPEN'}>}TOTAL <ID> DATE), 1, 0), ID, DATE))

Thank you!

[sunny_talwar]

I would guess so... try it out and see if it works or not