http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help: Recent Posts en Sun, 23 Nov 2008 11:56:05 +0000 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/lot-of-users-licensing-type#post-22 Thu, 10 Apr 2008 20:23:07 +0000 admin 22@http://dashboard.infocaptor.com/ <p>Yes, in that case you will need a site license. </p> http://dashboard.infocaptor.com/topic/lot-of-users-licensing-type#post-21 Thu, 10 Apr 2008 20:22:50 +0000 admin 21@http://dashboard.infocaptor.com/ <p>If I have a web app with a lot of users, internal and<br /> &gt; external to my company, do I need a site license? </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/expand-and-collapse-feature-of-a-particular-row#post-18 Thu, 10 Apr 2008 20:17:26 +0000 admin 18@http://dashboard.infocaptor.com/ <p>I understand your request but this feature is not available presently in InfoCaptor.</p> <p>Yes, you can deploy InfoCaptor on any webserver and launch it with a URL. </p> http://dashboard.infocaptor.com/topic/expand-and-collapse-feature-of-a-particular-row#post-17 Thu, 10 Apr 2008 20:16:51 +0000 admin 17@http://dashboard.infocaptor.com/ <p>We would be interested to know does InfoCaptor support the expand and<br /> collapse feature of a particular row within the table itself. This is<br /> similar to drill down but we want to provide a link on a summary table for a<br /> particular column value with a + sign associated with the field (inside the<br /> bracket). If end user clicks on that link or + sign the row should be<br /> detailed out within the table itself and the + sign gets changed to - sign<br /> after the expansion. Now if the end user clicks the minus sign or the link<br /> again we should roll back to the original table. Lot of sites now-a-days has<br /> got this feature. We are interested to know if InfoCaptor has this<br /> functionality available for drill down.</p> <p>I have seen that InfoCaptor has the drill down capability of the next level<br /> of information is viewed in a different QLet and in a different table.</p> <p>I hope I made my point clear.</p> <p>Also is it possible to set up Tomcat Apache as web browser and deploy<br /> InfoCaptor server version there? </p> http://dashboard.infocaptor.com/topic/quickbooks-dashboard#post-16 Thu, 10 Apr 2008 20:14:27 +0000 admin 16@http://dashboard.infocaptor.com/ <p>Thank you for your interest in Quickbooks dashboard.<br /> The Quickbooks dashboard is not yet available for download. We are deploying to clients on need basis as it is fairly new. As of now we have the Expense, Sales and COGS metrics. We are also working on AR and AP metrics. </p> http://dashboard.infocaptor.com/topic/quickbooks-dashboard#post-15 Thu, 10 Apr 2008 20:13:49 +0000 admin 15@http://dashboard.infocaptor.com/ <p>I saw in your blog post that you can do a dashboard for QuickBooks. Is the software available through the "Download" button on your home page the one to use to get to the QuickBooks dashboard creation? </p> http://dashboard.infocaptor.com/topic/dashboard-autorefresh#post-14 Thu, 10 Apr 2008 20:07:37 +0000 admin 14@http://dashboard.infocaptor.com/ <p>For the refresh piece, can you verify the following properties for both the objects<br /> Edit the chart and look for property 'Include in Autrefresh', it should set to 'Y'</p> <p>similarly check the Qlet property.</p> <p>During autorefresh all the portlets that have 'Include in Autorefresh' as 'Y' will be refreshed except the ones that are meant for drill purpose.<br /> For e.g if you defined a Qlet which has param&lt; , &gt; filter in the where clause will not be refreshed for the obvious reason that it will hinder the autorefresh process by prompting for parameters everytime.</p> <p>The Parent Qlet will be refreshed but not the child qlet.</p> <p>During autorefresh, the parameters are never refreshed unless you manually refresh them.</p> <p>I hope this explains, if not please feel free with any questions. </p> http://dashboard.infocaptor.com/topic/dashboard-autorefresh#post-13 Thu, 10 Apr 2008 20:07:04 +0000 admin 13@http://dashboard.infocaptor.com/ <p>What I observed when I enabled the Auto-refresh feature is that all QLETs and GLETS appear to be updated (re-painted). The information in Process Status and Process Status Chart are updated. However, the data in Task Status and Task Status Chart don't seem to be updated. I should point out that Task Status relies on Process to pass to it the process_id, start_time and end_time to get the correct info from the database. During auto-refresh, the Parameter control are not being changed, that means if the Process (Parameter) SQL is not re-run, the start_time and end_time will not be updated and the Task Status will not get the correct info using start_time and end_time from previous setting. My question is: During Auto-refresh, will all the SQL associated with the Parameter controls be executed? Does the cascading od events (Team to Process) cause any problem?</p> <p>BTW, I created another Dashboad with similar constructs but use drill-down from the Process Status to the Task Status and it works OK. This indicates that I the SQL is OK. Just that I may be misunderstanding the auto-refresh facility. Could you explain to me what goes on during auto-refresh? </p> http://dashboard.infocaptor.com/topic/launch-external-url-not-working#post-12 Thu, 10 Apr 2008 20:04:56 +0000 admin 12@http://dashboard.infocaptor.com/ <p>One question, are you using MySQL as the database? If yes then the problem is related to it.</p> <p>For e.g When we used MySQL to put a link column for <a href="http://www.yahoo.com" rel="nofollow">http://www.yahoo.com</a> then the database wraps the url within a single quote 'http://www.yahoo.com' and this is why the launch url is not activated. If this is the case we will create a workaround and send you a solution </p> http://dashboard.infocaptor.com/topic/launch-external-url-not-working#post-11 Thu, 10 Apr 2008 20:04:07 +0000 admin 11@http://dashboard.infocaptor.com/ <p>I am still having problem getting the URL to work. Do you have any advice for me? It has to be something I've done. I desparately need to invoke external URL since InfoCaptor is a passive tool and I need to carry out some action. The only way is to invoke an existing web-application with the required parameters byinvoking a URL. </p> <pre><code>The SQL copied for the edit window that corresponds to the captured screen is: select t.display_name as task_name, t.id as task_id, IF(t.user_defined_flag = 0, &#39;false&#39;, &#39;true&#39;) as user_defined, IF(t.optional_flag = 0, &#39;false&#39;, &#39;true&#39;) as optional, CONCAT(&#39;http://&#39;, t.system_query) as Link from task t, process p, process_task a where a.process_id = p.id and p.id = param&lt;Process Id, 0&gt; and a.task_id = t.id;</code></pre> http://dashboard.infocaptor.com/topic/multiple-queries-in-one-qlet-query-portlet#post-10 Thu, 10 Apr 2008 20:00:36 +0000 admin 10@http://dashboard.infocaptor.com/ <p>One of the requirements for the dashboard I am building is that I am given a fixed set of SQL statements/stored procedures, in addition to other stuff that I put in the dashboard, that have to be executed and their result displayed. Obviously, one can create a QLET for each of them. But this means that there are many QLETs. Is it possible to have 1 QLET that displays different number of colums depending on what the SQL/stroed procedure returns?<br /> <pre><code>You can do this by just using two Qlets. Create one parent qlet, with unions if using Oracle database then select &#39;Table1&#39; from dual union select &#39;Table2&#39; from dual union select &#39;Table3&#39; from dual I think in MySQL you can just say select &#39;Table1 union select &#39;Table2&#39; union select &#39;Table3&#39; Now this is done in the first Qlet (parent) Next create a child Qlet with following query select * from param&lt;Table Name,x&gt; For the child Qlet, Set the &#39;Run on start&#39; property to &#39;No&#39; Once the parent and child Qlet are done, create a drill from the parent to child. Check the attached pdf tutorial</code></pre> http://dashboard.infocaptor.com/topic/java-script-in-dashboard#post-9 Thu, 10 Apr 2008 19:57:37 +0000 admin 9@http://dashboard.infocaptor.com/ <p>How to use Java script to invoke any external Windows program using Parameter? I imagine it will be similar to invoking the browser. </p> <blockquote><p> Yes, use the same syntax and call the appropriate program file </p></blockquote> http://dashboard.infocaptor.com/topic/call-stored-procedures#post-8 Thu, 10 Apr 2008 19:55:46 +0000 admin 8@http://dashboard.infocaptor.com/ <p>Is is possible to call a stored procedure? How does it determine the number of columns returned? </p> <blockquote><p> This is not available for the Qlet. But we will provide a mechanism where you just enter the stored procedure and then internally it will get the SQL dynamically and execute the SQL </p></blockquote> http://dashboard.infocaptor.com/topic/custom-column-name-description#post-7 Thu, 10 Apr 2008 19:54:02 +0000 admin 7@http://dashboard.infocaptor.com/ <p>Is it possible to change the column description in the QLET? For example, if I specify DATE_FORMAT(start, "%M %e, %Y %T") in the select statement, the description displayed is "DATE_FORMAT(start, "%M %e, %Y %T")' and it does not look that good. </p> <blockquote><p> You can change the column name, right click on any column, Click on the Column Settings Tab, Enter the column name in the 'Display Column name' property </p></blockquote> http://dashboard.infocaptor.com/topic/display-html-page-export#post-6 Thu, 10 Apr 2008 19:52:44 +0000 admin 6@http://dashboard.infocaptor.com/ <p>I was thinking that bring up a browser makes the dashboard look non-integrated. Is it possible to display the html page on the html control within the dashboard? If this is not possible, is it possible to disply a button instead of the URL to invoke the html page? </p> <blockquote><p> Which html page are you refering to? Are you referring to the Export to HTML option? </p></blockquote> http://dashboard.infocaptor.com/topic/dashboard-drill-from-pie-chart#post-5 Thu, 10 Apr 2008 19:50:40 +0000 admin 5@http://dashboard.infocaptor.com/ <p>Is it possible to drill down from a Pie chart? </p> <p>Ans - Not available at this moment, Drilling from pie chart is currently worked upon </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> http://dashboard.infocaptor.com/topic/different-row-color-based-on-colum-value#post-3 Thu, 10 Apr 2008 19:46:56 +0000 admin 3@http://dashboard.infocaptor.com/ <p>I am currently evaluating infocaptor. I've created a dashboard for my application. I have a number of questions:<br /> 1) using Qlets, is it possible to make each row to be displayed in a different color based on the value of a particular column eg, a column of type ENUM? </p> <blockquote><p> Yes, here is an example <a href="http://www.infocaptor.com/user_help/exception_stop_light.htm?MenuState=HE3xVRUERFB" rel="nofollow">http://www.infocaptor.com/user_help/exception_stop_light.htm?MenuState=HE3xVRUERFB</a> </p></blockquote> http://dashboard.infocaptor.com/topic/dashboard-test-release#post-2 Thu, 10 Apr 2008 18:40:59 +0000 admin 2@http://dashboard.infocaptor.com/ <p>You can grab the latest test version at this location. Remember this is a test/beta version so you may install it in a separate directory for testing purpose</p> <p><a href="http://www.infocaptor.com/files/test/infocaptor_setup.exe" rel="nofollow">http://www.infocaptor.com/files/test/infocaptor_setup.exe</a></p> <p>Latest updates<br /> -Export to PDF (full Dashboard)<br /> -Export to HTML (full dashboard image) </p>