If you are trying to use SQLserver with InfoCaptor and are using the SQL Studio Express 2005 then you might encounter connection refused error Please try the following setup before attempting to connect open the Configuration ManagerStart -> Microsoft SQL …
Posted in How-to, SQL Server
This is a simple chart to generate. It needs only X and Y values select film_id x ,count(inventory_id) y1 from inventory group by film_id
Posted in Charts
This is similar to bubble chart Here is the SQL to generate Scatter plot select film_id x ,count(inventory_id) y1 ,count(store_id)/10 z1 , film_id y2,count(inventory_id)/5 z2 from inventory group by film_id
Posted in Charts
Bubble charts are very interesting as it provides a depth to the normal 2 dimensional values. The depth is percieved by the size of the bubble. You can create a bubble chart by providing a third column that represents the …
Posted in Charts
Time Series is similar to XY Series chart. The only difference is the first X axis represents a Date or Time value. The Second column represents the Y value. Similarly you can add multiple series by adding more columns to …
Posted in Charts
To create this chart all that is needes is just the X and Y information. The first column in your SQL should be the X value and the second column should be the Y value. If you are going to …
Posted in Charts