How to show latest Record in table

Rajesh — Wed, 26 May 2021 07:28:47 GMT

Hi All,

I trying to create one table to show employees latest record based on Last_Worked_Date date field.

below is the sample data image:

and Expected Out put Image is below: ( Need to achieve in front end)

i have took dimension are : Name, Job title, Prod_name, ulti_parent, resi_state, Division

Expression field:(Last Worked Date) : Max({<LAST_WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Addmonths(Max(Today()),-1))"},Job_title={"*ACC*"}>} LAST_WORKED_DATE)

here the issue is when i adding dimensions like Prod_name, ulti_parent, resi_state, Division the data is showing multiple rows for one employee, if i dont add it showing expected records.

but i need to show this columns also in table as per client requirement.

Can u Plz find attached sample data excel and advise me the solution.

Thanks,

Rajesh.

Re: How to show latest Record in table

Rajesh — Wed, 26 May 2021 10:38:53 GMT

at last its worked out on my new expression.😊

Expression field:(Last Worked Date) :

=Date(max({<LAST_WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Addmonths(Max(Today()),-1))"},Job_title={"*ACC*"}>}Aggr(Max({<LAST_WORKED_DATE={">=$(=Addmonths(Max(Today()),-13))<=$(=Addmonths(Max(Today()),-1))"},Job_title={"*ACC*"}>}LAST_WORKED_DATE),NAME)))

Thank u

Rajesh

topic Re: How to show latest Record in table in App Development

How to show latest Record in table

Re: How to show latest Record in table