Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
New Charts : Two new Chart Types are introduced in Aqua Data Studio Version 10.0 - 3D Line Chart and the Ichimoku Cloud Chart
| 3D Line Chart | 3D Line Chart | Cloud Chart | Cloud Chart |
3D Line Chart - A Line Chart displayed with markers to highlight individual data values in 3 Dimensions. Categories are usually presented along the vertical axis, and values on the horizontal axis. A 3D Line Chart is often used to visualize a trend in data over intervals of time.
Wikipedia : http://en.wikipedia.org/wiki/Line-chart
Ichimoku Cloud Chart - A multi-faceted indicator designed to give trend direction, support/resistance levels, and entry/exit points of varying strengths for Stocks. This is a technical analysis method that builds on Candlestick charting to improve the accuracy of forecasted price moves.
Wikipedia : http://en.wikipedia.org/wiki/Ichimoku-cloud-chart
New charting tools have been added to include more features theat developers and analysts need. You now have more control while manipulating the visualization of data including mixing Multi Series Charts with regular Charts (Candlestick + Area Charts etc). Just like ADS 9.0, all options are scriptable and include support for pivot charts.
Mixing multi-series charts with regular charts
Charts in Aqua Data Studio v10 now have the ability to Mix multi-series charts with regular charts (e.g. Candlestick + Line chart, HLC + Line Chart, Bubble + Area Chart, etc.)
| Candlestick + line | High-low + line | Bubble + area |
Labels in Pie Charts are enhanced to minimize overlap
A new enhancement in v10 minimizes overlap when displaying 2 series in Pie Charts. The labels from the second chart should no longer overlap the first chart.
| Pie Chart Labels |
Offline Software Renderer for Open APIs
Typically, charts are rendered with the video card. Some lower-end video cards do not have sufficient hardware capabilities for rendering Aqua Data Studio charts. This is often the case for servers that are intended to work via remote connections and therefore not equipped with powerful video cards. The newly implemented Software Rendering in Aqua Data Studio v.10 addresses this issue. Software Rendered charts can be displayed (at the cost of lower image quality) on all machines, regardless of the quality of the installed video cards.
The option can be set at the File –> Options –> General –> Chart dialog.
| Offline Software Renderer Options |
Quick Excel Functionality
Grid and Pivot Grid results in Aqua Data Studio v.10 can be quickly opened with Excel or Emailed as an Excel attachment by clicking on the “Quick Excel” button in the upper-left corner of the “Grid” pane.
| View as Spreadsheet Pivot Grid |
Series Functions on Range of values
With v10 a new option to add the ranges is possible - "AddRange(1, 2, 10, 50)" to add the values in rows 10 to 50 from series 1 & 2. The rest of the values would be null & un-plotted. In version 9.0, series functions only operated on an entire series, e.g. the function "Add(1, 2)" will add all values in series 1 to all values in series 2.
| AddRange |
AddRange |
AxisRenderer
This feature in the Chart Options (AxisRenderer - Add ShowVerticalGridLines & ShowHorizontalGridLines), allows displaying and hiding horizontal or vertical grid lines to the chart axes.
| Show horizontal and vertical grid lines |
Show vertical grid lines |
Show horizontal grid lines |
Hide horizontal and vertical grid lines |
FillGrid Support for Charts and Open APIs
Version 10.0 supports chart title positions, grid-lines drawn at each value, centerable legend & hidable legend box. With the addition of FillGrid, whhen FillGrid is true (the default), the grid renders like normal. When FillGrid is false, it hides the filled alternating colors and leaves the grid lines in place.
| FillGrid true | FillGrid false |
Chart Opacity
ADS v10 now allows setting the opacity of chart objects.
| Opacity = 0.25 | Opacity = 0.50 | Opacity = 0.75 | Opacity = 1 |
Tooltip for multi-series charts(bubble, HLC, Candlestick)
For multi-series charts (Bubble, HLC, Candlestick), when you hover the mouse over the charts, the Tooltip now displays all series values by default.
| Tooltip for Series Values |
Chart option for Tick Marks
For all chart types, you can display or hide the tick marks. To make chart data easier to read, you can also make adjustments to the way that chart ticks are displayed for both the value axis and category axis.
| Enable Tick Mark | Disable Tick Mark |
Grid Line Width
A new option in version 10.0 allows you to set Grid Line Width of the axes.
| Grid Line Width=1 | Grid Line Width=5 |
Chart Title Position
Aqua Data Studio 10.0 has a new option and API in Chart to set the position of the Chart Title. This new option will set chart title position property to Top Left/Center/Right, and Bottom Left/Center/Right. These settings will move the Legend accordingly if the Chart Title & Legend are placed in the same corner.
Legend Position
In addition to the different Legend positions already available, Aqua Data Studio 10.0 has added new options and API in Chart to set the Chart Legend position property to Top Center, Bottom Center, Left Center and Right Center.
"Legend" text header is removed
For Aqua Data Studio 10.0 the "Legend" text header for grid and pivot charts is removed. This is to keep in par with most chart packages which do not have it plotted.
Enhance chart font rendering
I think we should still use a single font for the chart, but allow the user to set the scaling for each component (Legend, Value Axis, Category Axis, Titles, ...). Something like setTitleFontSize(float size) might work well. The user could select Arial-10-BOLD, and then could setTitleFontSize(20), which would calculate the appropriate scalar (20 / 10 = 2), then apply that scalar to the Title.
Chart API enhancements : Allow null values in the model to appear as gaps in the chart instead of treating nulls at zeros.