http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help: Recent Topics en Sun, 23 Nov 2008 11:34:40 +0000 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-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-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-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-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-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-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-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>