I want o calculate the weighted average for the AHT column in the below data

Date Volume AHT per case in sec 1/2/2019 7188 44 sec 2/2/2019 453 123 sec 3/2/2019 345 563 sec

Like this i have data for 30 days. I want to calculate the weighted average AHT for the 30 day period. Direct average doesn't work here since the AHT column is driven by volume. Can you please help me with this

  • $\begingroup$ Question is unclear, also can you format you data better. $\endgroup$ – user2974951 Sep 18 '19 at 12:42

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.