how can I show only the data you have the latest date?

[#1]

I have a graphic (single table), and I have many similar values, but with different dates:

A _____12/03/09

A _____03/09/07

A _____10/12/08

A _____01/11/09

B _____11/04/05

B _____30/08/08

C _____24/09/08

C _____07/01/09

There can be no repetition, and I need to show only the data with the last date.

In this case:

A _____12/03/09

B _____30/08/08

C _____07/01/09

Someone can help me?

[pover]

In the table with the dimension Field_ABC you can try the expression:

max(aggr(max(Date), Field_ABC))

Regards.

Edit: Forget my answer. Lunch has me sleepy. The good answer is below.

[renjithpl]

Hi,

for more idea. please find the attachment

regards

Ren

[#4]

Hi Rodrigoreis!

a don't know if this data are in dimension ou expression ..... anyway...

in expressions use max(date)

but don't forget to put the variable corrsponding to A,B and C as a dimmension ..

I hope that it help you!

[#5]

give me a exemple, please:


I have a table (graphic), with 3 colums (product, date, field to complete)

A ------- 12/03/09 ------ xxx

A ------- 03/09/07 ------ xxx

A ------- 01/11/09 ------ xxx

B ------- 11/04/05 ------ xxx

B ------- 30/08/08 ------ xxx

(the third column is not important)

product and date have a dimension, and the third column have a expression

how can I complete the fields in the dimension?

There can be no repetition, and I need to show only the data with the last date.

Someone can help me?

[#6]

Hi there, you can accomplish this, by substituting the Date dimension on your chart with a calculated dimension containing the following formula:

=aggr(date(max(Date)),Product)

The other expressions and dimensions should remain the same.

Regards

[#7]

thanks Ivan, but I need show only one:

example:

before:

A----12/01/09---xx

A----20/12/08---xx

B----30/04/07---xx

B----03/09/10---xx

after:

A----12/01/09---xx

A----12/01/09---xx

B----03/09/10---xx

B----03/09/10---xx

now I need to form a group, showing only one data

in this case:

A----12/01/09---xx

B----03/09/10---xx

*I have to use simple table

[#8]

Hi there,

what might be happening is that you have a date with timestamps, which you can be stripped out within the script or perhaps the formula, with something similar to the following:

=aggr(date(floor(max(Date))),Product)

The other thing that might be happening is that you might have some other dimensions that are dividing the data in one more level, also there might be some interference if you have some other formulas in the chart. Perhaps you can provide some more information on the other elements that are interacting in your chart.

Regards