Learn
Learn
University
Community
Documentation
Support
Go to GoodData.com
Slack
Cloud
Platform
Version (Cloud)
Cloud
v2.5
v2.4
v2.3
v2.2
v2.1
v2.0
v1.7
v1.6
v1.5
v1.4
v1.3
v1.2
v1.1
v1.0
Version (Cloud)
Cloud
v2.5
v2.4
v2.3
v2.2
v2.1
v2.0
v1.7
v1.6
v1.5
v1.4
v1.3
v1.2
v1.1
v1.0
Home
Introduction
Getting Started
Get GoodData
Create an API token
Create a Workspace
Connect Data
Build a Logical Data Model
Create a Dashboard with Visualizations
Create Metrics
Build Web Data Applications
Distribute Analytics To Users
Integrate with CI/CD Pipeline
Get GoodData
GoodData Cloud
Deprecated Features
Physical Data Model
GoodData.CN Community Edition
Advanced Configuration
Usage Data
GoodData.CN
Requirements
Deployment Architecture
Deployment Considerations
Domains and Certificates Management
DNS Configuration
TLS Configuration
Cert-manager Integration with Let's Encrypt
Ingress Controller in AWS
OIDC Provider Setup
Secrets Management
Usage Data
Visual Exports
Environment setup
Amazon AWS
Google Cloud Platform
Microsoft Azure
On-premise
Helm Chart Installation
Helm Chart Options
Logging and Monitoring
Execution limits
Set Up Organizations
Create Organizations
Set Up Authentication
Create the Bootstrap Token
Use the Default Dex Provider
Manage Organization
Create an API Access Token
Set Up Authentication
Example: Using Amazon Cognito
OIDC Code Flow
OIDC Tokens Security
Set Up JWT Authentication
Using JavaScript
Use Organization API
Create and Restore Backups
View Entitlements
Manage Users
Users Entity API
Users Declarative API
Manage Users and UserGroups Together
Manage Permissions
Organization
Data Sources
Workspace
Dashboard
Enable CORS
Enable CSP
Concepts
Organization
Connect Data
Create Data Sources
Snowflake
Amazon Redshift
Azure SQL
Google BigQuery
Greenplum
Databricks
Microsoft SQL Server
PostgreSQL Server
Synapse SQL
Vertica
Dremio
Apache Drill
Manage Data Sources
Cache Management
Reload Cached Data
Enable Pre-aggregation Caching
Encrypt Credentials
Improve Performance
Concepts
Data Source
Data Source Manager
Create Workspace
Declarative API Interface
Entity API Interface
Object Identification
Objects Organization
Objects Life Cycle
Concepts
Workspace
Analytical Model
Model Data
Prepare Your Data
Create a Logical Data Model
Create the Model Manually
Create SQL Datasets
Advanced Use Cases
Evolve Your Model
Monitor Model Changes
Manage Labels
Convert between Facts and Attributes
Many-to-Many in Logical Data Models
Concepts
Logical Data Model
Dataset
Primary Key
Attribute
Fact
Label
Create Metrics
Format Numbers
Create Metrics using API
Multidimensional Analytical Query Language (MAQL)
MAQL and Multidimensionality
Aggregation Functions
APPROXIMATE_COUNT
AVG
COUNT
FIRST_VALUE
LAST_VALUE
MAX
MEDIAN
MIN
SUM
Logical Operators
AND
NOT
OR
Mathematical functions
Arithmetic Operations
ABS
CEILING
EXP
FLOOR
GREATEST
LEAST
LN
LOG
POWER
ROUND
SIGN
SQRT
TRUNC
Running Total Functions
Rolling Window
Running Total Statistical Functions
Running Totals for Core Functions
Statistical Functions
CORREL
Covariance Functions
Least-Squares Functions
Standard Deviation Functions
Variance Functions
Ranking functions
PERCENTILE
Rank Variations
TOP or BOTTOM(n) IN
TOP or BOTTOM(n) OF
WITHIN Clause
Conditional Statements
CASE
IF THEN ELSE
IFNULL
Time Arithmetics
DATETIME_ADD
DATETIME_DIFF
Time Macros
Time Transformations
Functions For Referring to Past Time Periods
FOR EACH
FOR Next
FOR NextPeriod
FOR Previous
FOR PreviousPeriod
Filter Expressions
Filtering with the WHERE Clause
Filtering with the LIKE Clause
Filtering with the HAVING Clause
Using Ranking Filters
Overriding Parent Filters
WITH PARENT FILTER
WITH PARENT FILTER EXCEPT
WITHOUT PARENT FILTER
WITHOUT PARENT FILTER EXCEPT
Overriding Visualization Attributes with BY Keyword
BY
BY ALL
BY ALL IN ALL OTHER DIMENSIONS
BY ALL IN ALL OTHER DIMENSIONS EXCEPT FOR attribute
BY attribute ALL IN ALL OTHER DIMENSIONS
Relational Operators
Concepts
Metrics
Create Visualizations
Analytical Designer
Visualization Types
Bar Chart
Bubble Chart
Bullet Chart
Column Chart
Combo Chart
Dependency Wheel Chart
Donut Chart
Funnel Chart
Geo Charts (Pushpins)
Configure Data for Geo Charts
Upload Access Tokens for Geo Charts
Headline
Heatmap
Line Chart
Pie Chart
Pivot Table
Pyramid Chart
Sankey Diagram
Scatter Plot
Stacked Area Chart
Treemap
Waterfall Chart
Manage Visualizations
Sort Data in Visualizations
Review and Organize the Data Catalog
Filter Visualizations by Attributes or Dates
Filter Visualizations by Metric Values
Ranking Filter
Use Time-over-Time Comparison in Visualizations
Filter Metrics in a Visualization by Date
Calculate Metrics in Visualizations
Stack Metrics in Visualizations
Rename Metrics, Attributes, and Dates in Visualizations
Configure Visualization Properties
Export Visualizations
Concepts
Visualization
Filter
Create Dashboards
Manage Visualizations on Dashboards
Use Date Filters on Dashboards
Use Attribute Filters on Dashboards
Drilling in Dashboards
Set Drill into Visualization
Set Drill into Dashboard
Set Drill into URL
Configure a Dashboard Layout
Share Dashboards
Export Dashboards
Concepts
Dashboard
Customize Appearance
Create Custom Themes
Theme Properties
Theme Examples
Create Custom Color Palettes
White-Label Your Organization
Change Display Language
Manage Time Zones
Change Date Format
Embed Visualizations
Using Iframes
Using Web Components
Using React SDK
Set Up Multiple Tenants
Build a Workspace Hierarchy
Set Up Data Filters in Workspaces
Set Up Data Filters for Users
Create a Multitenant Environment
Permission Hierarchies
Concepts
Multitenancy
Security and Compliance
Secure Your Deployment
Security Infrastructure
Impersonation
Developer Tools
React SDK
Python SDKs
VS Code Extension (Beta)
Get Started
Object Structures
Command-line Interface
API
First Steps
Authentication
Conventions
Errors
Access Raw Data
API Reference
Feature Lab
Generative Chatbot
Data Profiling
Model Validation
Alerts
Intelligent Homepage
Explain Visualization
DashboardML
What's new?
Manage Visualizations
Sort Data in Visualizations
Review and Organize the Data Catalog
Filter Visualizations by Attributes or Dates
Filter Visualizations by Metric Values
Ranking Filter
Use Time-over-Time Comparison in Visualizations
Filter Metrics in a Visualization by Date
Calculate Metrics in Visualizations
Stack Metrics in Visualizations
Rename Metrics, Attributes, and Dates in Visualizations
Sort Data in Visualizations