Learn
Learn
University
Community
Documentation
Support
Go to GoodData.com
Try it now
All Products
GoodData.CN
Version v1.3
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 v1.3
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
Documentation
Getting Started
1. Get GoodData.CN
2. Create a Workspace
3. Connect Data
4. Build a Logical Data Model
5. Create a Dashboard with Insights
6. Embed Analytics into Your Application
7. Create a Multitenant Environment
8. Create Measures Using the APIs
Learn Concepts
Analytical Model
Attribute
Dashboard
Data Source
Dataset
Date Dataset
Deployment
Fact
Filter
Insight
Label
Logical Data Model
Measure
Multitenancy
Organization
Physical Data Model
Primary Key
Workspace
Install GoodData.CN
Evaluate GoodData.CN Community Edition
Advanced Configuration
Telemetry
Deploy on Kubernetes
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
Telemetry
Environment setup
Amazon AWS
Google Cloud Platform
Microsoft Azure
On-premise
Helm Chart Installation
Helm Chart Options
Logging and Monitoring
Manage Organizations, Workspaces, and Data Sources
Create and Manage Organizations
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
Manage Data Sources
Create and Test Data Sources
Generate a Physical Data Model Using the API
Refresh the Analytics after Loading New Data to a Database
Improve Performance
Data Sources Declarative Interface
Supported Databases
PostgreSQL Server
Amazon Redshift
Snowflake
Vertica
Google BigQuery
Manage a Logical Data Model
Generate a Physical Data Model in the LDM Modeler
Generate a Logical Data Model Automatically Using the API
Generate a Logical Data Model Automatically in the LDM Modeler
Create a Logical Data Model Manually
Evolve a Logical Data Model
Publish a Logical Data Model
Manage Users and UserGroups
User and UserGroup Entity Interface
Users and UserGroups Declarative Interface
Manage Organization Layout
Analyze Data
Discover and Visualize Your Data
Visualize Your Data
Create Insights
Learn Insight 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
Configure Insight Properties
Refine Visualized Data
Review and Organize the Data Catalog
Filter Insights by Attributes or Dates
Filter Insights by Measure Values
Use Time-over-Time Comparison in Insights
Filter Measures in an Insight by Date
Create Calculated Measures in Insights
Stack Measures in Insights
Rename Measures, Attributes, and Dates in Insights
Present Visualized Data on Dashboards
Manage Dashboards
Manage Insights on Dashboards
Use Date Filters on Dashboards
Use Attribute Filters on Dashboards
Configure a Dashboard Layout
Multidimensional Analytical Query Language (MAQL)
MAQL and Multidimensionality
Aggregation Functions
APPROXIMATE_COUNT
AVG
COUNT
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
FORECAST - Adding a Trend Line
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 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 Insight 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
Overriding Parent Filters
WITH PARENT FILTER
WITH PARENT FILTER EXCEPT
WITHOUT PARENT FILTER
WITHOUT PARENT FILTER EXCEPT
Relational Operators
API Docs
Introduction
Authentication
Conventions
Errors
Tools
API Reference
Use Embedding & Integrate
GoodData.UI
Accelerator Toolkit
Supported Databases
GoodData Cloud Native (GoodData.CN) supports the following databases:
PostgreSQL Server
Amazon Redshift
Snowflake
Vertica
Google BigQuery
PostgreSQL Server