Max date in table expression

[ArjunPrasad]

Hi All,

i am creating a table with below dimensions and expression

Name, Title, worked_date etc...and expression : Count({<WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Max(Today()))"}>} WORKED_DATE)

i am getting values like below example

Name| title| worked_Date

Vijay| ACCT| 01/20/2021

Vijay| ACCT| 02/21/2021

Vijay| ACCT| 04/13/2021

from above i need to have one row per each person which max date row Vijay| ACCT| 04/13/2021

how can i get in chart expression

can you plz suggest..

thanks in advance

-Arjun

[Seyko]

Hello,

Use AGGR function for example : AGGR(MAX(worked_date), Name)

Regards

[JuanGerardo]

Hi @ArjunPrasad , in a chart expression you can use the TOTAL modifier:

Max(TOTAL <Name> worked_Date)

JG

[Anil_Babu_Samineni]

I agree with @Seyko , But should be used like this?

Max(Aggr(Count({<WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Max(Today()))"}>} WORKED_DATE), Name, title))

[ArjunPrasad · Accepted solution]

Thank you for Reply ,

in my case as per data below expression worked as expected

=Max({<WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Addmonths(Max(Today()),-1))"}>} WORKED_DATE)

and removed WORKED_DATE -Dim column from table and its worked.