Learn
Learn
University
Community
Documentation
Support
Go to GoodData.com
Slack
Cloud
Platform
Version (Cloud)
Cloud
v2.2
v2.1
v2.0
v1.7
v1.6
v1.5
v1.4
v1.3
v1.2
v1.1
v1.0
Cloud
Platform
Version (Cloud)
Cloud
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 Date Format
Change Display Language
Manage Time Zones
Concepts
Deployment
Organization
Multitenancy
Workspace
Analytical Model
Connect Data
Create Data Sources
Snowflake
Amazon Redshift
Azure SQL
Google BigQuery
Greenplum
Microsoft SQL Server
PostgreSQL Server
Synapse SQL
Vertica
Dremio
Apache Drill
Manage Data Sources
Cache Management
Reload Cached Data
Enable Pre-aggregation Caching
Improve Performance
Concepts
Data Source
Data Source Manager
Model Data
Prepare Your Data
Create a Logical Data Model
Create the Model Manually
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
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
Using Iframes
Using React SDK
API & SDKs
API
Authentication
Conventions
Errors
Filter Entities
Versioning
Retrieve Data Through API
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