Pie Charts in Zucker Reports ? or Dashboard

[VeonConsulting]

Hi

We have a current requirement wherein i have to generate a pie chart in Zucker reports.
I'm Currently using ireports-jasper reports as a tool to generate my reports

I want to generate a pie chart on the following database fields in cases module, with status

date_entered
status

Is it possible to show the pie chart divide into 4 sections lets say

Current week : 30 cases(number of cases in that particular week)
2nd week :40 cases
3rd week :20 cases
Rest of the weeks: 40 (number of cases in rest all weeks)

I can generate a count on the number of cases but my major problem is how to divide the chart into 4 sections,
since it has to to be queried on the single field 'date_entered'

Or is it possible to generate something like this using dashboard inside SugarCRM?

Any Suggestions or help on this would be greatly appreciated!

[VeonConsulting]

Hi,
Any suggestions how to proceed ?

[gunni]

MAybe some select like (just pseudo code no correct syntax and did not test it):

SELECT IF(date_entered<now()-7days,1,IF(date_entered<now()-14days,2,IF(....)) as sector, count(*) as quantity
GROUP BY sector