Dashboard Articles, Tutorials, Screenshots, Discussion
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, dashboard dials, dashboard charts, speedometer chart, dial chart, meter chart
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 ‘%’
group by account
(complete steps) Create Pie Chart for Dashboard
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 Steps) Create Stacked Bar chart in dashboard
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
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 which represents the bars in the chart
NOTE: You can have more than two columns but all of the remaining columns should be numeric
(Complete Instructions) How to create Bar Chart in Dashboard
Tags: bar chart, jfreechart, dashboards, change bar colors
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 sending their Quickbooks data, they expressed a lot of concern.
You don’t need to upload your financial information to third party, not anymore.
Follow the simple steps and you can test drive the dashboard on your local PC
Please download and install the base files http://www.infocaptor.com/files/test/infocaptor_setup.exe
The qb_dash_export.xls is just sample Quickbooks file
Would you like to see the above charts using your Quickbooks Data?
Tags: excel, expense, finance, kpi, mybizhomepage, peachtree, quickbook-dashboards, quickbooks, salesquickbooks,peachtree,sugarcrm,small business
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 the need to install the repository objects on the database and hence can be little time consuming.
This alternative tutorial is a shortcut to just test the web-server install. It is not a replacement to the repository install.
For e.g. If you are evaluating InfoCaptor and have created a test dashboard and would like to see how it behaves when deployed on the web then follow the steps below.
You need a webserver (Apache or IIS or anything that can serve PHP pages). If you would like to setup a webserver on your PC then try this excellent free tool http://sourceforge.net/projects/phpdev5
PHPDEV installs a local Apache webserver so you can just create directory under www and copy files.
Let us assume the following
Here is how a sample looks like
NOTE: db_driver strings for relevant databases
and so on.
Save the single_dashboard_on_server.php file and then transfer all the files in the zip archive to the webserver directory
You can now launch your dashboard by pointing the following URL in your browser
The dashboard will open up using Java webstart.
If you need to setup the complete repository which will allow you to create users, assign roles to users, assign dashboards to each user then you need to follow this setup guide
Tags: dashboards, web dashboards, download dashboards, design dashboards, webstart dashboards, server dashboardsquickbooks,peachtree,sugarcrm,small business
One of the new features available in the upcoming release is the ability to auto-refresh multiple dashboards and automatically cycle through each dashboard.
You can set the cycle rate by clicking on the options button, click on the “Auto Refresh & Cycle Each Dashboard” checkbox and select the refresh rate at the desired number of seconds.
Issues: Currently if the refresh rate is set very low, Java is not able to trigger the Garbage collection and hence it creeps memory and eventually the application becomes un-responsive.
Ideally if the refresh rate is set to 2-3 minutes then it should run fine on a good machine. Ocassionally you may need to restart InfoCaptor if it starts slowing down.
Along with this we are also working on launching multiple dashboards at once using a common config file. This should go handy with the Auto-refresh and cycling option.
You can test drive the auto-cycle option using this test version
What are the benefits of this feature?
We already have had the auto-refresh feature, and auto-cycling of dashboards during refresh is a natural extension of the feature. We have numerous users and clients asked for the cycling feature so that a DBA or Sysadmin person can setup a dedicated desktop just to monitor the metrics. If the metrics are corporate goal specific then they could also be broadcasted over a TV or a huge display for employee awareness.
Tags: dashboard on tv, tv dashboards, auto refresh dashboards, auto cycle dashboards
Any data and statistics stored in a computer or available on paper are potential Key Performance Indicators (KPIs) that can be translated into electronic dashboard displays.
In transport business, trucks, buses, ambulances, taxis, and other vehicles that transport people or products, the cost of operation is an essential measure of business performance. This along with the variety of other issues - scheduling, vehicle availability, repair status, etc. - can all be measured, monitored and managed by using Dashboard Programs.
Some issues that transportation companies may wish to track include:
* Vehicles in use.
* Vehicles available.
* Vehicles in for repairs.
* Drivers operating.
* Drivers available.
* Hiring/training status.
* Shipment schedules.
* Operating cost per mile.
* Deadheading.
* Accident statistics.
We can help you create dashboard solution for your business. contact”AT”infocaptor.com
Tags: gsmdashboards, kpi, metrics, mybizhomepage, quickbooks, restaurant, transport, transport kpis, transportation dashboardquickbooks,peachtree,sugarcrm,small business