title: APEX - Create chart via "group by" query
body: <p>Using the query</p>
  
  <pre><code>SELECT TRUCK_CLASS, COUNT(1) FROM TIC_TRUCK GROUP BY TRUCK_CLASS
  </code></pre>
  
  <p>I can display, in the SQL Commands console, a table that sums all the elements from the column <code>TRUCK_CLASS</code> by name.</p>
  
  <p>For example, if my table is something like:</p>
  
  <pre><code>Name   - Class 
  
  Entry1 - Heavy
  Entry2 - Light
  Entry3 - Heavy
  </code></pre>
  
  <p>The query returns:</p>
  
  <pre><code>Name  - Count(1)
  
  Heavy - 2
  Light - 1
  </code></pre>
  
  <p>How can I turn this into an APEX chart to display a visual representation of the quantities?</p>
  
  <p>For example a pie chart displaying a 33% / 66% value, or a vertical chart, the type does not matter (as long as i can see that one class category is bigger than another). The goal is to display this chart on a page region in an application.</p>