Learn
  • Learn
  • University
  • Community
  • Documentation
  • Support
  • Go to GoodData.com
Slack
  • All Products
  • Granularity Keywords
  • Enterprise
  • Growth
  • English
  • French
  • German
  • Japanese (Japan)
  • Portuguese (Brazil)
  • Spanish
  • All Products
  • Granularity Keywords
  • Home
  • Find Documentation for Your GoodData Plan
    • GoodData Pricing Plans' Add-ons
  • How to Get Started with GoodData
    • System Requirements and Supported Browsers
    • Learn the Platform Essentials
      • GoodData Portal
      • Essential Terms and Concepts
    • Work with Workspaces
      • GoodData Demo Workspace
      • Create Workspaces
    • Load Data
      • Import CSV Files into a GoodData Workspace
      • Integrate a Data Source into a GoodData Workspace
        • Integrate a Data Source for a Data Warehouse
          • Import Sample Data to Your Data Source
        • Integrate a Data Source for an Object File Storage
      • Create a Relationship between Datasets
      • Publish your Logical Data Model
      • Load Data from a Data Source to a GoodData Workspace
    • Create Metrics
      • Create and Save a Metric
    • Add Insights and Dashboards
      • Create an Insight
        • Explore and Edit Insights on Dashboards
      • Build Dashboards
    • Share GoodData
      • Add and Manage Users in a Workspace
      • Embedding Analytical Designer
      • Embedding Dashboards
  • Dashboards and Insights
    • Analytical Designer
      • Visualize Your Data
        • Create Insights
        • Insight Types
          • Dependency Wheel Charts
          • Funnel Charts
          • Pyramid Charts
          • Sankey Diagrams
          • Waterfall Chart
          • Bar Charts
          • Bubble Charts
          • Bullet Charts
          • Column Charts
          • Combo Charts
          • Donut Charts
          • Geo Charts (pushpins)
            • Configure Data for Geo Charts (pushpins)
          • Headlines
          • Heatmaps
          • Line Charts
          • Pie Charts
          • Tables
          • Scatter Plots
          • Stacked Area Charts
          • Treemaps
        • Filters in Analytical Designer
          • Filter Insights by Values
          • Ranking Filter
          • Filter Metrics by Date
          • Enable Weeks in Date Filters
        • Sort Data in Insights
        • Configure Insight Properties
      • 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
    • Dashboards
      • Create Dashboards
      • Edit Items on Dashboards
      • Share Dashboards
      • Rename Dashboards
      • Duplicate Dashboards
      • Delete Dashboards
      • Add an Alert to a KPI
      • Schedule Automatic Emailing of Dashboards
      • Filters in Dashboards
        • Date Filters in Dashboards
        • Customize Date Filters in Dashboards
      • Drilling in Dashboards
        • Drill to Insights from Dashboards
        • Drill to Another Dashboard
        • Drill to URL from Dashboards
        • Drill Down in Dashboards
      • Export Dashboards
      • Embed Dashboards
      • Dashboards FAQ - Frequently Asked Questions
    • Create Custom Themes
      • Theme Properties
      • Theme Examples
      • Manage Themes with Life Cycle Management
    • Importing Custom Color Palettes
    • MAQL - Analytical Query Language
      • MAQL Use Cases and Tutorials
        • Explicit Lifting
        • Date Attribute Arithmetic
        • Finding Min and Max Dates Using Date Arithmetic
      • 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
            • Rank Variations
            • WITHIN Clause
            • WHERE TOP or BOTTOM(n) IN
            • WHERE TOP or BOTTOM(n) OF
            • Using Ranking Filters
            • PERCENTILE
        • Granularity Keywords
          • Overriding Insight 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
          • 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 - Adding a Trend Line
          • Running Total Functions
            • Rolling Window
            • Running Totals for Core Functions
            • Running Total Statistical Functions
        • 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
          • Filtering with the LIKE Clause
        • Logical Functions
          • IF THEN ELSE
          • CASE
          • IFNULL
          • Logical Expressions for Combining Filters
            • NOT
            • OR
            • AND
      • XAE - Extensible Analytics Engine
        • Extensible Analytics Engine (XAE) - FAQ
    • 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
    • Conditional Number Formatting
    • Color Formatting Reference
  • 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
      • Using a Custom Time Dimension in a Logical Data Model
      • Create the Output Stage based on Your Logical Data Model
      • Many-to-Many in Logical Data Models
        • Many-to-Many Modeling Performance
      • Data Modeling and MAQL
        • MAQL DDL
        • Change the Length of Attribute Labels
      • If Too Many Date Dimensions, Try Events
    • 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 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
          • 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
          • Accessing Data Integration Console
          • Data Integration Console Overview Screen
          • Data Integration Console Workspace Screen
        • 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
        • Schedule a Data Load
        • Schedule a Data Loading Process for a Group of Workspaces
        • Edit a Scheduled Data Load
        • Explore Advanced Options of a Scheduled Data Load
        • Configure Schedule Parameters
        • Configure Schedule Sequences
        • Schedule a Data Load 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 Load Execution
        • Create a Notification Rule for a Data Loading Process
        • Delete a Notification Rule from a Data Loading Process
        • Reuse Parameters in Multiple Data Loading Processes
        • Delete a Scheduled Data Load
      • 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
        • 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
      • 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
      • 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
      • Using Variables to Control Data Visibility
        • Numerical vs Filtered Variables
        • Define Numerical Variables
        • Incorporating Numerical Variables into Workspaces
        • Define Filtered Variables
        • Incorporating Filtered Variables at the Metric Level
        • Updating the Variable Using REST API
    • 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
        • 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
        • 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
      • Embed GoodData Elements into Your Applications
        • Feature Availability in Embedded and Non-embedded Mode
        • Embed Analytical Designer
          • Communication with Embedded Analytical Designer
        • Embed a Dashboard
          • Communication with Embedded Dashboards
        • Embedding Code Formats
        • Aligning Sessions Between Your Application and GoodData
        • Setting up Events for Drilling in Embedded Analytical Designer and 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
    • 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
      • 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 Insight Attributes with BY Keyword
  • Time Transformations
  • Running Total Functions

 

Overriding Insight 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