title: Google Data Studio with BigQuery Data Source Issue in Calculated Fields and Aggregation
body: <p>I have a Google Data Studio dashboard that loads really slowly since it's using Google Sheets as a Data Source. I migrated the same data to BigQuery then used it as my new Data Source however, I came across an issue:</p>
  
  <p>When creating a calculated field, the new calculated field is not tagged as <code>Auto</code> in the <em>Default Aggregation</em> I still have to select <code>Sum</code> as a D<em>efault Aggregation</em>. This causes problems in my report. Also, it's not Blue, where normal fields are shown as green, and calculated fields are shown as Blue. </p>
  
  <p>When I was using Google Sheets, I could do direct computations in the calculated fields.</p>
  
  <p><strong><em>Example</em></strong>:</p>
  
  <pre><code>Handle Time = Talk Time / Number of calls
  </code></pre>
  
  <p>I just create a calculated field called <code>Handle Time</code>, then put the formula <code>Talk Time / Number of calls</code></p>
  
  <p>Now, I need to create 3 separate Calculated Fields:</p>
  
  <p><strong><em>Calculated Field 1</em></strong>: <code>SUM(Talk Time)</code></p>
  
  <p><strong><em>Calculated Field 2</em></strong>: <code>SUM(Number of calls)</code></p>
  
  <p><strong><em>Calculated Field 3</em></strong>: <code>Calculated Field 1 / Calculated Field 2</code></p>
  
  <p>This is even though I already tagged them as <code>Sum</code> in the <em>Default Aggregation</em>. Can anyone help me understand what I'm doing wrong?</p>