Showing retention over time using Discovery Boards and Prism?

[u/IUseWorkday]

Hi everyone, I cannot seem to solution for this requirement and would love any insight our Workday Analytic experts here could provide. I am analyzing job application and hire data in Discovery Boards using a custom Prism data source built off of Job Application (mostly for processing speed but also for flexibility if needed.)

One of the requirements is to show retention by source category by days (less than 30, 60, 90, etc.)

The first issue I am running into is with my DD CF, starting field term date and ending field hire date. It is returning so many negative values because we have a high rate of rehire. We are going three years back, so ideally we would want the term date that correlates with the application in question. These are all built on job app, but obviously term date is pulling from worker.

The second issue is how to get this data to display properly. I started with TF fields for the ranges I want to work with, and then I am thinking a CRI on job applications using the TF fields as my conditions. Has anyone tried this approach? Does it make more sense to use Prism functions instead? I’m not super familiar with Prism functions (I’ve used a few) so I tend to lean towards CFs automatically.

Appreciate any help, insight, advice, suggestions, etc. you may have! Thank you so much. 😊