Learn
Learn
University
Community
Documentation
Support
Go to GoodData.com
Slack
All Products
GoodData Cloud
All Products
GoodData Cloud
Home
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
Manage Users and User Groups
Integrate with CI/CD Pipeline
Manage Organization
Create an API Access Token
Set Up Authentication
Example: Using Amazon Cognito
OIDC Code Flow
OIDC Tokens Security
Multiple OIDCs
Set Up JWT Authentication
Using JavaScript
Use Organization API
Create and Restore Backups
View Entitlements
Manage Users
Manage Permissions
Organization
Data Sources
Workspace
Dashboard
Enable CORS
Enable CSP
Change Domain Name
Concepts
Organization
Connect Data
Create Data Sources
Snowflake
Amazon Redshift
Azure SQL
Google BigQuery
FlexConnect
Greenplum
Databricks
Microsoft SQL Server
PostgreSQL Server
Synapse SQL
Vertica
ClickHouse
MySQL
MariaDB
Oracle Database
SingleStore
GoodData ADS
MotherDuck
Dremio
Apache Drill
Manage Data Sources
Cache Management
Reload Cached Data
Use AWS PrivateLink
Improve Performance
Upload CSV Files
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
Integrate with dbt
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
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
Repeater
Sankey Diagram
Scatter Plot
Stacked Area Chart
Treemap
Waterfall Chart
Apply Filters
Filter by Attributes or Dates
Filter By Metric Values
Use Ranking Filter
Use Time-over-Time Comparison
Filter By Date
Sort Data
Use Smart Functions
Use Data Catalog
Create Calculated Metrics
Stack Metrics
Rename Data Labels
Configure Properties
Export
Concepts
Analytical Designer
Visualization
Filter
Create Dashboards
Configure Widgets
Add Filters
Date Filters
Attribute Filters
Dependent Filters
Saved Views
Cross-Filtering
Add Rich Text
Add Drilling
Drill into Visualization
Drill into Dashboard
Drill into URL
Drill Down
Automate
Create Alerts
Schedule Exports
Share
Export
Design for Accessibility
Use Custom Plugins
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
Change Number Format
Embed Visualizations
Using Iframes
Embed Dashboards
Embed Analytical Designer
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
Usage Data
HIPAA Add-On
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
Tabular Exports
API Reference
Experimental Features
Analytics Catalog
AI Assistant
Data Profiling
Machine Learning
Widget Container
Smart Search
What's New?
Data Source Concepts
Data Source
Data Source Manager
Data Source