How to do a chart like this case ?

[mobo12345]

Hi,
   I want to do a pie chart. But I don't know how to do . Please give me a hint or sample
  This is my case.

   1. Suppose table_A has columns  a,b,c,datetime  such as
        a       b     c    datetime
       ----    ----  ----  ---------
        A1     B1    A11   2010-1-1
        A1     B2    A11   2010-1-1
        A2     B1    A11   2010-1-1
        A2     B2    A13   2010-1-1
        A3     B1    A11   2010-1-1
        A3     B2    A13   2010-1-1
        A1     B1    A11   2010-1-2
        A1     B2    A13   2010-1-2
        A2     B1    A11   2010-1-2
        A2     B2    A13   2010-1-2
        A3     B1    A13   2010-1-2
        A3     B2    A13   2010-1-2
            
   2. Given 2 parameters for time domain : start_time, end_time
       get data that satisfied time domain
      SELECT   a,b,c FROM table_A WHERE datetime >=$P{start_time}  AND datetime <=$P{end_time}
 3.  How to get 3 pie charts for above data and group by column a,b,c  that section key is  column a , value is counter

Thanks,
Mobo   

[despec]

Hello,

 

What exactly are you trying to count in fields a, b and c...Whatever the case, to make your chart come out right, you need to SQL "group by" something. Further information would be appreciated.

 

David