CJA - Time between events | Community
Skip to main content
Level 2
October 22, 2025
Solved

CJA - Time between events

  • October 22, 2025
  • 3 replies
  • 713 views

New to CJA but this seems like it should be straightforward. (always does)

What to create two derived fields and then use those in a Date Math function to figureout the delta time between them. 

I have defined both of the derived fields and when used in a report bring back expected data. 

Issue comes in when I try and used those two derived fields to create a new derived feild. 

System says the first and second rule are not referanced in final output. 

But I can't 'see' the option to select them in the Date Math operator. 

 

 

 

 

 

Best answer by KirkBe1

Thank you all. Figured it out. It was user error. 

I was using the custom timestamp and should have been using the event timestamp. 

 

Use the second one here, not the first one. 

 

3 replies

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 23, 2025

I don't have CJA, but your approach looks logical to me... 

I will try and see if I can find someone more familiar with CJA derived fields to help.

KirkBe1Author
Level 2
October 23, 2025

Thank you . 

blasta86794993
Level 2
October 24, 2025

Hi @kirkbe1 !

 

I can't seem to recreate the issue on my end, my first thought was that the derived fields you are using are the wrong data format. When I use the Timestamp from Event Datasets, I don't see the "event" scope option on the date math function, only session and person. Does it work when you change the scope on that date-math function to "session"?

 

 

 

 

AnitaMummert
Adobe Champion
Adobe Champion
October 24, 2025

oops, I logged in on the wrong account to post this reply!

KirkBe1AuthorAccepted solution
Level 2
October 28, 2025

Thank you all. Figured it out. It was user error. 

I was using the custom timestamp and should have been using the event timestamp. 

 

Use the second one here, not the first one. 

 

Jennifer_Dungan
Community Advisor and Adobe Champion
Community Advisor and Adobe Champion
October 28, 2025

Glad you figured it out!