We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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
29
Views
7
Comments
edited Feb 18, 2020 9:31PM in Reporting and Analytics 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!