Archive for the ‘Charts’ Category
Thermometer chart in Dashboard | Create thermometer chart
Friday, May 30th, 2008To create this chart, your SQL should return only one column and one row select sum(quantity_sold) as qty_sold from [detail_data$] where fiscal_year = 2001 and country_region like 'Americas' (Complete Steps) Create Thermometers in Dashboard Tags: thermometer chart, dashboard thermometer, dashboard gauges, jfreechart thermometer
Line Chart in Dashboard | Create Line Chart
Friday, May 30th, 2008The basic requirement for a line chart is same as the bar chart. You need minimum of two columns, if you add more than two columns then it adds another line in the same chart corresponding to the numeric column select job_type, max_salary as VAL , min_salary as SVAL from job_table (Complete Steps) Create Line ...
Dials and Gauges in Dashboards | Create Dial Charts
Friday, May 30th, 2008This is an alternative to the meter chart The requirement is the same as meter chart, your SQL should return only one column and one row, just a single cell value (Complete Steps) Create Dashboard Dials Tags: dashboard gauges, dashboard dials, dashboard charts, speedometer chart, dial chart, meter chart
Meters | Speedometer | Gauges | Dials in Dashboards
Friday, May 30th, 2008To create this chart, your SQL should return only one column and one row (Complete Steps) Create Dashboard Gauges
Pie Chart in Dashboards | Create Pie Chart
Friday, May 30th, 2008In 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
Stacked Bar in Dashboard | jfree stacked bar chart
Friday, May 30th, 2008The 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') & ' ...
Series Bar Chart | Dashboard Series Bar Chart | jfreechart bar chart
Friday, May 30th, 2008The 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') & ' ...
Bar chart in Dashboard | Create Bar Chart
Friday, May 30th, 2008A Bar Chart needs a minimum of two columns. The first column is the character based column (it could be a numeric but it forms the Axis column either X or Y). The second column is the numeric value column which represents the bars in the chart NOTE: You can have ...
Color code Bar chart based on numeric range value
Thursday, February 21st, 2008In the above example, the requirement is to code the bars based on the value of the bar. To achieve this you need to enable Dynamic Java Script and then add the following Java Script. You need to understand the code that is highlighted in Orange. Basically you can supply any ...
