http://dashboard.infocaptor.com/ Dashboard Discussion, Support, Examples, Help: Recent Posts en Tue, 16 Mar 2010 22:59:45 +0000 http://dashboard.infocaptor.com/topic/excel-qlet-wizard-create-calculationsdate-filters#post-221 Wed, 10 Mar 2010 14:23:09 +0000 admin 221@http://dashboard.infocaptor.com/ <p>Hi David,<br /> Please download the latest version from our website. This feature was added recently.</p> <p>Thank you </p> 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-219 Tue, 09 Mar 2010 16:08:43 +0000 admin 219@http://dashboard.infocaptor.com/ <p>Hi Jeff,<br /> Multiple selection feature is not available. Although the work around I can think of is to enable date input for the drop down parameter and let the user enter a comma seperated values like 'NY','CA','TX'. In the Qlet query, you can have an in-clause like where state in (G_PARAM&lt;...&gt;) </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-122 Fri, 05 Feb 2010 23:57:59 +0000 mattph 122@http://dashboard.infocaptor.com/ <p>Hi -<br /> We are also looking for good and inexpensive solutions to bring data into Excel. We also deal with lots of data 500k + rows and only looking for a subset.</p> <p>We tested Global Exec Dash for two weeks. OK but expensive. $5k for designer and $2.5k per seat. The designer is no biggie... we typically prepare the data on the db by creating views or reporting tables. But you need it to define what fields are parameters.</p> <p>How does it work? They built a .xla of vb code. IF you want to bring in a sum of a field into ONE cell, your formula =EXQ("R:\Global_EDash\Queries\PSSD.edq|SUM|QtySold",$E$3,$C8,$E$4) where the cell references are the parameters on the sheet. If you want to bring in every record then the formula = =EXD("PSSD.edq","Sheet2","A1","Y","Y","Y",$B$1,$B$2,$B$3).</p> <p>I wish they would bring in every record and then do a sum. Imagine a worksheet with 100 cells referencing sql statements summing data. That's 100 statements hitting server.</p> <p>Any suggestions of other vendors and how they work would be appreciated.</p> <p>Thanks<br /> Matt </p> http://dashboard.infocaptor.com/topic/todays-date-on-my-dashboard#post-121 Fri, 29 Jan 2010 03:24:07 +0000 EllaTherese 121@http://dashboard.infocaptor.com/ <p>Will I EVER get an answer to this post??????????????????????????????????????????? </p> http://dashboard.infocaptor.com/topic/javasqlsqlexception-microsoftodbc-excel-driver#post-117 Mon, 18 Jan 2010 16:58:48 +0000 admin 117@http://dashboard.infocaptor.com/ <p>Hi Hendrik,<br /> Can you send me a screenshot of the error at contact"AT"infocaptor.com. It could be that there is white space in the column name. </p> <p>Also, you can delete any object by just selecting it by clicking on the title name and then clicking on the scissor icon in the tool bar. </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-112 Thu, 07 Jan 2010 16:13:23 +0000 admin 112@http://dashboard.infocaptor.com/ <p>Tom,<br /> Here is the code. You can change the colors in the plot.setSectionPaint(1, new Color(0,102,102)) ... Each Pie section is identified by the number 1, 2, 3.. and Color(R,G,B) defines the color associated with that section</p> <p>//-------------<br /> //import the necessary classes<br /> import org.jfree.chart.JFreeChart;<br /> import org.jfree.chart.plot.PiePlot3D;<br /> import org.jfree.chart.labels.StandardPieSectionLabelGenerator;</p> <p>plot =((PiePlot3D) chart.getPlot());<br /> plot.setForegroundAlpha(0.5f);</p> <p>//chart.setBackgroundPaint(new GradientPaint(0,0,Color.gray.brighter().brighter(),0,displayFrame.getHeight(), Color.LIGHT_GRAY)); </p> <p> float h = displayFrame.getHeight();<br /> float w = displayFrame.getWidth();<br /> GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.white, 0, h, Color.orange);<br /> // plot.setBackgroundPaint(gradientPaint);<br /> chart.getTitle().setPaint(Color.blue);</p> <p> plot.setLabelGenerator(new StandardPieSectionLabelGenerator("{2} {0}={1}"));</p> <p>plot.setSectionPaint(1, new Color(0,102,102));<br /> plot.setSectionPaint(2, new Color(51,0,102));<br /> plot.setSectionPaint(3, new Color(102,0,102));<br /> plot.setSectionPaint(4, new Color(102,0,0));<br /> plot.setSectionPaint(5, new Color(51,51,0));<br /> plot.setSectionPaint(6, new Color(0,51,0));<br /> plot.setSectionPaint(7, new Color(0,102,51)); </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-110 Thu, 07 Jan 2010 01:38:22 +0000 Tom 110@http://dashboard.infocaptor.com/ <p>Thank You this worked </p> http://dashboard.infocaptor.com/topic/decimal-place-in-pie-chart-item-labels#post-109 Wed, 06 Jan 2010 18:57:42 +0000 admin 109@http://dashboard.infocaptor.com/ <p>Tom,<br /> Please try the below code in the java script. NOTE: There are two new import statements import java.text.numberformat and ..decimalformat. </p> <p>//-----------<br /> //import the necessary classes<br /> import org.jfree.chart.JFreeChart;<br /> import org.jfree.chart.plot.PiePlot;<br /> import org.jfree.chart.labels.StandardPieSectionLabelGenerator;<br /> import java.text.NumberFormat;<br /> import java.text.DecimalFormat;</p> <p>plot =((PiePlot) chart.getPlot());<br /> plot.setForegroundAlpha(0.5f);</p> <p>//chart.setBackgroundPaint(new GradientPaint(0,0,Color.gray.brighter().brighter(),0,displayFrame.getHeight(), Color.LIGHT_GRAY)); </p> <p> float h = displayFrame.getHeight();<br /> float w = displayFrame.getWidth();<br /> GradientPaint gradientPaint = new GradientPaint(0.0F, 10.0F, Color.white, 0, h, Color.orange);<br /> // plot.setBackgroundPaint(gradientPaint);<br /> chart.getTitle().setPaint(Color.blue);</p> <p> plot.setLabelGenerator(</p> <p>new StandardPieSectionLabelGenerator(<br /> "{0}={2}",<br /> new DecimalFormat("#,##0"),<br /> new DecimalFormat("0.0%"))<br /> );</p> <p>//----------- </p> http://dashboard.infocaptor.com/topic/todays-date-on-my-dashboard-1#post-108 Wed, 06 Jan 2010 18:36:19 +0000 admin 108@http://dashboard.infocaptor.com/ <p>Hi, Can you please send a screenshot at contact"AT" infocaptor.com </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/decimal-place-in-pie-chart-item-labels#post-106 Mon, 04 Jan 2010 04:40:39 +0000 Tom 106@http://dashboard.infocaptor.com/ <p>Additionally I am using the following code:</p> <p>plot.setLabelGenerator(new StandardPieSectionLabelGenerator("{2}{0}"));</p> <p>I believe there is additional code that can be appended to the above 'new DecimalFormat("0.00%")) but this doesn't seem to work. </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#post-102 Tue, 22 Dec 2009 02:10:39 +0000 EllaTherese 102@http://dashboard.infocaptor.com/ <p>I have no tool bar and no Tree icon either. I have several icons across my screen on top, for my email, my address book, my favorites, etc., but no tool bar, what do you suggest I do? </p> http://dashboard.infocaptor.com/topic/todays-date-on-my-dashboard#post-101 Mon, 21 Dec 2009 19:09:19 +0000 admin 101@http://dashboard.infocaptor.com/ <p>Please click on the Tree icon on the tool bar. You should see all the portlets in the tree list. Click on the date Qlet. Check the settings and switch back to the dashboard mode </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/draw-shapes-in-line-chart-issue#post-98 Mon, 12 Oct 2009 19:33:50 +0000 admin 98@http://dashboard.infocaptor.com/ <p>Hi Tom,<br /> Whatever you do through the chart properties is temporary and valid for the session only.</p> <p>Please try updating the dynamic java code using the script provided in this article</p> <p><a href="http://www.infocaptor.com/dashboard/add-threshold-line-in-a-line-chart-line-shapes-line-customizations-jfreechart" rel="nofollow">http://www.infocaptor.com/dashboard/add-threshold-line-in-a-line-chart-line-shapes-line-customizations-jfreechart</a> </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-96 Fri, 11 Sep 2009 16:20:57 +0000 admin 96@http://dashboard.infocaptor.com/ <p>Hi Malabika,<br /> Can you use MS Access as an alternate database to Excel? With Excel you will face the limitation of locking.</p> <p>Thanks<br /> Nilesh<br /> <a href="http://www.infocaptor.com" rel="nofollow">http://www.infocaptor.com</a> -- Use Dashboards - Get Clarity </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-92 Tue, 18 Aug 2009 18:24:52 +0000 joao.junior 92@http://dashboard.infocaptor.com/ <p>and how i can do it? </p> http://dashboard.infocaptor.com/topic/excel-to-flash-files#post-91 Tue, 18 Aug 2009 13:10:02 +0000 admin 91@http://dashboard.infocaptor.com/ <p>InfoCaptor does not produce flash files. </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/chart-to-report#post-88 Sun, 16 Aug 2009 23:27:02 +0000 admin 88@http://dashboard.infocaptor.com/ <p>yes it is possible to drill into another chart </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/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/changing-pie-chart-to-bar-chart#post-85 Sun, 26 Jul 2009 09:33:35 +0000 Earle Taylor 85@http://dashboard.infocaptor.com/ <p>Hi There</p> <p>I am brand new to this trial software having just registered for the trial version. Where and how do I start to construct/modify a pie chart or bar chart. Your Help, please - 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/connecting-using-an-evaluation-version#post-83 Thu, 16 Jul 2009 17:55:52 +0000 admin 83@http://dashboard.infocaptor.com/ <p>Kelly,</p> <p> You can use InfoCaptor to create dashboards out of Excel, Access or any SQL database. If you just intend to use it for Excel you can still use only that.</p> <p>Let me know if more questions</p> <p>---</p> <p>On Wed, Jul 8, 2009 at 11:36 AM, &lt;Kelly.Thomas.....&gt; wrote:</p> <p>Seems to be working now Nilesh – thanks for getting back to me. Will undoubtedly purchase the product if it meets our needs which I think it will. My understanding is that we can take existing Excel data only and we don’t need SQL capability or am I mistaken? Ideally I would like to take existing excel spreadsheet data and use it to make concise dashboards, pie charts etc.</p> <p>Thanks for your help! </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>