http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help: Forum: How-To - Recent Posts en Tue, 06 Jan 2009 06:52:05 +0000 http://dashboard.infocaptor.com/topic/number-formatting-sql-server-dashboard#post-37 Tue, 30 Dec 2008 19:55:24 +0000 njethwa 37@http://dashboard.infocaptor.com/ <p>It seems that the Ship date is a numeric column and not a date datatype. InfoCaptor date column format is applicable to only date and time columns.</p> <p>Can you confirm what type of column is the ship Date? You could use the SQL server specific convert functions <a href="http://msdn.microsoft.com/en-us/library/ms187928.aspx" rel="nofollow">http://msdn.microsoft.com/en-us/library/ms187928.aspx</a></p> <p>In your case, if Ship Date is a numeric column such as int then you could try the following for ship date</p> <p>select convert(datetime,convert(char(8),ship_date)) as shipping_date ...</p> <p>Once your SQL returns a datetime column, you could use InfoCaptor's date formatting. </p> http://dashboard.infocaptor.com/topic/number-formatting-sql-server-dashboard#post-36 Tue, 30 Dec 2008 19:35:19 +0000 guest 36@http://dashboard.infocaptor.com/ <p>Thanks for helping out….I got the $ numbers to display correctly, but as far as the dates being pulled from the SQL tables they are in YYYMMDD format. I have tried various settings but they do not affect the display. I am looking for MM-DD-YYYY. (don’t mind the 2030 Year…it is a scheduling thing.) </p> http://dashboard.infocaptor.com/topic/dbcs-support#post-33 Mon, 29 Dec 2008 15:30:02 +0000 admin 33@http://dashboard.infocaptor.com/ <p>Do you mean DBC file for Oracle Application connections? InfoCaptor doesn't need dbc file but it can connect using Oracle apps authentication. It can connect to various other databases provided jdbc driver is available. </p> http://dashboard.infocaptor.com/topic/dbcs-support#post-32 Mon, 29 Dec 2008 15:29:42 +0000 admin 32@http://dashboard.infocaptor.com/ <p>To whomever it concerns, does infocaptor support DBCs? </p> http://dashboard.infocaptor.com/topic/inventory-balance-trend-in-ms-sql#post-31 Fri, 26 Dec 2008 17:04:30 +0000 admin 31@http://dashboard.infocaptor.com/ <p>email reply--</p> <p>Thank you and happy holidays</p> <p>As I understand, you have a SQL query that returns the current inventory balance from the database.</p> <p>Does your table have any kind of date column? For e.g If you are sql query is like<br /> select sum(inventory_balance)<br /> from inventory_transactions</p> <p>then is there any other time related column in the inventory_transactions table? If there is then you could apply database functions to get the week part from the date for e.g</p> <p>select format(trx_date,'MMM') as period, sum(inventory_balance)<br /> from inventory_transactions<br /> group by format(trx_date,'MMM')</p> <p>You could then put this query in the chart editor and select a bar chart type.</p> <p>If you don't have any time related columns in your table then you would need some mechanism to capture that information or store the weekly snapshot in a seperate table and use that table for your chart. </p> http://dashboard.infocaptor.com/topic/inventory-balance-trend-in-ms-sql#post-30 Fri, 26 Dec 2008 17:03:29 +0000 admin 30@http://dashboard.infocaptor.com/ <p>Happy Holidays...<br /> I have downloaded InfoCaptor, and it is exactly what I am looking for! thank you!<br /> quick question....<br /> I plan on using it to access MS SQL databases.</p> <p>How do you track items that do not have datebase fields.<br /> For example, I have a SQL query that looks at our inventory balance when the SQL statement is run. How would I track the results on let's say a weekly basis with a chart? TheSQL statement result is point in time. Where are the results stored so that I can monitor a trend? </p> http://dashboard.infocaptor.com/topic/changing-pie-chart-to-bar-chart#post-27 Mon, 17 Nov 2008 23:57:01 +0000 admin 27@http://dashboard.infocaptor.com/ <p>With the new release of InfoCaptor this restriction is removed. You can change the existing chart type as long as the SQL query returns the desired number of columns to support the chart type. </p> http://dashboard.infocaptor.com/topic/changing-pie-chart-to-bar-chart#post-26 Fri, 25 Apr 2008 15:25:17 +0000 admin 26@http://dashboard.infocaptor.com/ <p>*Email Response*</p> <p>Once you create one type of chart, it is not possible to change to a different type. For e.g in your case you created a Pie chart so in order to test the line or bar chart, create a new chart with the same query but before you click apply, select a line type.</p> <p>The trial software is fully functional so you should be able to achieve anything you needed. Feel free for any more queries or help. </p> http://dashboard.infocaptor.com/topic/changing-pie-chart-to-bar-chart#post-25 Fri, 25 Apr 2008 15:21:50 +0000 admin 25@http://dashboard.infocaptor.com/ <p>I have just downloaded the trial version of the software and it looks to be exactly what we are looking for within our small business.</p> <p>I could do with some advice regarding bar/line charts. I wrote a simple query which displayed ok as a pie chart but when I changed the chart type to anything except pie/pie 3D it is blank. I tried putting in a dummy third column as suggested in the tutorial but it still did not display. See screenshots below.</p> <p>I also tried creating a barchart using a basic spreadsheet as a data source but could still not get it to work. Am I doing something wrong or is it a limitation of the trial software? </p> http://dashboard.infocaptor.com/topic/display-percent-sign-on-the-portlet#post-24 Sun, 13 Apr 2008 20:27:52 +0000 admin 24@http://dashboard.infocaptor.com/ <p>You can right click on the particular column, select the Column Settings Tab, On the 'Number Format' enter a string like 00.00%<br /> , Click on Apply and refresh the portlet.</p> <p>The format is applied if the number is between 0 and 1, for e.g a number like .2 will be displayed as 20% </p> http://dashboard.infocaptor.com/topic/display-percent-sign-on-the-portlet#post-23 Sun, 13 Apr 2008 20:27:16 +0000 admin 23@http://dashboard.infocaptor.com/ <p>I am trying to include a % in the output. I connected to excel that has a number of rows that represent percentages and other rows that are numbers. The formatting from excel is lost when I retrieve the data. How can I represent a perctage&gt; </p> http://dashboard.infocaptor.com/topic/connect-to-excel-file-as-sql#post-20 Thu, 10 Apr 2008 20:20:06 +0000 admin 20@http://dashboard.infocaptor.com/ <p>Yes, absolutely. Once you download the setup file, it automatically launches a sample dashboard and the tutorial on how to build it using Excel file </p> http://dashboard.infocaptor.com/topic/connect-to-excel-file-as-sql#post-19 Thu, 10 Apr 2008 20:18:47 +0000 admin 19@http://dashboard.infocaptor.com/ <p>I need to know if this application will link to Excel as the data source as well as SQL. We hope to conduct a pilot program using Excel first and migrate to SQL after approval. </p> http://dashboard.infocaptor.com/topic/dashboard-traffic-light-widget#post-4 Thu, 10 Apr 2008 19:49:00 +0000 admin 4@http://dashboard.infocaptor.com/ <p>2) Is there some sort of traffic light widget that I can use to indicate is something is alright or not eg, green for everything is OK, Amber for some issues and Red for failures </p> <blockquote><p> You can use the Meter chart type and you can create sections for red,yellow, green etc </p></blockquote>