ok I am trying to get me Speed to lead. I can easily get it from excel but looking to move into Qlik. I am having an issue when it comes to the 1st contact AFTER the lead was renewed.
(aggr(min(First_Timestamp_List),contactid)) - Pulls the most recent timestamp for the lead
(aggr(min(CallDateTime_CallLog),contactid)) -Pulls the 1st time we have a call for that lead.
I did try IF(CallDateTime_CallLog>=First_Timestamp_List,(aggr(min(CallDateTime_CallLog),contactid))) but this doesn't seem to take any effect in giving me the 1st time we called that lead AFTER the most recent timestamp for the lead
