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.
UPDATE:
Made some adjustments to the conditions and it has provided me a bit more realistic output so working on this a bit more.
