Lift/Drag
Results 1 to 2 of 2

Thread: Lift/Drag
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Apr 2019
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Lift/Drag

    Hello! I’m working on reporting to show the overall impact an agent has on our site. Our site KPI goal is 90%; Agent 1 has 20 surveys averaging 80% Agent 2 has 100 surveys at 80%. Both are obviously not meeting but Agent 2 has a bigger “drag” to our site. Can someone help me with the formula that will show Agent 2 has a “drag” of -xx% to my site compared to Agent 1’s impact.

    Sorry if I didn’t explain that correctly. Any help is appreciated!

  2. #2
    Board Regular
    Join Date
    Nov 2006
    Location
    London
    Posts
    8,083
    Post Thanks / Like
    Mentioned
    20 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Lift/Drag

    It's not clear to me what you mean by "20 surveys and averaging 80%" - what is that an average of ?

    So if Agent 1 has 20 surveys and an average of 80% does that mean that 25 surveys were (I dont know) "offered" - but only 20 of the 25 people responded to the survey? 20/25=80%
    If so then Agent 2 has 100 surveys and 80% therefore 125 surveys were "offered" 100/125=80%

    So just take the number of surveys and divide by the percentage

    Agent 1 20/0.8 = 25
    Agent 2 100/0.8 = 125

    Therefore Agent 2 has the bigger "drag" since 125 is greater than 25.

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •