5.10.2 Working with Enhanced Charts

Aqua Data Studio's Enhanced Charts include OHLC (open-high-low-close) charts, Candlestick charts, Bubble charts, Stacked charts, Scatter charts and Map charts. Chart Functions include Addition, Subtraction, Scalar, Power, Log, Linear Regression and Moving Average. Column Shape Type includes support for Cylinder, Cone & Pyramid versions of all Column & Bar charts are available.

3D High Low Close	3D Candlestick	Moving Average + Stack	Functions

Cone	Pyramid	Cylinder	Exploded Pie

Working with Candlestick Charts

Candlestick charts can be effectively used in Aqua Data Studio to plot data-driven charts.

Candlestick Chart

1. Candlesticks are used to show stock price
2. Each candlestick shows the stock's high, low, opening and closing prices. The wick shows the stock's high and low prices
3. The body of a candlestick shows the stock's opening and closing prices
4. A day is an up day if the closing price is greater than the opening price
5. The body color is used to flag if it is an up day (GREEN) or down day (RED)

Working with Open-high-low-close Chart

Open-high-close Chart

1. In a high-low-close plot the vertical line represents the high and low values over one unit of time.
2. The close value is represented by a "tick" to the right. The open value, if present, is represented by a tick to the left.
3. If today's close is higher than yesterday's close - the bar is colored green/blue.
4. If today's close is lower than yesterday's close - the bar is colored red.
5. If today's close is equal to yesterday's close - the bar is colored the same as yesterday.

Working with Bubble Charts

Bubble Chart

A bubble chart is a two-dimensional scatterplot where a third variable is represented by the size of the points.

1. In a high-low-close plot the vertical line represents the high and low values over one unit of time.
2. The close value is represented by a "tick" to the right. The open value, if present, is represented by a tick to the left.
3. If today's close is higher than yesterday's close - the bar is colored green/blue.
4. If today's close is lower than yesterday's close - the bar is colored red.
5. If today's close is equal to yesterday's close - the bar is colored the same as yesterday.

 Working with Stacked Area Charts

Stacked Area Chart

A stacked area chart is used to map multiple series over different categories like time.

1. The stacked area displays trends of each category so that the areas are stacked, but each series does not overlap the preceding series.
2. Stacked area can chart multiple data sets as an area.

Working with Scatter Line Charts

Scatter Line Chart

The scatter line chart in Aqua Data Studio allows you to create a chart with two value axes to show one set of numerical data along a horizontal axis and another set of numerical values along a vertical axis.

1. The scatter line chart displays points at the intersection of x and y numerical values, making these values into single data points.
2. Scatter line charts can plot numerical values like day or hour along the horizontal axis.

Working with Stacked Bar Chart

Stacked bar Chart

The Stacked Bar chart in Aqua Data Studio allows you to create a chart displaying the results of multiple queries stacked on top of each other vertically.

1. The Stacked Bar consists of data points represented by segments of each bar, as well as total value represented by data points of each Series selected in the Chart options.
2. Each series is denoted by a different color and the entire bar is the total for the data series

Working with Scatter Charts

Scatter Chart

The scatter chart in Aqua Data Studio allows you to create a chart showing one piece of information, such as stock value along the x-axis and another piece of information such as Company, along the y-axis. A scatter chart is used to map correlation between sets of numbers.

1. The scatter graph consists of plotted points "scattered" around an X-Y grid. The pattern may reveal a relationship between the two variables measured by the X and Y axes. In 2D scatter graphs, you can illustrate trends in the plotted points by adding a "Moving Average".
2. Scatter graphs can chart multiple data sets, each represented by a different symbol, each having any number of data points.

Working with Map Charts

Map Chart

The map chart in Aqua Data Studio presents a flat world map with country outlines. Chart Options for Map include the ability to show country details (population, currency, and area in square units) and a low resolution satellite view background image. To use the Map Chart Type, ensure that your query contains a column with country values. We support country names & country codes as specified in the ISO2, ISO3, GMI & FIPS specifications. For more on the country codes and names used in Aqua Data Studio, see the country codes list.

1. Once you have a resultset with country values, go to your charts region and choose your Chart Type as Map, choose one category field (containing country name) and one series field (containing the data value). For each distinct country in the resultset, the series values is summed.
2. The map is then color coded to highlight only the countries found in the resultset. As you hover your mouse over a highlighted country, a tooltip is displayed with the summed value for that country.

For example, if your resultset contains these rows:

then your Map will have 2 highlighted countries and the values displayed for France and United States will be 600 and 900, respectively.

You can also specify your own color coding scheme for map highlighting. To do this, go to the Chart Options menu. For the Map Ranges parameter, specify "0,700,1000" then 2 ranges are created:

[0, 700) ==> from 0 inclusive to 700 exclusive
[700, 1000] ==> from 700 inclusive to 1000 inclusive

You can then specify the highlight color for each range by filling in the Map Range Colors attribute. For our example, "green,blue". So in our map, France will be highlighted in green and United States in blue.