Series Bar Chart | Dashboard Series Bar Chart | jfreechart bar chart
The basic requirement is that the SQL query should return three columns
for e.g.
select Format(date,’YYMM’) & ‘ - ‘& Format(date,’MMM’) as Month , switch(class is null,’Unknown Class’,class is not null,class) as class_type, sum(amount) as Expense
from
[qb_data$]
where “Account Type” = ‘Expense’
and date between #10/1/2007# and #05/23/2008#
and class like ‘%’
group by Format(date,’YYMM’) & ‘ - ‘& Format(date,’MMM’), switch(class is null,’Unknown Class’,class is not null,class)
order by 1 asc
(Complete Instructions) Create Series Bar Chart in Dashboard
Tags: series bar chart, bar chart, jfreechart bar chart, dashboards, project dashboard
