![aqua data studio code folding aqua data studio code folding](https://www.aquafold.com/wp-content/themes/Divi-Child/assets/diagrams-img/screenshot_javascript_ide_open_api_version_control_integration.png)
SQL EditorĬode folding, code collapse/roll-up, syntax coloring, hot key assignments, configurable auto replace of objects, bind variable support, selective statement execution. Code TemplatesĮliminate the need to memorize and type SQL syntax. You can't apply metric filters to pivot tables doing so displays an error message.Construct even the most complicated SQL statements with point-and-click ease.Pivot tables do not paginate, as do standard tables.Pivot tables can have up to 10 metrics.Pivot tables can have up to 2 column dimensions.Flexible-schema data sources, such as Google Sheets and BigQuery, can have up to 10 row dimensions.Fixed-schema data sources, such as Google Ads and Google Analytics, can have up to 5 row dimensions.The number of row dimensions available depends on the type of data you're connecting to:.You may have up to 5 pivot tables per page in a report.You can apply a filter to the pivot table to reduce the amount of data being processed. Pivot tables can process up to 50,000 rows of data, however, depending on the data set and dimensions and metrics involved in the table, performance may degrade.Set the color of the chart header options. Note that report viewers can always access the options by right clicking the chart. Click these to access the header options. Three vertical dots appear when you mouse over the chart header. Chart header options are: Show on hover (default) The chart header lets viewers perform various actions on the chart such as exporting the data or viewing the chart in the Explorer tool. Choose from 3 levels of contrast, low, medium, or high. Sets the font color automatically when displaying a heatmap. These options control the appearance of the table data. Sets the color of odd or even rows in the table. Sets the color of the border between rows. Sets the color of the table header background. These options control the colors of the table borders and cells. Header font colorĬhanges the font color of the table header.Ĭhanges the font size of the table header.Ĭhanges the font family of the table header. These options control the appearance of the data labels. Expand-collapse also provides a way for a single pivot table to show both summary and detailed information, reducing the number of charts needed in your reports.Įxample pivot table showing expand-collapse with a geographic hierarchy.Ī chart's style properties control the overall presentation and appearance of the chart.
![aqua data studio code folding aqua data studio code folding](https://www.aquafold.com/wp-content/themes/Divi/images/Aqua-Data-Studio-edit-data-in-Excel-style-grid.png)
Viewers can then explore the data at the level of detail that interests them most. Expand-collapseĮxpand-collapse lets report viewers show or hide different levels of information in the pivot table by clicking + and – in the column header. Pivot tables support totals and subtotals for both rows and columns:Įxample pivot table showing totals and subtotals. This further breaks down the data, giving you even more insight into your data:Įxample pivot table showing Gender as breakdown dimension.
![aqua data studio code folding aqua data studio code folding](https://www.aquafold.com/wp-content/themes/Divi-Child/assets/diagrams-img/screenshot_table_data_editor_data_validation.png)
The example below adds the Gender dimension to the rows. Pivot tables in Data Studio support adding multiple row and column dimensions. Notice that several countries had no revenue in Q4, for example. You can also quickly spot outliers or anomalies in your data. This table easily summarizes the data from the previous example.
![aqua data studio code folding aqua data studio code folding](https://i.ytimg.com/vi/o3XurSeE7H8/maxresdefault.jpg)
While this table is useful for showing which country received the most revenue per user and in which quarter, it isn't useful for summarizing this data in a meaningful way.Ī pivot table, however, quickly shows the relationship of this data:Įxample pivot table showing revenue per user, by country, quarter, and year The following is a standard table listing the Revenue Per User metric by calendar quarter and year:Įxample table showing revenue per user, by country, quarter, and year. This lets you group and summarize the data in ways a standard table can't provide. Pivot tables in Data Studio take the rows in a standard table and pivot them so they become columns.