Learn
  • Learn
  • University
  • Community
  • Documentation
  • Support
  • Go to GoodData.com
Slack
  • Cloud
  • Platform
  • Enterprise
  • Growth
  • Free
  • English
  • French
  • German
  • Japanese (Japan)
  • Portuguese (Brazil)
  • Spanish
  • 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
          • 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
          • Scatter Plots
          • Stacked Area Charts
          • Tables
          • Treemaps
        • Filters in Analytical Designer
          • Filter Insights by Values
          • Ranking Filter
          • Filter Metrics by Date
        • 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
    • Importing Custom Color Palettes
    • MAQL - Analytical Query Language
      • MAQL Use Cases and Tutorials
        • Date Attribute 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
    • Configure Custom Headers for Exported XLSX Files
  • 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
      • 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
      • 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
        • 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
        • 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
        • 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
      • Configure Various Features via Platform Settings
      • GoodData Extension Tool for Chrome
    • Multitenancy on the GoodData Platform
    • 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
      • Managing Workspace Member Profiles
      • Find the User ID
      • 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
    • Rollout Brick
    • Provisioning Brick
  • 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
    • 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
      • 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:

  • Get Started with Using MAQL to Write Metrics

Filter Expressions

This sections describes MAQL functions that you can use for filtering your computations:

  • 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

To learn more about how filtering, see Filters in the GoodData Platform.

Filtering with the WHERE Clause
    • Start trial
    • Get a demo
    • See pricing
    • Product overview
    • Embedded Analytics
    • Headless BI
    • Trust & Security
    • Services
    • E-commerce
    • Insurance
    • Financial Services
    • Software Companies
    • Documentation
    • University
    • Community
    • Support
    • Self-hosted deployment
    • Python SDK
    • React SDK
    • Examples Gallery
    • API References
    • All resources
    • Case studies
    • Analyst reports
    • Briefs
    • E-books
    • Podcasts
    • Videos
    • Webinars
    • Blog
    • Company
    • Customers
    • Partners
    • Careers
    • Newsroom
    • Brand
Copyright© 2007 - 2022 GoodData Corporation. All Rights Reserved.
Privacy Policy
Legal
Support Policy