Hi,
Consider a scenario where I want to get the occurrence count for events occurring between the difference of two metrics of the type datetime.
E.g. ingested records in aep contains two fields 'timestamp' and 'purchaseTimestamp'. I want to find the count of records for which the difference in 'timestamp' and 'purchaseTimestamp' lies between the category of '0-5 Min', '5-10Min', '10-15 min'.
Any suggestions, help is much appreciated
Topics help categorize Community content and increase your ability to discover relevant content.
Views
Replies
Total Likes
You can achieve this using Adobe Experience Platform Query Service (SQL) by categorizing records based on the time difference between timestamp and purchaseTimestamp
Views
Replies
Total Likes
Can it be achieved on CJA?
Views
Replies
Total Likes
Create a calculated metric with below function
DATEDIFF("minute", purchaseTimestamp, timestamp)
This function calculates the difference between timestamp and purchaseTimestamp in minutes.
Views
Replies
Total Likes
I don't believe there's currently a way to do to this in CJA. The derived field functions that work with datetime fields are limited. As @manojs57813206 mentioned, Query Service may be the best approach for now.
Alternatively, you could perform a full table export with both timestamps, but it'd probably be easier to use query service.
Views
Likes
Replies