To 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 …
The 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 …
This 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, …
To create this chart, your SQL should return only one column and one row (Complete Steps) Create Dashboard Gauges
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 '%' …
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$] …
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$] …
A 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 …
If you have been researching dashboard and reporting options for Quickbooks, you may have come across websites that ask you to upload your financial information into their server. A lot of small business owner when surveyed about the idea of …
Posted in Excel, How-to, quickbooks
We already have a detailed tutorial on how to setup InfoCaptor on the web-server and we receive lot of requests on how to setup or put the dashboards on the web. This server setup guide is quite comprehensive and requires …
Posted in DB2, Excel, General, MS Access, MySQL, Oracle, SQL Server