Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

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.

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

3D High Low Close3D CandlestickMoving Average + StackFunctions

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

Image RemovedImage Added

ConePyramidCylinderExploded Pie

...

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

Candlestick ChartImage RemovedImage Added

Candlestick Chart

...

Working with Open-high-low-close Chart

Image RemovedImage Added

Open-high-close Chart

...

Working with Bubble Charts

Image RemovedImage Added

Bubble Chart

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

...

 Working with Stacked Area Charts

Stacked Area ChartImage RemovedImage Added

Stacked Area Chart

...

Working with Scatter Line Charts

Scatter Line ChartImage RemovedImage Added

Scatter Line Chart

...

Working with Stacked Bar Chart

Stacked bar ChartImage RemovedImage Added

Stacked bar Chart

...

Working with Scatter Charts

Scatter ChartImage RemovedImage Added

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

Image RemovedImage Added

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 thecountry codes list.

  1. Once you have a result-set 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 result-set, the series values is summed.
  2. The map is then color-coded to highlight only the countries found in the result-set. As you hover your mouse over a highlighted country, a tooltip is displayed with the summed value for that country.

...

You can also specify your own color coding scheme for a 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:

...