Learn
Learn
University
Community
Documentation
Support
Go to GoodData.com
Try it now
All Products
GoodData.CN
Version v2.2
Cloud
v3.27
v3.26
v3.25
v3.24
v3.23
v3.21
v3.20
v3.19
v3.17
v3.16
v3.14
v3.13
v3.11
v3.10
v3.9
v3.8
v3.7
v3.6
v3.5
v3.4
v3.3
v3.2
v3.1
v3.0
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
All Products
GoodData.CN
Version v2.2
Cloud
v3.27
v3.26
v3.25
v3.24
v3.23
v3.21
v3.20
v3.19
v3.17
v3.16
v3.14
v3.13
v3.11
v3.10
v3.9
v3.8
v3.7
v3.6
v3.5
v3.4
v3.3
v3.2
v3.1
v3.0
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
Deploy & Install
GoodData Cloud
Limits
GoodData.CN Community Edition
Advanced Configuration
Usage Data
GoodData.CN
Requirements
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
Environment setup
Amazon AWS
Google Cloud Platform
Microsoft Azure
On-premise
Helm Chart Installation
Helm Chart Options
Logging and Monitoring
Execution limits
Manage Deployment
Set Up Organizations
Create Organizations
Manage Organizations
Enable CORS
Enable CSP
Set Up Authentication
Create the Bootstrap Token
Use a Built-in OIDC Identity Provider
Use an External OIDC Identity Provider
Map Users to the Organization
Use an API Token for Authentication
OIDC Tokens Security
Manage Workspaces and a Workspace Hierarchy
Build a Workspace Hierarchy
Set Up Data Filters in Workspaces
Work with Workspaces using API
Workspace Object Identification
Workspace Objects Life Cycle
Workspace Objects Organization
Workspace Declarative API Interface
Workspace Entity API Interface
Create a Multitenant Environment
Manage Users and UserGroups
User and UserGroup Entity Interface
Users and UserGroups Declarative API Interface
Manage User and UserGroups Together
Manage Permissions
Organization
Data Sources
Workspace
Customize Appearance
Create Custom Themes
Theme Properties
Theme Examples
Create Custom Color Palettes
White-Label Your Organization
Change Display Language
Manage Time Zones
Concepts
Deployment
Organization
Multitenancy
Workspace
Analytical Model
Connect Data
Create and Test Data Sources
Refresh the Analytics after Loading New Data to a Database
Improve Performance
Data Sources Declarative API Interface
Data Source Managers
Dremio
Apache Drill
Supported Databases
PostgreSQL Server
Amazon Redshift
Snowflake
Vertica
Google BigQuery
Greenplum
Cache Management
Concepts
Data Source
Model Data
Create a Physical Data Model
Generate a Physical Data Model In the LDM Modeler
Generate a Physical Data Model Using the API
Create a Logical Data Model
Generate a Logical Data Model In the LDM Modeler
Generate a Logical Data Model Using the API
Create a Logical Data Model Manually In the LDM Modeler
Evolve Your Logical Data Model
Monitor Model Changes
Manage Labels
Convert between Facts and Attributes
Many-to-Many in Logical Data Models
Concepts
Logical Data Model
Physical 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 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 Charts
Bubble Charts
Bullet Charts
Column Charts
Combo Charts
Donut Charts
Headlines
Heatmaps
Line Charts
Pie Charts
Pivot Tables
Scatter Plots
Stacked Area Charts
Treemaps
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
Dashboard
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
Export Dashboards
Embed Visualizations
Embed a Visualization
Embed a Dashboard
Embed Analytical Designer
API & SDKs
API
Authentication
Conventions
Errors
Filter Entities
Versioning
API Reference
Python SDKs
React SDK
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