Page History
...
Download and place this stock_data.xlsx file into the folder you used for the Visual Analytics Example registered server from the Building Views page.
Within Aqua Data Studio expand the Schema Browser node for Visual Analytics Example. Expand the stock_data node and its Tables node.
...
Click the [Visual Analytics] button in the Grid Results toolbar.
Once Visual Analytics launches, do the following:
...
2. Drag the stock_close Measure into the Rows Deck, right click it and select [Measure Type (Last)].
| Info |
|---|
First and Last are based on the data source sort order. We automatically sort the data source using the innermost date field that is in Rows/Columns. Thus the value of First and Last changes depending on what is the innermost date field in Rows/Columns. |
...
8. Drag stock_symbol to Filters and uncheck [All] in the resulting stock_symbol Filter Deck, then check only AAPL.
The resulting Candlestick Chart automatically colors each candle body green for a stock closing higher than it opened, and red for a stock closing lower than it opened. The candle's wick indicates the full range of prices it achieved in a time period.
To get a more focused view on the content of Price Charts, it is a good idea to right click on the axis and select [Edit Axis...] then uncheck [Include Zero].
| Info |
|---|
It's possible to use the [Analysis Menu] to display Trend Lines within Price Charts. See Displaying Trend Lines for more information. |
Create a High, Low, Close Price Chart
...
6. Drag stock_symbol to Filters and uncheck [All] in the resulting stock_symbol Filter Deck, then check only AAPL.
The resulting High Low Close Chart displays a vertical bar for the range of prices it achieved within a particular time span and a horizontal tick indicating what its close price was at the end of that time span.
...
- You can sort data by using various sort options available in the chart view or the Advanced dialog. For more information, see Sorting.
- You can use highlight actions to focus on selected candlestick. Visual Analytics makes the highlighted candlesticks and its data labels prominent while dimming others in the view. For more information, see Highlight Actions.
- You can filter records directly from the chart view without manually adding any fields to the Filters Deck. For more information, see Filters.
- You can export worksheets containing visualization to Image, HTML, and PDF formats. For more information, see Export Visualizations.