Pie Chart in Dashboards | Create Pie Chart
May 30, 2008 – 6:11 pm
In order to create a Pie Chart, your SQL should return two columns as shown below
select account , 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 account
(complete steps) Create Pie Chart for Dashboard