Hi All,
I have a transposed script i need to find max date based on Quarters for each project.
Any suggestions?
This script helps to find Max date .
Trans3:
NoConcatenate
Load
ProjectID_SYS,
[Updated On],
[Value Before Update] as N_Customer_Traction_Status
Resident [Metrics History]
where [Metric Name]='Customer Traction Status';
Join
load
ProjectID_SYS,
Timestamp(Date(Max([Updated On]),'MM/DD/YYYY hh:mm:ss TT')) as Maxmetric
Resident [Metrics History]
where [Metric Name]='Customer Traction Status'
Group by ProjectID_SYS,[Metric Name];
Trans4:
NoConcatenate
LOAD ProjectID_SYS,[Updated On],N_Customer_Traction_Status,Maxmetric
Resident Trans3
where Maxmetric=[Updated On];
drop Table Trans3;
