How many days prior to/late to employee start date was the Catalog Item submitted

[mateuszniew]

Hello Everyone, 

I am looking for a way to see how many days prior to OR late to employee's start date was the specified catalog item submitted. 

We basically want to see if requestors adhere to the requirements we've set - are they submitting them properly 5 days prior to the start date, or are they late and submitting afterwards.

Ideally, this would be a chart/pivot table in PA, but I am not sure if its doable in it.

Thank you!

[Matthew_13]

Yes indeed;  this is definitely possible and PA is a good way to do it. You just need to make the timing difference explicit.

The trick is that PA can’t directly “compare” two date fields unless you give it a value to work with. So you first need to calculate how many days before (or after) the start date the request was submitted.

A common way to handle this is:

• Take the employee start date from the catalog item / variable

• Subtract the request submission date sys_created_on of the RITM

• Store or calculate the result as a number of days

From there, the reporting becomes straightforward:

• Positive number → request submitted early

• Zero → submitted on the start date

• Negative number → submitted late

Once you have that number PA can easily show:

• How many requests met the “5 days prior” requirement

• How many were submitted late

• Trends over time in a chart or pivot table

If PA feels heavy for this, you can also do it with a normal report using a calculated field, but PA is the better choice if you want ongoing compliance tracking and dashboards.

If you can tell me where the start date is stored catalog variable RITM field.  

@mateuszniew - Please give a Accepted Solution and Thumbs Up if you find Helpful!!

[mateuszniew]

Hey Matthew,

thank you a lot!

Start date is stored in a variable start_date on the form and is pulled from the HR table sn_employee_profile from employment_start_date field.

Is it possible to do it without the custom table?

Thank you!