Average is correct, but Grand Totals not correct, weighted average?
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))