title: Analyzing raw data from a Google Sheet into a 'dashboard'
body: <p>Situation:</p>
  
  <p>Every time I visit a member of my field team, I put their 'score' into a Google Form, which then puts the raw data into this <a href="https://docs.google.com/spreadsheets/d/1lMSJA2LM7em3PDZM344QIr2SA8uRWDYYHnOFEacmbCA/edit?usp=sharing" rel="nofollow noreferrer">Sheet</a>.</p>
  
  <p><strong>I'd like a second Dashboard sheet that has:</strong></p>
  
  <ul>
  <li><p>all of the raw data, plus a calculation of their "overall score" (an average of parts A, B, C, and D)</p></li>
  <li><p>a way to easily see the average score of each person per quarter (Q4 2016, Q1 2017)</p></li>
  <li><p>a way to easily see the average score for each type of Observation (Live vs scenario #1, 2, 3)</p></li>
  <li><p>a drop-down where I can select a user and see their scores on a chart compared to the rest of the group's averages </p></li>
  </ul>
  
  <p>I've done some of the work<a href="https://docs.google.com/spreadsheets/d/1lMSJA2LM7em3PDZM344QIr2SA8uRWDYYHnOFEacmbCA/edit#gid=501829031" rel="nofollow noreferrer"> [here]</a>, but would love some help to figure out the best way to do this (keeping in mind of the performance of the sheet considering I'd actually have thousands of rows of raw data).</p>
  
  <pre><code>*Things to note:*  
  
  * I might score one person twice in a row before getting to the next person
  
  * I might score one person twice in a month (I'm not sure how to show that in the Dashboard)
  </code></pre>
  
  <p>Thank you in advance for your help.  I'm trying to learn as much as I can, but it's all still pretty new to me.</p>