Learn
  • Learn
  • University
  • Community
  • Documentation
  • Support
  • Go to GoodData.com
GoodData Classic
  • All Products
  • Granularity Keywords
  • English
  • French
  • German
  • Japanese (Japan)
  • Portuguese (Brazil)
  • Spanish
  • All Products
  • Granularity Keywords
  • Home
  • How to Get Started with GoodData
    • System Requirements and Supported Browsers
    • GoodData Classic Documentation
    • GoodData Portal
    • GoodData Pricing Plans' Add-ons
  • Dashboards and Insights
    • Analytical Designer
      • Visualize Your Data
        • Create Insights
        • Insight Types
          • Bar Charts
          • Bubble Charts
          • Bullet Charts
          • Column Charts
          • Combo Charts
          • Dependency Wheel Charts
          • Donut Charts
          • Geo Charts (pushpins)
            • Configure Data for Geo Charts (pushpins)
          • Funnel Charts
          • Headlines
          • Heatmaps
          • Line Charts
          • Pie Charts
          • Pivot Tables
          • Pyramid Charts
          • Sankey Diagrams
          • Scatter Plots
          • Stacked Area Charts
          • Treemaps
          • Waterfall Chart
        • Filters in Analytical Designer
          • Filter Insights by Values
          • Ranking Filter
          • Filter Metrics by Date
          • Enable Weeks in Date Filters
        • Configure Insight Properties
        • Sort Data in Insights
      • Work With Metrics
        • Data Catalog in Analytical Designer
        • Rename Metrics
        • Format Numbers
        • Time over Time Comparison
        • Create Metrics in Insights
        • Stack Metrics
      • Export and Embed Insights
        • Export Insights
        • Embed Insights
      • Analytical Designer - Frequently Asked Questions
    • KPI Dashboards
      • Set up a KPI Dashboard
      • Edit Items on KPI Dashboards
      • Share KPI Dashboards
      • Rename a KPI Dashboard
      • Duplicate KPI Dashboards
      • Delete a KPI Dashboard
      • Add an Alert to a KPI
      • Schedule Automatic Emailing of KPI Dashboards
      • Filters in KPI Dashboards
        • Date Filters in KPI Dashboards
        • Customize Date Filters in KPI Dashboards
      • Drilling in KPI Dashboards
        • Drill to Insights from KPI Dashboards
        • Drill to Another KPI Dashboard
        • Drill to URL from KPI Dashboards
        • Drill Down in KPI Dashboards
      • Export KPI Dashboards
      • Embed KPI Dashboards
      • KPI Dashboard FAQ - Frequently Asked Questions
    • Create Custom Themes
      • Theme Properties
      • Theme Examples
      • Manage Themes with Life Cycle Management
    • Importing Custom Color Palettes
    • Reports
      • Working with Reports
        • Creating New Reports in the Report Editor
          • What Pane - Adding Metrics to Reports
          • How Pane - Adding Attributes to Reports
          • Filter Pane - Filtering within a Report
            • Filter from a List of Values
            • Ranking Filter in Reports
            • Numeric Range Filter
            • Variable Filter
        • Maximum Report Size
        • Add Limits and Goals to a Report
        • Display Omitted Empty Values in a Table
        • Creating a Headline Report
        • Configuration Pane Report Statistics
        • Configuration Pane Report Usage
        • Build a Period-Over-Period Report
        • Share a Report
        • Exporting Raw Report Data
        • Drilling into Reports
          • Drilling Across
          • Drilling Down
          • Drilling In
          • Defining Global Drill Down Paths
        • Report Info Panel
        • Export Reports
        • Export File Types
      • Working with Charts
        • Configure a Chart
        • Advanced Chart Configuration
        • Designating Primary and Secondary Axes
        • Customizing Chart Colors
        • Defining Miscellaneous Chart Display and Labeling Options
        • Chart Sorting
        • Setting up Data for Geo Charts
        • Building a Geo Chart
        • Global Settings
        • Chart Types
          • Area Chart in Report Editor
          • Bar Chart in Report Editor
          • Bubble Chart in Report Editor
          • Bullet Chart in Report Editor
          • Combo Chart in Report Editor
          • Donut Chart in Report Editor
          • Funnel Chart in Report Editor
          • Line Chart in Report Editor
          • Pie Chart in Report Editor
            • Pie and Donut Charts in Report Editor
          • Scatter Chart in Report Editor
          • Stacked Area Chart in Report Editor
          • Stacked Bar Chart in Report Editor
          • Waterfall Chart in Report Editor
      • Working with Tables
        • Display a Report as a Table
        • Add Color Formatting to Tables
        • Renaming Row and Column Headers
        • Adjusting Column Width
        • Calculate Percentage Shares
        • Rearranging Rows and Columns
        • Pivot a Table
        • Displaying Multiple Metrics in Separate Rows or in Separate Columns
        • Create a Heat Map Table
        • Formatting Table Values Using the Configuration Pane
        • Add Detail to a Metric or Attribute Value
        • Aggregate Table Data
        • Change a Label for Table Values
        • Filter a Metric Value
        • Get Table Object Details
        • Sorting Row and Column Values
    • Dashboards
      • Creating Dashboards
        • Planning Your Dashboard
        • Build a Dashboard
        • Edit Dashboards, Tabs, and Reports
          • Configure Dashboard Elements
          • Manage a Tab
          • Duplicate a Dashboard
          • Delete a Dashboard
        • Dashboard Design Lab
          • Custom Embed Tool
          • Dashboard Design Tips
          • Dashboard Layout Assets
        • Dashboard Macros
          • Dashboard Macro Reference
        • Display Selected Filter Values in a Dashboard Textbox
        • Adding Dynamic Images to Your Workspaces
      • Using Dashboards
        • Dashboard Filters
          • Filter for Attributes
          • Filter for Dates
            • Set First Day of Week in Date Filters to Monday
          • Filter for Variables
          • Dissociate Dashboard Filters from a Report
          • Filter out Values of Attribute Filters
          • Set Up a Filter Group
          • Set Up Cascading Filters
          • Filter Reports by Other Reports
        • Using Saved Views
        • Workspace and Dashboards and Tabs
        • Schedule Automatic Emailing of Dashboards to Yourself and Others
        • Displaying a Dashboard on a TV Screen
        • Numbers and Arrows in Dashboards
      • Taking Dashboard Effectiveness to the Next Level
    • MAQL - Analytical Query Language
      • MAQL and Multidimensionality
      • MAQL versus SQL
      • Get Started with Using MAQL to Write Metrics
      • MAQL Expression Reference
        • Aggregation Functions
          • SUM
          • AVG
          • MAX
          • MIN
          • MEDIAN
          • COUNT
          • GREATEST
          • LEAST
          • Statistical Functions
            • Variance Functions
            • Standard Deviation Functions
            • Covariance Functions
            • CORREL
            • Least-Squares Functions
        • Numeric Functions
          • Arithmetic Operations
          • ABS
          • SIGN
          • SQRT
          • LOG
          • LN
          • EXP
          • POWER
          • Rounding and Truncation Functions
            • ROUND
            • FLOOR
            • CEILING
            • TRUNC
          • Rank
            • Create a Rank over Time Report
            • Rank Variations
            • WITHIN Clause
            • WHERE TOP or BOTTOM(n) IN
            • WHERE TOP or BOTTOM(n) OF
            • Using Ranking Filters
            • PERCENTILE
        • Granularity Keywords
          • Overriding Report Attributes with BY Keyword
            • BY
            • BY ALL
            • BY attribute ALL IN ALL OTHER DIMENSIONS
            • BY ALL IN ALL OTHER DIMENSIONS
            • BY ALL IN ALL OTHER DIMENSIONS EXCEPT FOR attribute
            • BY Clause Variations
            • Using BY Clause to Lock Aggregation
          • Time Transformations
            • Functions For Referring to Past Time Periods
              • FOR Previous
              • FOR PreviousPeriod
            • Functions for Referring to Future Time Periods
              • FOR Next
              • FOR NextPeriod
              • FORECAST - Add a Trend Line to a Report
          • Running Total Functions
            • Rolling Window
            • Running Totals for Core Functions
            • Running Total Statistical Functions
            • Running Totals on Slice and Dice Dialog
        • Filter Expressions
          • Filtering with the WHERE Clause
            • Operators for Defining Filters
              • Equals Operator
              • Does Not Equal Operator
              • Other Relational Operators
              • IN
              • NOT IN
              • BETWEEN
              • NOT BETWEEN
            • Referencing Floating Time Periods
              • THIS Macro
              • PREVIOUS Macro
              • NEXT Macro
            • Adding Filtered Variables to Metric Definitions
          • Filtering with the HAVING Clause
          • Overriding Parent Filters
            • PARENT Filters
            • Use WITHOUT PARENT for Percentage Baselines
          • Filtering with the LIKE Clause
        • Logical Functions
          • IF THEN ELSE
          • CASE
          • IFNULL
          • Logical Expressions for Combining Filters
            • NOT
            • OR
            • AND
      • MAQL Use Cases and Tutorials
        • Create an Executive Overview Dashboard
        • Compare Data from Multiple Time Periods in a Report
        • Create Buckets for Attribute Values
        • Generate Cohort Report
        • Explicit Lifting
        • Date Attribute Arithmetic
        • Metric Running Totals
        • Time over Time Comparison in Reports
        • Using Variables to Filter by a Child Table
        • Analyzing Change with Historical Data (Snapshotting)
        • Comparing Dynamically Filtered Values in a Single Report
        • Finding Min and Max Dates Using Date Arithmetic
        • Extended TOP and BOTTOM Ranks
        • MAQL Video Tutorials
          • Essential MAQL Metrics Videos
            • MAQL Metrics - Number of Replies
            • Average First Reply Time (mins)
            • Average First Time Reply Time (hrs)
            • Median First Reply by Group
            • MAQL - Case Metrics
            • Support Points
          • Basic Aggregation in MAQL Videos
            • Number of Orgs. By Year
            • Number of Tickets by Status
          • Filters and Macros in MAQL Videos
            • Month-to-Date Comparisons
            • Number of Tickets in a Particular Month
            • Ticket Breakdown: Open and Solved
            • Using MAQL for Service Level Agreement (SLA) Reporting
          • MAQL - Locking Aggregation with BY Clauses
            • Monthly Average Tickets per Day
            • Quarterly Tickets
            • Support Group Performance
            • Support Performance within Group and Across Company
          • Period-Over-Period Reporting
            • Daily Solved Tickets vs. Average Solved
            • Day Over Day Ticket Reporting
            • Month Over Month Reporting
          • NULL Reporting - Dealing with Missing Values in MAQL Videos
            • Adding NULL Values
      • XAE - Extensible Analytics Engine
        • Extensible Analytics Engine (XAE) - FAQ
        • Upgrading XAE to Version 3
    • Filters in the GoodData Platform
    • Dates and Times
      • Date Attribute Hierarchies
      • Date Attribute Reference
    • Change Date Format
    • Manage Custom Date Dimensions
    • Formatting Numbers in Insights and Reports
    • Conditional Number Formatting
    • Color Formatting Reference
    • Keyboard Shortcuts
  • Data Integration
    • Data Modeling in GoodData
      • Logical Data Model Components in GoodData
        • Datasets in Logical Data Models
        • Facts in Logical Data Models
        • Attributes in Logical Data Models
        • Dates in Logical Data Models
        • Connection Points in Logical Data Models
      • Mapping between a Logical Data Model and the Data Source
      • Create a Logical Data Model Manually
      • Create a Logical Data Model from CSV Files
      • Create a Logical Data Model from Your Cloud Data Warehouse
      • Create a Logical Data Model from Your Cloud Object Storage Service
      • Create a Logical Data Model from the Output Stage
      • Update a Logical Data Model
      • Publish a Logical Data Model
      • Import and Export a Logical Data Model
      • Add Custom Fields to the LDMs in Client Workspaces within the Same Segment
      • Create the Output Stage based on Your Logical Data Model
      • Many-to-Many in Logical Data Models
        • Many-to-Many Modeling Performance
        • Reporting M-N Metrics by Tag
        • Reporting M-N Metrics by Other Tags
        • Reporting M-N Metrics by Multiple Tags
        • Reporting M-N Metrics by Not Included Tags
        • Modeling Many-to-Many Relationships in CloudConnect
      • Data Modeling and MAQL
        • MAQL DDL
      • If Too Many Date Dimensions, Try Events
      • Data Modeling Using the CloudConnect Tool
        • Learning Data Modeling in CloudConnect
          • CloudConnect Modeler User Interface
            • CloudConnect Modeler Editor Pane
            • CloudConnect Modeler Tabs Pane
            • CloudConnect Modeler Outline Pane
            • CloudConnect Modeler Project Explorer Pane
            • CloudConnect Modeler Toolbar and Search
          • Creating Your First Data Model in CloudConnect
            • Example Data Schema and How to Structure Data
            • Build Your First Logical Data Model in CloudConnect Modeler
              • Creating Your CloudConnect Project
              • Opening the CloudConnect Modeler
              • LDM Naming Conventions
              • Adding Your First Dataset in CloudConnect Modeler
              • Adding Attributes and Facts to a Dataset in CloudConnect Modeler
            • Building the Hierarchies in the CloudConnect Modeler
              • Creating a Dataset in CloudConnect Modeler
              • Moving Attributes in CloudConnect Modeler
              • Defining the Relationship between Datasets in CloudConnect
              • Creating the Department Dataset
              • Adding a Date Object in CloudConnect Modeler
              • Building Relations between Objects in CloudConnect
            • Updating Other Projects with Your LDM in CloudConnect
            • Creating a Data Model in CloudConnect (Summary)
          • Working with Logical Data Models in CloudConnect
            • CloudConnect Modeler Workflow
            • Creating a New Logical Data Model in CloudConnect
            • Updating a Data Model in CloudConnect
            • Publishing Logical Data Models in CloudConnect
              • Changing the Working CloudConnect Project
              • Publish Your Logical Data Model in CloudConnect
              • Managing LDM Project Changes in CloudConnect
              • Publishing Your Logical Data Model to Multiple Projects
                • Publish a Copy of Your LDM to Multiple Projects in CloudConnect
                • Publish One LDM to Multiple Projects in CloudConnect
            • Deleting a Data Model in CloudConnect
            • Exporting Your Logical Data Model in CloudConnect
            • Importing Your Logical Data Model into CloudConnect
            • Downloading a Logical Data Model from the Platform to CloudConnect
            • Version Control in CloudConnect
            • Validating Your Data Model in CloudConnect
          • Working with LDM Objects in CloudConnect
            • Adding Objects to Your CloudConnect Project
              • Adding LDM Datasets in CloudConnect
                • Dataset Folder Names in CloudConnect
              • Attributes and Facts Window in CloudConnect
              • Data Model Object Types in CloudConnect Modeler
              • LDM Object Datatypes in CloudConnect
              • Adding LDM Date Object in Cloud Connect
              • Importing CL Tool XMLs in CloudConnect
            • Editing Object Properties in CloudConnect Modeler
              • Editing Dataset Properties in CloudConnect
              • Editing Date Dataset Properties in CloudConnect
              • Convert a Fact into an Attribute in CloudConnect
              • Rename a Fact or Attribute in CloudConnect
              • Building Relations between Objects in CloudConnect Modeler
              • Managing LDM Dependencies in CloudConnect
                • Removing Attributes and Facts from Your LDM in CloudConnect
                • Force Publishing an LDM in CloudConnect
            • Using a Custom Time Dimension in a Logical Data Model
          • Learning Data Modeling by Exploring
        • CloudConnect Project Structures
        • Connect to the Platform through CloudConnect
        • CloudConnect Keyboard Shortcuts
        • Work with Fact Table Grain Using CloudConnect Modeler
        • Data Modeling API (Cloud Connect)
        • Data Modeling Tutorials for CloudConnect and APIs
          • Building an LDM for Facebook Example Project
          • Creating Analytical Project with MAQL DDL
          • Changing the Length of Attribute Labels
          • Choosing a Primary Attribute Identifier in Your ETL Graph
          • Defining Custom Sorting Order for an Attribute
          • Disconnecting Dataset Directly
          • Count Attribute Values In Specific Data Sets
          • Flexible Querying with a Disconnected Date Dimension
          • Modeling Technique - Pushing FACTs Down the Hierarchy
          • Painless Disconnected Date Dimensions
          • Resolving Logical Data Model Dependencies
          • Set the Grain of a Fact Table to Avoid Duplicate Records
          • Snapshot Dimensions
          • Optimizing Data Models for Better Performance
          • HR Data Analysis
    • Data Preparation and Distribution
      • Direct Data Distribution from Data Warehouses and Object Storage Services
        • GoodData-Azure Blob Storage Integration Details
        • GoodData-Azure SQL Database Integration Details
        • GoodData-Azure Synapse Analytics Integration Details
        • GoodData-BigQuery Integration Details
        • GoodData-Microsoft SQL Server Integration Details
        • GoodData-MongoDB BI Connector Integration Details
        • GoodData-MySQL Integration Details
        • GoodData-PostgreSQL Integration Details
        • GoodData-Redshift Integration Details
        • GoodData-S3 Integration Details
        • GoodData-Snowflake Integration Details
        • Integrate Data Warehouses Directly to GoodData based on an Existing LDM
        • Integrate Data from Your Amazon S3 Bucket Directly to GoodData
        • Automated Data Distribution v2 for Data Warehouses
          • Load Modes in Automated Data Distribution v2 for Data Warehouses
          • Set Up Automated Data Distribution v2 for Data Warehouses
          • Naming Convention for Output Stage Objects in Automated Data Distribution v2 for Data Warehouses
          • Create the Output Stage based on Your Data Warehouse Schema
          • Time Zones in Automated Data Distribution v2 for Data Warehouses
        • Automated Data Distribution v2 for Object Storage Services
          • Load Modes in Automated Data Distribution v2 for Object Storage Services
          • Set Up Automated Data Distribution v2 for Object Storage Services
          • Naming Convention for Source Files in Automated Data Distribution v2 for Object Storage Services
      • Data Preparation and Distribution Pipeline
        • Before You Start with Data Preparation and Distribution Pipeline
        • Phases of Building the Data Pipeline
        • Build Your Data Pipeline
        • Export and Import the Data Pipeline
        • Data Pipeline Reference
          • Brick Reference
            • Configure a Brick
            • Downloaders
              • CSV Downloader
                • Input Data for CSV Downloader
                • Manifest File
                • Feed File
              • Google Analytics Downloader
              • Google Sheets Downloader
              • Salesforce Downloader
              • SQL Downloader
            • Integrators
              • ADS Integrator
                • Computed Fields
            • Executors
              • SQL Executor
            • Utilities
              • Schedule Executor
              • Object Renaming Utility
              • Custom Field Creator
              • Date Dimension Loader
          • Data Warehouse Reference
            • Data Warehouse
              • Data Warehouse Quick Start
              • Data Warehouse and the GoodData Platform Data Flow
              • Intended Usage for Data Warehouse
              • Data Warehouse and Vertica
              • Data Warehouse Architecture
              • Data Warehouse Technology
              • Data Warehouse Logical and Physical Model
              • Database Schema Design
                • Logical Schema Design - Tables and Views
                  • Primary and Foreign Keys
                  • Altering Logical Schema
                • Physical Schema Design - Projections
                  • Columns Encoding and Compression
                  • Columns Sort Order
                  • Segmentation
                  • Configuring the Initial Superprojection with CREATE TABLE Command
                  • Creating a New Projection with CREATE PROJECTION Command
                  • Changing Physical Schema
              • Column Storage and Compression in Data Warehouse
              • Ports Used to Connect to GoodData
              • Querying Data Warehouse
              • Limitations and Differences in Data Warehouse from Other RDBMS
                • Single Schema per Data Warehouse Instance
                • No Vertica Admin Access
                • Use COPY FROM LOCAL to Load Data
                • Use COPY FROM S3 to Load Data
                • Not Supported Functions
                • Limited Access to System Tables
                • Limited Access to Spatial Functions
                • Flex Table Limits
                • Database Designer Tool not Available
                • JDBC Driver Limitations
                • Resource Limitations
                • Other Limitations
              • Data Warehouse Best Practices
              • Understanding Vertica Error Codes
              • Data Warehouse API Reference
            • How to Work with Data Warehouse Instances
              • Creating a Data Warehouse Instance
                • Data Warehouse Instance Details Page
              • Reviewing Your Data Warehouse Instances
              • Deprovision Your Data Warehouse Instance
              • Managing Users and Access Rights
                • Data Warehouse User Roles
                • Getting a List of Data Warehouse Users
                • Adding a User in Data Warehouse
                • Changing a User Role in the Data Warehouse Instance
                • Reviewing Data Warehouse User Details
                • Removing a User from Data Warehouse
              • Exporting Data from Data Warehouse
            • How to Set Up a Connection to Data Warehouse
              • Connecting to Data Warehouse from CloudConnect
                • Creating a Connection between CloudConnect and Data Warehouse
                • Loading Data through CloudConnect to Data Warehouse
                  • Project Parameters for Data Warehouse
                  • Creating Tables in Data Warehouse from CloudConnect
                  • Loading Data to Data Warehouse Staging Tables through CloudConnect
                  • Merging Data from Data Warehouse Staging Tables to Production
                  • Exporting Data from Data Warehouse using CloudConnect
                  • Loading Compressed Data
                  • Choose a Data Warehouse Parser
                    • GdcCsvParser Options
                  • Use RFC 4180 Compliant CSV Files for Upload
                  • Error Handling
                  • Merging Data Using Staging Tables
                  • Statistics Collection
              • Connecting to Data Warehouse from SQL Client Tools
                • Download the JDBC Driver
                  • Data Warehouse Driver Version
                  • Enable Logging for the JDBC Driver
                • Prepare the JDBC Connection String
                • Access Data Warehouse from SQuirrel SQL
              • Connecting to Data Warehouse from Java
              • Connecting to Data Warehouse from JRuby
                • Install JRuby
                • Access Data Warehouse Using the Sequel library
                • Installing Database Connectivity to Ruby
                  • Installing the Data Warehouse JRuby support
                  • Example Ruby code for Data Warehouse
            • Get Started Using Agile Data Warehousing Service
          • Automated Data Distribution Reference
            • Automated Data Distribution
            • Use Automated Data Distribution
            • Delete Data from Datasets in Automated Data Distribution
            • Naming Convention for Output Stage Objects
            • Time Zones in Automated Data Distribution
      • Setting Up Data Loading Processes
        • Data Integration Console Reference
          • Users of Data Integration Console
          • Accessing Data Integration Console
          • Data Integration Console Overview Screen
          • Data Integration Console Workspace Screen
          • Recommended Practices on Managing Data Loads
        • Create a Data Source
        • Share a Data Source with Other Users
        • Delete a Data Source
        • Deploy a Data Loading Process for Automated Data Distribution v2
        • Deploy a Data Loading Process for a Data Pipeline Brick
        • Deploy a Data Loading Process for a Life Cycle Management (LCM) Brick
        • Deploy a Data Loading Process from a Ruby Script
        • Deploy a Data Loading Process from a CloudConnect Graph
        • Schedule a Data Loading Process
        • Schedule a Data Loading Process for a Group of Workspaces
        • Configure Schedule Parameters
        • Configure Schedule Sequences
        • Schedule a Data Loading Process for Manual Execution Only
        • Time a Scheduled Data Loading Process
        • Configure Automatic Retry of a Failed Data Loading Process
        • Run a Scheduled Data Loading Process on Demand
        • Disable a Scheduled Data Loading Process
        • Review a Log of Data Loading Process Execution
        • Create a Notification Rule for a Data Loading Process
        • Delete a Notification Rule from a Data Loading Process
        • Update Multiple Recipients of Notification Rules through the Gray Pages
        • Set Up a Notification Rule for a Data Loading Process Using API
        • Reuse Parameters in Multiple Data Loading Processes
        • Delete a Data Loading Process
        • Delete a Schedule
      • Load CSV Files to Your Workspace
        • CSV File Requirements
        • Load CSV Files to a Workspace with the LDM Modeler
          • Update Data in a Dataset from a CSV File
      • Additional Data Load Reference
        • GoodData IP Addresses and IP Whitelisting
        • Loading Data via REST API
        • Delete Old Data while Loading New Data to a Dataset via API
        • Transform Data for Batch Predictions and Recommendations
          • Data Preparation and Data Evaluation Functions
        • Workspace Specific Data Storage
        • User Specific Data Storage
        • Blueprints
          • Data Pipeline Blueprints
            • ELT Blueprint
              • ELT Blueprint FAQ
            • Workspace Data Loading Blueprint
          • Workspace Blueprint
        • Loading Data Using CloudConnect
          • CloudConnect Core Concepts
          • CloudConnect System Requirements
          • CloudConnect Example Projects
          • Data Loading Modes in CloudConnect
          • Incremental Data Loading
          • Interactions between Data Integration Console and CloudConnect Designer
          • Updating CloudConnect
          • Apply a GoodData Password Change to CloudConnect Designer
          • GoodData CloudConnect Tutorial
            • Concepts
            • Setup
            • Creating a Data Model
            • Preparing a Data Loading Process
            • Automating a Data Loading Process
            • Creating Metrics and Reports
            • Creating a Dashboard
            • Next Steps
          • Setting up OAuth 2.0
          • Using OAuth 1.0a with REST Connector
          • Global Dynamic Variables in the CloudConnect
          • Extensible Data Loading Process
          • How to Obtain Facebook OAuth Token for GoodData Integration
          • Recommended ETL Development Practices
          • Downloading a CloudConnect Process from the Platform
          • Using CloudConnect with White Labeled GoodData
          • Combining Google Analytics and Twitter Search Projects
          • CloudConnect - Accessing Internal Project Storage
          • CloudConnect Preformat Architecture
          • Join Components vs Lookup CTL2 Function
          • Additional CTL Function Libraries
          • Creating Custom Notification Events
          • CloudConnect - Reformat, Denormalizer, and Normalizer
          • CloudConnect - Using Lookups
          • CloudConnect - Using Parameters
          • CloudConnect - Working with Databases
          • CloudConnect - Working with Data on S3 Storage
          • CloudConnect - Working with Metadata
          • CloudConnect - Working with Archives
          • CloudConnect - Parsing XML Files
          • Delete Old Data while Loading New Data via CloudConnect
          • Paging Using the CloudConnect REST Connector
          • Enable Support of SAP HANA in CloudConnect
          • Install the Oracle and MySQL Drivers in CloudConnect
          • Analyzing Website Traffic Using Google Analytics
          • Analyzing Data from Facebook Insights
          • Analyzing Customer Data from Salesforce
          • Analyzing Twitter Search
          • Capturing More Twitter Search API Data
          • CloudConnect Issues
            • Common Errors at Building Your First Project
            • Workspace is Missing after Upgrading CloudConnect
            • Error 'Cannot create JDBC driver SAP HANA'
            • Update the Google Analytics Connection in a Project
        • Deleting Records from Datasets
  • Workspace and User Administration
    • Administrating Workspaces and Workspace Objects
      • Find the Workspace ID
      • Find the Workspace Authorization Token
      • Find out what Database Engine a Workspace Runs on
      • Find the Workspace Name
      • Rename a Workspace
      • Clone a Workspace
      • Validate a Workspace
      • Create a Workspace
      • Switch between Workspaces
      • Leave a Workspace
      • Delete a Workspace
      • Set a Custom Time Zone for Your Workspace
      • Deleting Data from a Workspace
      • Access the Gray Pages for a Workspace
      • Migrate Selected Objects between Workspaces
      • Acquiring Object Identifiers for Workspace Metadata
      • Share Reports and Dashboards with Scheduled Emails
      • Configure Various Features via Platform Settings
      • GoodData Extension Tool for Chrome
    • Multitenancy on the GoodData Platform
    • Managing Workspaces via Life Cycle Management
      • LCM Implementation
      • Configuring LCM via API
      • Bricks
        • Release Brick
        • Rollout Brick
        • Provisioning Brick
        • Users Brick
        • User Filters Brick
      • How to Use a Brick
        • Specifying Complex Parameters
        • Types of Input Data Sources
    • Managing Workspace Data and Data Access
      • Manage Datasets
        • Add a Tag to a Dataset
      • Manage Attributes
        • Add a Tag to an Attribute
        • Discover Attribute Labels and Drill Paths
        • Find Where an Attribute Is Used
        • Determine the Attribute Value ID
        • Use Computed Attributes
      • Manage Facts
        • Add a Tag to a Fact
      • Manage Metrics
        • Add a Tag to a Metric
      • Manage Variables
      • View a Workspace Model
      • Using Tags
      • Data Permissions
      • Advanced Data Permissions Use Cases
      • Create Data Permissions for Rolling Time Periods
      • Permission to Edit Workspace Metrics, Reports, and Dashboards
      • Managing Access to Workspace Objects via API
      • Manage Object Visibility - Hide and Share Objects
      • Using Variables to Control Data Visibility
        • Numerical vs Filtered Variables
        • Define Numerical Variables
        • Incorporating Numerical Variables into Workspaces
        • Define Filtered Variables
        • Updating the Variable Using REST API
        • Incorporating Filtered Variables at the Report Level
        • Incorporating Filtered Variables at the Metric Level
      • Element Masking
    • Managing Users in Workspaces
      • Provisioning Users to Domains and Workspaces
      • User Roles
        • User Roles Permissions
        • Create a Custom User Role
      • Use the Users Brick to Provision Users in Your Workspaces
      • Managing Workspace Member Profiles
      • Find the User ID
      • Update a User Email
      • Use Groups to Share Dashboards with Multiple Users
      • Inviting Users with Pre-applied Data Permissions
      • Disable or Delete Users
      • Set Default Number Format for Your User Account
    • GoodSuccess - GoodData Usage Analytics
  • Expand Your GoodData Platform
    • GoodData Platform Overview
      • Performance Tips
        • Workspace Performance
          • Report Computation
          • Measuring Report Execution Time
        • Data Warehouse Performance
          • Avoid Unnecessary UPDATEs
          • Check for Invalid Views
          • Do Not Overnormalize Your Schema
          • General Projection Design Tips
            • Minimize Network Joins
            • Choose Projection Sorting Criteria
            • Keep the Predefined Projection in Queries
          • Take Advantage of Table Partitions
          • Use Monitoring Tables
          • Use Run Length Encoding (RLE)
          • Use the EXPLAIN Keyword
          • Write Large Data Updates Directly to Disk
        • Report a Performance Issue
        • Platform Limits
      • Your GoodData Domain
      • GoodData Datacenters
      • Data Backup
      • Auditing Platform Events
      • GoodData Token Types
        • SST Session Expiration
    • GoodData Integration into Your Application
      • White Label Your Domain
        • Configure Custom Headers and Footers for PDF Report Exports
        • Configure DKIM for Outgoing Email
        • Default and Custom Domains
        • Email Templates
        • Frequently Asked Questions about White Labeling
        • What You Can White-Label
        • White-Label a New Domain
        • White-Label an Existing Domain
          • Set up a CNAME and Acquire a TLS Certificate
          • Choose a Domain Administrator
          • Coordinate Rollout
          • Customize the White-Labeled Domain
        • Configure Custom Headers for XLSX Exports
      • Embed GoodData Elements into Your Applications
        • Feature Availability in Embedded and Non-embedded Mode
        • Embed Dashboards and Reports
          • Filter an Embedded Report with a URL Parameter
          • Filter an Embedded Dashboard with a URL Parameter
          • Configure an Embedded Dashboard to Display a Specific Tab
          • Hide the Header of an Embedded Dashboard
          • Embed a Dashboard into Salesforce
          • Embedded Dashboard and Report API - Events and Methods
            • Embedding Parameters
            • Embedded Dashboard Events
            • Embedded Dashboard Methods
          • Track Dashboard Usage with an External Tracking Tool
          • Handle Drilling Report Requests through Your Web Application
        • Embed Analytical Designer
          • Communication with Embedded Analytical Designer
        • Embed a KPI Dashboard
          • Communication with Embedded KPI Dashboards
        • Embedding Code Formats
        • Aligning Sessions Between Your Application and GoodData
        • Setting up Events for Drilling in Embedded Analytical Designer and KPI Dashboards
        • Capture the Save an Insight Event from Embedded Analytical Designer
        • Sample HTML for Drill Eventing
      • Set up User Authentication and SSO
        • Single Sign-On Overview
        • SAML SSO with GoodData
          • Setting up Fluig Single Sign-On
          • Setting up Okta Single Sign-On
          • Setting up Auth0 Single Sign-On
          • Configure Identity Provider with Salesforce
          • Configuring Windows Server with AD FS for GoodData SAML SSO
          • Use SAML Just-in-Time User Provisioning in a SAML SSO Environment
          • Use System for Cross-domain Identity Management User Provisioning in a SAML SSO Environment
        • GoodData PGP Single Sign-On
          • How to Generate a Public-Private Key Pair
      • Metadata Localization
    • API Reference
    • API Version Information and Changelog
    • GoodData SDK
    • GoodData Java HTTP Client
  • Platform Security and Compliance
    • Security Shield
    • Enterprise Shield
      • HIPAA Add-On
      • GDPR-S Add-On
    • Supported TLS Security Protocols and Ciphers
    • Impersonation Feature
    • Password Policy
    • Firewall
  • GoodData Glossary
  • Additional Resources
    • Deprecated Features
      • Amazon S3 Credentials API Resource
      • Data Upload API Resource
      • Deprecated IP Addresses
      • Interactive Explorers
      • Java SDK Versions 2.32.0 and Older
      • JDBC Driver Version 3.0.2 through 3.1.2
      • Legacy Salesforce SSO Method
      • PGP SSO GET Method
      • PGP SSO Public Key
      • Project Templates
      • SFTP for Loading Data to the GoodData Platform
      • SHA-1 Signature for SAML
      • Support for TLS Version 1.0 and 1.1
      • visualization Object Type in Project Metadata
    • Downloads
    • Troubleshooting
      • Data Warehouse (ADS) Issues
      • Schedule Issues
      • Scheduled Email Issues
      • Report Issues
        • Available Area Too Small
      • Embedding Issues
  • Release Notes

Learn more:

You are viewing our older product's guide. Click here for the documentation of GoodData Cloud, our latest and most advanced product.

Granularity Keywords

  • Overriding Report Attributes with BY Keyword
  • Time Transformations
  • Running Total Functions

 

Overriding Report Attributes with BY Keyword
    • Start trial
    • Request a demo
    • See pricing
    • Product Overview
    • Business Intelligence
    • Artificial Intelligence
    • Analytics Lake
    • Trust & Security
    • Analytics as Code
    • Headless BI
    • Embedded Analytics
    • Data Visualization
    • Data Monetization
    • Query Acceleration
    • Solutions Overview
    • Professional Services
    • Software
    • Healthcare
    • E-commerce
    • Finance
    • Insurance
    • Real Estate
    • Pharma
    • ESG
    • Restaurants
    • Banking
    • Documentation
    • University
    • Community
    • Support
    • Certification Program
    • Python SDK
    • React SDK
    • Examples Gallery
    • API References
    • Release Notes
    • All resources
    • Product Tours
    • Case Studies
    • Whitepapers
    • Analyst Reports
    • E-books
    • Videos
    • Webinars
    • Events
    • BI Blog
    • Company
    • Customers
    • Partners
    • Careers
    • Newsroom
    • Brand
Copyright© 2007 - 2025 GoodData Corporation. All Rights Reserved.
Privacy Policy
Legal
Support Policy