You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Finding days between dates help

edited Dec 13, 2022 7:10AM in Taleo Enterprise 7 comments

Content

I'm back again. I'll learn this eventually, I hope.

So I want to know the avg number of days from when a submission is completed, to the time the submission hits a specific CSW step called HL Review.

This is what I tried with no success:

Avg(DISTINCT TIMESTAMPDIFF(SQL_TSI_DAY, "Submission Dates"."Submission Completed Date", FILTER("Submission CSW Status - Historical"."Historical Status Event Date" USING ("Submission CSW Status - Historical"."Historical Step Name" = 'HL Review'))))

But it doesn't take that. I don't think it likes Filter in a math formula.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!