Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all
I have a straight table i need to pull only 1 value based on max date and project. suggest me
Script used to derive the data.
Trans3:
Load
ProjectID_SYS,
[Updated On],
[Value Before Update] as N_Customer_Traction_Status
Resident [Project Metrics History]
where [Metric Name]='Customer Traction Status';
Trans4:
load
ProjectID_SYS,
if([Metric Name]='Customer Traction Status',Timestamp(Max([Updated On]),'MM/DD/YYYY hh:mm:ss TT')) as Maxmetric
Group by ProjectID_SYS,[Metric Name];
"TT" represents AM, PM in time
Thank you i got it