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

Average is correct, but Grand Totals not correct, weighted average?

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

Content

I have the following table that provides insights into last weeks performance.  The TTF / TTS are producing straight averages in the grand total and it's not weighted by how many actually accepted or started.   Thoughts on how I can get grand total to reflect the true value?   I believe in a pivot table it would account for this but I don't think my data set is appropriate for a pivot table.

Here's the formula for TTS to provide an example:

Avg((case when timestampadd(sql_tsi_day, -dayofweek(min(current_date)) -5, min(current_date)) < "Submission Dates"."Offer Actual Start Date" and timestampadd(sql_tsi_day, -dayofweek(min(current_date)) +1, min(current_date)) > "Submission Dates"."Offer Actual Start Date" then TIMESTAMPDIFF(SQL_TSI_DAY, "Requisition Dates"."First Fully Approved Date", "Submission Dates"."Offer Actual Start Date") end))

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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