How to use Gantt chart with count (sum) in a graph portlet?

Discussion created by waely on Jul 30, 2008
Hi,I have a query with only three fields: incident_ID, start_date, finish_date and I want to represent this information in a graph portlet using gantt chart. I want to use bar chart  to show NUMBER of incidents that STARTED in a month next to the one that FINISHED. the attached image should explain everything clearly.  Note - in my query I will restrict the number of mounths to display so I only show few months.  any help is appreciated.thank you.