Need assistance on report building on - # of items in next X amount of days

[Joel O]

Hi everyone, 

Looking to get your assistance on building a performance analytic or a visualization that I am having difficulty producing. The use case is to generate a visualization that showcases the # of onboardings in the next 10 days.  As this is a rolling # depending on when this report is viewed, it would need to show those records always 10 days out. 

To achieve this number, we have added a column "u_new_hire_date" on the sc_req_item table that populates based on the start date given by our HR email notifications. I would like to use that field to calculate the # of onboardings that are in the next 10 days. 

I've attempted to build an indicator to help with this however I'm having difficulty with the conditions. To be honest, I'm not sure if going down the route of building a indicator and such is the best route (see attachment). This is what I was trying to achieve but was a work in progress.

New to the Performance Analytic build and as well with scripting, however open to thoughts if this might be better to achieve. We only have OOB Performance Analytic application so maybe I'm limited. 

Open to your questions and thoughts on getting this report built out. 

Thanks everyone. 

[Joel O · Accepted solution]

UPDATE:

Made some adjustments to the conditions and it has provided me a bit more realistic output so working on this a bit more.

[Joel O · Accepted solution]

UPDATE:

Made some adjustments to the conditions and it has provided me a bit more realistic output so working on this a bit more.

[kaushal_snow · Accepted solution]

@Joel O ,

You can build a report (or Performance Analytics indicator) against your sc_req_item table using your u_new_hire_date field and set the filter so the date is between Today and Next 10 days (i.e. a relative date filter), therefore every time the report or dashboard runs it always counts the RITM scheduled to onboard in the coming 10-day window ........... if the out of the box relative options don’t fit exactly you can also use a scripted date/time condition (or compute a helper days until start field) to dynamically capture those records and then count them........

If you found my response helpful, please mark it as ‘Accept as Solution’ and ‘Helpful’. This helps other community members find the right answer more easily and supports the community.