How to pick max date

[vinod2086]

Hi all,

am facing one issue i have created one calculated dimension as new_date based on date and name .

here for single name more than two date's are available in my new_date column it displaying all date's my question is how to take max date value from new_date column.

Thanks in Advance

[Gabriel]

Hi,

Try using

Max(Date(New))

[anbu1984]

Can you post calculated dimension expr

[#4]

You can use max(date) in the calculated dimension expression and then concatenate it with name.

Thanks

Khushboo

[aapurva09]

Hi,

If you are able to create that logic in script, you can use this:

Load Name,

        max(Date) AS New_Date

Resident Table

GROUPBY Name;

Use New_Date as Dimension, it will give you only one date per Name and that will also be max date for that Name.

[vinod2086 · Accepted solution]

Thanks for all replays,

i have changed exp now its working fine

=Aggr(Max([Date]),_ID)