CJA - Derived Field Persistence showing multiple values when "orginal" selected.

Question

Working with derived fields to calculate the time difference between users starting on page A and the time they took to start page B. Have setup a derived field that uses a case when statement to determine the timestamp when page A was reached and the same for page B. Below the when statement have used a type case statement to parse the time into DD-MM-YY hh:mm:ss time.

This part works great.

But when I define persistance within the component settings as “orginal” and “session” it returns serveral values, Where I’d expect it to only return the first instance of the timestamp.

Thank you in advance

Harveer_SinghGi1 · Answer

Hi ​@KirkBe1,Looking at the details you shared I believe the behavior is expected. If this is not the case you can share more details on what you are seeing and what was expected so that it is easy to troubleshoot.Based on what shared you have created a dimension that is supposed to return the timestamp of the very first event of a sessionwhere a certain page was seen. Now when you run a report for this dimension, it is going to look at all the sessions in the reporting period you selected then filter for the sessions where the given page was seen and finally fetch the timestamp of the first occurrence of the page value in each of those events. As this page could appear in multiple sessions during the reporting period the report is expected to return one timestamp from each of such sessions hence multiple values that you see. If you were looking at a single session, then you’d see only one item returned for this dimension.Cheers!

Sign up

Login with SSO

Login to the community

Login with SSO

Scanning file for viruses.

This file cannot be downloaded