#AQUA DATA STUDIO 10 HOW TO#

Make Server Panel visible Edit tables and columns comment 1 ), or clicking Window -> Show/Hide Server Panel in the toolbar (Fig. In both options we will use the Server Panel, so open it by clicking the Servers tab (Fig.

#AQUA DATA STUDIO 10 HOW TO#

Wraps line at a user-specified value and then displays data in the next row.This tutorial will show you how to view and edit table and column comments using Aqua Data Studio. Insert user-specified characters at the end of copied data. Inserts user-specified characters at the start of copied data. In Vertical data order, displays columns as rows and rows as columns. Retains the data presentation for horizontal data order. The following table lists the options in the Copy to Clipboard dialog. See Attachment.Ĭopy As is a right-click option and opens the Copy to Clipboard dialog. See Attachment.Ĭopy with Headers and Row Count (Align Columns)Ĭopies column headers, row counts, and data and retains the column alignment in the destination file. See Attachment.Ĭopies row counts and data and retains the column alignment in the destination file. This option copies the headers, along with the data.Ĭopies the row count, along with the data.Ĭopies column headers and row counts, along with data.Ĭopies column headers and data and retains the column alignment in the destination file. The following table lists its additional options.īy default, Visual Analytics copies data without the column headers. Shows additional options when you point to this option.Ĭopy Special is a right-click option and shows additional options when you point to this option. The following table lists the right-click options in the View Data Window. Additional options appear on clicking the arrow that is available next to the icon.Īggregate Functions, Quick Filtering, or Multi-Column sorting performed in the View Data window do not affect Visual Analytics Charts or Tables. The icons appearing on the headers are a sign of successful sorting.Īnother option that is available in the View Data window is Preview in Excel ( ) that exports the data to an Excel spreadsheet. For example, to sort Territory in descending order and Customer Name in ascending order, click the Territory header and then press Ctrl, and then double-click Customer Name header. Multi-Column sorting with ascending or descending is supported. Search by using wildcards and regular expressions and match found options Perform a case sensitive or case insensitive search By using the Search box, you can define a scope to: Quick filters offer the advantage of filtering the data displayed in the View Data window, based on the user-specific value, and finding information quickly. Aggregate Functions allows calculation of Count, Count Numbers, Sum, Min, Max, Average, and Standard Deviation functions on the rows that you select in the View Data window. The View Data window supports quick filtering, aggregate functions, and multicolumn sorting. In addition, we have highlighted ColonialVoice, Distinguish, and SuperiorCard data points in the chart view, therefore, Visual Analytics shows the underlying data only for these data points. In the following example, after clearing the check box, the underlying data for Card Type and Profit is displayed. The Underlying tab shows the disaggregated values of the data points across all dimensions and measures.įor more information on how you can select multiple data points, see Highlight Actions. The Summary tab shows the aggregated values of each data point. The following screenshot contains the summarized and underlying data of multiple data points, such as ColonialVoice, Distinguish, SuperiorCard. This window contains the summarized and underlying data of the selected data points. When you hover your mouse in the chart view, or in the Color or Shape legend, Visual Analytics opens the View Data after you click the icon on the tooltip. In the Data Pane, when you click, Visual Analytics opens the View Data window that contains the underlying data of your dataset. Right-Click Options in View Data Window.The View Data window displays summarized or underlying data of a dataset or data of a view.

Aqua data studio 10