Hi Everyone.
I have a question regarding how to build a specific check in a table:
I have an "id "record field that can have records in one month but not another.
For example, customer 001 visited a page in April 24 but not in May 24.
I want to differentiate those "id's" to see if in the following month the user id's are returning (so retained visitors) or if they are new visitors, and vice versa I would identify abandoned visitors.
Is there a way to do so?
This would be on an aggregated level so I want so in a given month who many are returning and how many are not.
I was able to achieve this in a Kpi but variables but that only compare the latest and the previous month.
Thank you in advance.
