title: oracle apex chart - line graph sql?
body: <pre><code>select count(case when extract(month from C_DATE) = 1 then 1 end) as Jan,
     count(case when extract(month from C_DATE) = 2 then 1 end) as feb,
     count(case when extract(month from C_DATE) = 3 then 1 end) as mar,
     count(case when extract(month from C_DATE) = 4 then 1 end) as april,
     count(case when extract(month from C_DATE) = 5 then 1 end) as may,
     count(case when extract(month from C_DATE) = 6 then 1 end) as jun,
     count(case when extract(month from C_DATE) = 7 then 1 end) as jul,
     count(case when extract(month from C_DATE) = 8 then 1 end) as aug,
     count(case when extract(month from C_DATE) = 9 then 1 end) as sep,
     count(case when extract(month from C_DATE) = 10 then 1 end) as oct,
     count(case when extract(month from C_DATE) = 11 then 1 end) as nov,
     count(case when extract(month from C_DATE) = 12 then 1 end) as december
  from Table1
  </code></pre>
  
  <p>Currently That is the query i have which produces the result </p>
  
  <pre><code>Jan Feb Mar Apr .....
  1   3    1   2
  </code></pre>
  
  <p>now i want to display this information in a line graph so it looks like this joined up</p>
  
  <pre><code>3       x
  2
  1  x           x
    jan   feb   mar 
  </code></pre>
  
  <p>Being abit of a noob with charts i cant get it to work when i try to use my current query. any help much appreciated </p>