Aloudata CAN Documentation
Overview
中文
English
Initializing search
Aloudata CAN Documentation
Home
Release Notes
Product Overview
Product Overview
Product Introduction
Product Benefits
Use Cases
Getting Started
Getting Started
User Interface Overview
Core Concepts
5-Minute Quick Start
FAQ
User Guide
User Guide
Home
Home
Home
Home Metric Query Logic
Data Integration
Data Integration
Overview
Import Internal Tables
Connect External Data Sources
Upload Local Files
Manage Data Sources
Manage Data Tables
Metric Definition
Metric Definition
Overview
Datasets
Datasets
Create a Dataset
Create a Calculated Field
Configure Dataset Relationships
Manage Datasets
Dimensions
Dimensions
Metric Date
Create a Dimension
Manage Dimension Values
Manage Dimensions
Metrics
Metrics
Metric Overview
Create a Metric
Create a Metric
Create a Basic Metric
Create a Derived Metric
Create a Composite Metric
Semi-Additive Metrics
Bulk Upload Metrics
Manage Metrics
Metric Acceleration
Metric Acceleration
Overview
Create a Materialization Plan
Create an External Materialization Plan
Scheduling
Acceleration Hit Rules
Dimension Extension for Materialized Acceleration
Metric Catalog
Metric Catalog
Overview
Search for Metrics
View Metric Details
Request Metric Permissions
Favorite Metrics
Metric Applications
Metric Applications
Metric Tree
Metric Tree
Create a Metric Tree
Metric Dashboards
Metric Dashboards
Overview
Create a Metric Dashboard
Charts
Charts
Pivot Table
Line Chart
Area Chart
Scatter Chart
Grouped Column Chart
Combo Chart
Grouped Bar Chart
Pie Chart
Radar Chart
Metric Tree
Query Controls
Manage Metric Dashboards
Metric Analysis
Metric Analysis
Derived Rules
Metric Views
Metric Views
Overview
Create a Metric View
Manage Metric Views
BI Tool Integration
BI Tool Integration
BI Tool Integration Guide
Guandata BI
FineBI
Metric Attribution
Metric Attribution
Metric Attribution
Attribution Metric Rules
Metric Monitoring
Metric Monitoring
Overview
Create Metric Monitoring
View Alert Information
Manage Monitored Metrics
Metric Calculation Logic
Metric Calculation Logic
Calculation Mechanism Overview
Basic Metric Calculation Logic
Derived Metric Calculation Logic
Composite Metric Calculation Logic
Quick Calculation Guide
Metric-to-Filter Rules
Query Environment Priority
System Administration
System Administration
User Management
User Management
User Management
User Group Management
User Attribute Management
Login Authentication
Login Authentication
Login Authentication Overview
LDAP Authentication Configuration
Governance Management
Governance Management
Metric Attribute Management
Dimension Attribute Management
Metric Category Management
Dimension Category Management
Dataset Category Management
Time Constraints
Time Constraints
Time Constraints
Business Constraints
Permission Management
Permission Management
Roles and Permissions
Row-Level Permissions
Column-Level Permissions
Authorize by Category
Permission Rules
Approval Management
API Key Management
Resource Management
Resource Management
Resource Queue
Query Routing
System Integration
System Integration
Office Software Integration
Office Software Integration
Feishu App Integration
WeCom Integration
Message Push
Message Push
Message Push Overview
Feishu App Push
WeChat Bot
Custom Webhook
Email Push
Iframe Embedding Guide
Platform Settings
Platform Settings
Platform Settings
Custom Calendar
Asset Import and Export
Best Practices
Best Practices
Real-Time Metric Querying
Function Reference
Function Reference
Overview
Operators
Aggregate Functions
Aggregate Functions
Avg
Count
CountDistinct
CovarPop
CovarSamp
Max
Min
MinBy
MaxBy
Percentile
PercentileApprox
StdDev
Sum
Variance
VarSamp
Analytical Functions
Analytical Functions
PowerAdd
PowerSub
PowerFix
Logical Functions
Logical Functions
If
In
IsFiltered
IsNull
Not
NotIn
NotNull
Sign
Window Functions
Window Functions
AccAvg
AccCount
AccMax
AccMin
AccSum
First
Last
Rank
RankDense
RowNumber
Text Functions
Text Functions
Concat
Contains
EndWith
Exact
Left
Length
Lower
Regexp_Extract
Replace
Right
SplitPart
StartWith
Strposition
Substring
Trim
Upper
Math and Trigonometric Functions
Math and Trigonometric Functions
Abs
Acos
Asin
Atan
Cos
Ceil
Degrees
Exp
Floor
Ln
Log
Log10
Mod
Pi
Power
Radians
Rand
Sin
Sqrt
Tan
Trunc
Date and Time Functions
Date and Time Functions
DateAdd
DateDiff
DateTrunc
Day
Date
DaysOfYear
DateOfQuarter
Hour
Minute
Month
Now
Quarter
Second
Today
TotalDaysOfMonth
TotalDaysOfQuarter
TotalDaysOfYear
Week
WeekDay
Year
JSON Functions
JSON Functions
JsonExtract
Type Conversion Functions
Type Conversion Functions
Bool
Cast
Date
Int
Json
Text
API Reference
API Reference
Overview
Calling APIs
Authentication and Credentials
Authentication and Credentials
Get Access Credentials
Delete Access Credentials
Get Access Keys by User
User and Tenant Management
User and Tenant Management
Register a User
Update a User
Search Users
Delete a User
Register a Tenant
Enable or Disable Users
Add a User to a Tenant
User Group Management
User Group Management
Create a User Group
Delete a User Group
Update a User Group
Move a User Group
List User Groups
List User Group Members
Add Users to a User Group
Remove Users from a User Group
User Attribute Management
User Attribute Management
Save User Attributes
Delete User Attributes
Query User Attributes
Data Sources
Data Sources
Register a Data Source
Delete a Data Source
Update a Data Source
List Data Sources
Datasets and Relationships
Datasets and Relationships
Create a Dataset
Update a Dataset
List Datasets
Get Dataset Details
Delete a Dataset
Create a Relationship
Update a Relationship
Delete a Relationship
Dimension Management
Dimension Management
Create a Dimension
Update Dimension
Delete Dimension
Get Dimension Details
List Dimensions
Preview Dimension Values
Category Management
Category Management
Create a Category
Update a Category
Delete a Category
List Categories
Metric Management
Metric Management
Create a Metric
Delete Metric
Derived Metric Time Constraint Definition
Update Metric
List Metrics
List Metrics as a Tree
Query Available Dimensions
Query All Available Dimensions
Get Single Metric Details
Get Metric Details in Bulk
Metric Publishing Status State Machine
Query Metric Data
Query Metric Data
Query Metric Data
Query Pivot Table Details
Metric Views
Metric Views
Create a Metric View
Delete Metric View
Update Metric View
List Metric Views
Get Metric View Details
Query Metric View Results
List Metric Views as a Tree
Get Metric View Details by ID
Metric Attribution Analysis
Metric Attribution Analysis
Attribution Metric Breakdown
Multidimensional Attribution by Peer Comparison
Multidimensional Attribution by Time Comparison
Metric Tree Attribution
Metric Attribution Validation
Materialization Acceleration
Materialization Acceleration
External Acceleration Materialization
External Acceleration Materialization
Split Metrics in a Materialization Plan
Create an External Acceleration Plan
Convert Materialized Acceleration to External Acceleration
Query External Plan Reference Script
Update External Acceleration Partition Data
Clear External Acceleration Partition Data
Create a Result Acceleration Plan
Get Result Acceleration Details
Get Result Acceleration Status
Backfill Acceleration Task Data
Data Update
Trigger Source Table Dependencies
Update Acceleration Scheduling Configuration
Query Materialized Table Partitions
List Materialization Plans
Get Materialization Plan Details
Delete a Materialization Plan
Resource and Version Management
Resource and Version Management
Publish Resources
Enable or Disable Resources
Transfer Resources
Permissions
Permissions
Grant Permissions
Update Permissions
Revoke Permissions
Resource Permission Details
Lineage
Lineage
View All Lineage
View Asset Lineage
Overview
Back to top