title: Use SQL expression as calculated field in Amazon Quicksights
body: <p>I am trying to integrated a simple SQL expression in Amazon Quicksights, but every time I use the calculated field I get a error stating that the methods used are not valid.</p>
  
  <p>Amazon Quicksight does not let me use aggregate functions:</p>
  
  <p>ROUND((<strong>SUM</strong>(CASE WHEN dyn_boolean THEN 1 ELSE 0 END) * 100.0) / <strong>COUNT</strong>(session_unique), 2)</p>
  
  <p>I know that I can change the <strong>CASE</strong> into a <strong>ifelse</strong>, but that does not solve the entire problem.</p>