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

Finding days between dates help

Received Response
49
Views
7
Comments
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!