http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help: Recent Topics en Wed, 17 Mar 2010 20:29:04 +0000 http://dashboard.infocaptor.com/topic/excel-qlet-wizard-create-calculationsdate-filters#post-220 Wed, 10 Mar 2010 12:24:15 +0000 David Baines 220@http://dashboard.infocaptor.com/ <p>Using Version 3.4 Infocaptor to set up Dashboard based upon Excel worksheet data file.<br /> Problem:- The Qlet creates a table in the dashboard but right mouse click does not reveal the menu to create calculations, Data filter or Add Year,etc. The only option is to create a parameter. </p> http://dashboard.infocaptor.com/topic/parameter-question#post-217 Mon, 08 Mar 2010 22:55:19 +0000 dsoftware 217@http://dashboard.infocaptor.com/ <p>Hello,</p> <p>Newbie question: is there a way to allow users to select or enter multiple values for a parameter. Say we want to let the user filter by state - can they choose multiple state codes like NY, CA, TX? Thanks in advance.</p> <p>- Jeff </p> http://dashboard.infocaptor.com/topic/pie-chart-rounding#post-124 Mon, 15 Feb 2010 06:00:07 +0000 Tom 124@http://dashboard.infocaptor.com/ <p>Hi,</p> <p>I am having issues with Pie chart rounding. In some instances the total percentage adds to 99 or 101.</p> <p>I have set the following code<br /> plot.setLabelGenerator(new StandardPieSectionLabelGenerator("{0}={2}",new DecimalFormat("#,##0"),new DecimalFormat("0.00%"))</p> <p>I am connecting to an excel worksheet via ODBC</p> <p>Any suggestions?</p> <p>Thanks </p> http://dashboard.infocaptor.com/topic/dashboard-software#post-84 Tue, 21 Jul 2009 11:01:36 +0000 m.r. 84@http://dashboard.infocaptor.com/ <p>hi @ all,</p> <p>i even found infocaptor, so i'm very new to this one - but what i read so far was very interesting.<br /> currently i design a dashboard with microstrategy 9 - however, i'm always in search of new software to create dashboards - open source in particular.</p> <p>anybody who gained experience with both of these software moduls or with other software? if so, please tell me what your experience where like and what you prefer respectively.<br /> i would appreciate if anybody could inform me, if infocapter is useable to visualise huge data volumes - or if someone could suggest any other 'dashboard-software' or dashboard fora.</p> <p>(by the way i'm working with sybase iq database and i would like to create a dashboard with several sites / panels each panel displays several reports - grids and diagramms respectively)</p> <p>thanks a lot<br /> best regards</p> <p>m.r. </p> http://dashboard.infocaptor.com/topic/todays-date-on-my-dashboard#post-99 Fri, 18 Dec 2009 01:15:17 +0000 EllaTherese 99@http://dashboard.infocaptor.com/ <p>Up until about a week ago I always had the day's date in the lower corner of my dashboard and it was an easy way for me to depend on it and stay informed. Then suddenly it disappeared and never reappeared. I have no clue as to what happened.<br /> Can you give me any help to reinstate the date on my dashboard? </p> http://dashboard.infocaptor.com/topic/javasqlsqlexception-microsoftodbc-excel-driver#post-116 Mon, 18 Jan 2010 09:05:37 +0000 Hendrik 116@http://dashboard.infocaptor.com/ <p>1) Using Excel, managed to create a "table" in a dashboard, and data is showing. When I right-click and select "create Chart" from the table, I get the following error:<br /> java.sql.SQLException: [Microsoft][ODBC Excel Driver] Syntax error (missing operator) in query expression 'Credit Class'.</p> <p>2) It seems there is no way to delete / remove a table/chart from a dashboard? Looks like the only way is to exit without saving and start over. </p> http://dashboard.infocaptor.com/topic/error#post-114 Thu, 14 Jan 2010 10:33:01 +0000 swimsky2004 114@http://dashboard.infocaptor.com/ <p>hi,<br /> how can attach my xl file to explain the error message.iam usnig the evaluation version of excel dashboard.<br /> swimsky </p> http://dashboard.infocaptor.com/topic/setting-custom-colour-for-each-section-in-a-3d-pie-chart#post-111 Thu, 07 Jan 2010 01:40:38 +0000 Tom 111@http://dashboard.infocaptor.com/ <p>Hi,</p> <p>I would like to set the color of each section of a pie chart and not use the default as provided by the program. Can you please advise the code required to achieve this?<br /> Many Thanks </p> http://dashboard.infocaptor.com/topic/decimal-place-in-pie-chart-item-labels#post-105 Mon, 04 Jan 2010 04:33:28 +0000 Tom 105@http://dashboard.infocaptor.com/ <p>Hi I am displaying percentages in item lables of a PIE chart and it is rounding up. I actually want to be able to display the item lable percentage in 2 decimal places. Can you please advise how to do this? Many Thanks </p> http://dashboard.infocaptor.com/topic/todays-date-on-my-dashboard-1#post-107 Tue, 05 Jan 2010 05:45:42 +0000 EllaTherese 107@http://dashboard.infocaptor.com/ <p>I posted this subject before and received one reply, however the reply did not help. I answered and that was 2 weeks ago and I have not received another reply. I would like to get the date back onto my dashboard from where it has disappeared - I was told about the tree icon and to go click there etc. I do not have a tree icon on my tool bar, so what am I to do? Could you kindly give me an answer???????????<br /> Thank you very very much.<br /> Ella Ellington </p> http://dashboard.infocaptor.com/topic/draw-shapes-in-line-chart-issue#post-97 Mon, 12 Oct 2009 02:13:47 +0000 Tom 97@http://dashboard.infocaptor.com/ <p>Hi it seems that the draw shapes tick box does not remain persistent when checked. I.E click on line graph, right click on properties, select Plot &gt; Appearance and check 'Draw Shapes'. This remains persistent for current session, however when closing and re-opening the dashboard this check box reverts back to default. Is this a bug in 3.4 or better still can I do this via Dynamic Java Code (please provide code). Thanks in advance. </p> http://dashboard.infocaptor.com/topic/excel-refresh#post-95 Fri, 11 Sep 2009 04:12:51 +0000 malabika 95@http://dashboard.infocaptor.com/ <p>The excel sheet gets locked when infocaptor is using the same in autorefresh or it is connected. If we want to refresh the excel sheet at an interval of 15 mins , how can we do this without disconnecting the same. </p> http://dashboard.infocaptor.com/topic/chart-to-report#post-86 Fri, 14 Aug 2009 13:08:38 +0000 joao.junior 86@http://dashboard.infocaptor.com/ <p>is it possible show the lines(report) from a chart?</p> <p>i have a bar Chart and i want to click and show the lines using the same query.<br /> (drill into)</p> <p>thanks </p> http://dashboard.infocaptor.com/topic/excel-to-flash-files#post-90 Tue, 18 Aug 2009 13:09:42 +0000 admin 90@http://dashboard.infocaptor.com/ <p>can your software (any version) produce a free-standing Flash file from Excel, please? </p> http://dashboard.infocaptor.com/topic/thermometer-chart-change-mercury-color#post-87 Fri, 14 Aug 2009 13:29:38 +0000 joao.junior 87@http://dashboard.infocaptor.com/ <p>i am not able to change the mercury color</p> <p>The code: </p> <p>import org.jfree.chart.plot.ThermometerPlot;<br /> import org.jfree.chart.JFreeChart;<br /> import javax.imageio.ImageIO;<br /> import java.awt.Toolkit;<br /> import java.awt.Color;<br /> import java.awt.image.BufferedImage;<br /> import java.awt.event.ActionListener;<br /> import java.awt.event.ActionEvent;<br /> import java.awt.event.KeyEvent;<br /> import java.io.File;<br /> import java.io.IOException;<br /> import java.net.URL;</p> <p>ThermometerPlot plot = (ThermometerPlot)chart.getPlot();</p> <p>plot.setThermometerStroke(new BasicStroke(2.0f));<br /> plot.setThermometerPaint(Color.lightGray);</p> <p>float h = displayFrame.getHeight();<br /> float w = displayFrame.getWidth();</p> <p>//***************************************************<br /> plot.setMercuryPaint(Color.red); // Does not works<br /> //***************************************************</p> <p>plot.setValuePaint(Color.black);<br /> plot.setThermometerPaint(Color.BLACK)<br /> plot.setBackgroundPaint(new Color(252, 96, 119)); </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/connecting-using-an-evaluation-version#post-81 Wed, 08 Jul 2009 14:17:01 +0000 kellythomas 81@http://dashboard.infocaptor.com/ <p>I cannot connect without registered my evaluation mode copy, however, it is not allowing me to do so without paying for the full product. Any suggestions? </p> http://dashboard.infocaptor.com/topic/connection-to-named-instance#post-79 Tue, 30 Jun 2009 23:24:00 +0000 philcart 79@http://dashboard.infocaptor.com/ <p>How do I connect to a named instance, rather than a default instance of SQL Server?</p> <p>Thanks<br /> Phil </p> http://dashboard.infocaptor.com/topic/connection-to-informix-10#post-52 Thu, 05 Feb 2009 05:27:15 +0000 Rusty_hook 52@http://dashboard.infocaptor.com/ <p>Hi,<br /> I am getting an error when trying to connect to an informix database.<br /> the error i get is ..<br /> Error in registering driver..... com.informix.jdbc.IfxDriver</p> <p>I have no problem connecting to an oracle database. I have checked the connection from my machine to the informix database and all is fine. I used ilogin (informix connection test application) to ensure that I can connect to the database from my machine.</p> <p>Can anyone assist?<br /> thanx </p> http://dashboard.infocaptor.com/topic/bar-chart#post-75 Wed, 24 Jun 2009 12:04:24 +0000 Snigdha 75@http://dashboard.infocaptor.com/ <p>I want to display the values/Percentage in a bar chart based on Period/Collector.How do i do that? </p> http://dashboard.infocaptor.com/topic/best-way-to-show-on-target-status#post-69 Wed, 27 May 2009 08:32:46 +0000 leanneyx 69@http://dashboard.infocaptor.com/ <p>I want to use meters to show current on target status, is there any way to do this ? If not whats the best way to show target status? </p> <p>Thanks </p> http://dashboard.infocaptor.com/topic/publishing-on-pentaho-bi-server#post-70 Wed, 03 Jun 2009 12:54:54 +0000 ilkem 70@http://dashboard.infocaptor.com/ <p>I have created a sample dashboard and want to publish it on the Pentaho BI-Server. Can anyone help me? </p> http://dashboard.infocaptor.com/topic/unicode-support#post-68 Thu, 21 May 2009 06:55:49 +0000 rashinrezaei 68@http://dashboard.infocaptor.com/ <p>i have problem with my language </p> http://dashboard.infocaptor.com/topic/connect-to-odbc#post-66 Mon, 04 May 2009 19:52:55 +0000 mbusowski 66@http://dashboard.infocaptor.com/ <p>I am unable to connect to a progress database. I currently us progress sql92 version 91. to connect to the db for crystal reports. </p> http://dashboard.infocaptor.com/topic/transaction-month-is-not-coming-in-order-in-chart#post-65 Mon, 04 May 2009 12:19:19 +0000 S Uma 65@http://dashboard.infocaptor.com/ <p>In chart, I am getting the months in alphabetical order whereas the same is required as per calendar month.</p> <p>I have written a query as under :<br /> Select to_char(RA_CUSTOMER_TRX_ALL.trx_date, 'MON') invoice_month,<br /> SUM RA_CUSTOMER_TRX_LINES_ALL.quantity_invoiced*RA_CUSTOMER_TRX_LINES_ALL.unit_selling_price) invoice_amount<br /> FROM RA_CUSTOMER_TRX_ALL<br /> FULL OUTER JOIN RA_CUSTOMER_TRX_LINES_ALL<br /> ON RA_CUSTOMER_TRX_ALL.customer_trx_id=RA_CUSTOMER_TRX_LINES_ALL.customer_trx_id<br /> WHERE RA_CUSTOMER_TRX_ALL.trx_date BETWEEN '01-APR-2008' AND '31-MAR-2009'<br /> GROUP BY to_char(RA_CUSTOMER_TRX_ALL.trx_date, 'MON')</p> <p>Please advise </p> http://dashboard.infocaptor.com/topic/volume-of-data-that-could-be-handled-by-infocaptor#post-62 Tue, 28 Apr 2009 06:50:58 +0000 S Uma 62@http://dashboard.infocaptor.com/ <p>As per the information provided in your website, Infocaptor suits for small &#38; medium size business </p> <p>We are using 'oracle' ERP and is there any restriction of volume that could be handled by this dashboard? </p> http://dashboard.infocaptor.com/topic/count-unique-values#post-61 Tue, 28 Apr 2009 06:24:12 +0000 S Uma 61@http://dashboard.infocaptor.com/ <p>What is the sql statement to be used for counting unique values in excel </p> http://dashboard.infocaptor.com/topic/software-dashboard-feedback#post-60 Thu, 26 Mar 2009 18:17:57 +0000 hanssassenburg 60@http://dashboard.infocaptor.com/ <p>Hi,</p> <p>I developed a dashboard/cockpit for software projects with waht I consider best practice Key Performance Indicators. I would appreciate some feedback of others. Free download at: <a href="http://www.se-cure.ch/Downloads.html." rel="nofollow">www.se-cure.ch/Downloads.html.</a></p> <p>Thanks!</p> <p>Hans </p> http://dashboard.infocaptor.com/topic/feedback-requested#post-59 Thu, 26 Mar 2009 18:15:44 +0000 hanssassenburg 59@http://dashboard.infocaptor.com/ <p>Hi,</p> <p>I developed a dashboard/cockpit for software projects with waht I consider best practice Key Performance Indicators. I would appreciate some feedback of others. Free download at: <a href="http://www.se-cure.ch/Downloads.html." rel="nofollow">www.se-cure.ch/Downloads.html.</a></p> <p>Thanks!</p> <p>Hans </p> http://dashboard.infocaptor.com/topic/dashboard-date-in-oracle-where-clause#post-56 Thu, 12 Mar 2009 10:50:02 +0000 semma 56@http://dashboard.infocaptor.com/ <p>Hello,<br /> I am using your dashboard date picker, but it doesn't appear to be giving expected results in my where clause in Oracle. Here's my where clause:</p> <p>where<br /> invoice_date between to_date(('G_PARAM&lt;p34:Display&gt;'),'dd:mon:yyyy') and<br /> to_date(to_char('G_PARAM&lt;p63:Display&gt;'),'dd:mon:yyyy')<br /> group by country_desc order by amount desc </p>