Skip to content

Main NavigationDocumentation API Release notes

Appearance

Sidebar Navigation

Welcome

Start

Datafor Overview

Basic Operations for Report Design

Create Your First Analysis Report

Setup

Installation Guide (CentOS)

Installation Guide (Ubuntu)

Installation (Windows)

Deploying Datafor Using Docker

Repository Separation Deployment Guide

Console

Quick Tour of the Console

My Account

Datasource

Supported Databases (Data Sources)

JDBC Driver Management

Configuring MySQL Data Source

File Dataset

Data Security (Row‑Level & Object‑Level)

Model

Creating an Analysis Model

Establishing Table Relationships

Creating Hierarchy

Calculated Field

50 sql建模

Visualization

Charts

Measure

Dimension Value

Clustered Column

Stacked Column

100% Stacked Column

Clustered Bar

Stacked Bar

100% Stacked Bar

Line

Combo

Stacked Ratio

Stacked Area

Pie

Grouped Donut

Scatter Plot

Word Cloud

Radar

Sankey

Calendar

Treemap

Progress

Bullet

Waterfall

Image

Range Column

Tables

Table

Pivot Table

Hierarchy Table

Maps

GIS Map Settings

Marker Map

GeoJSON marked map

GeoJSON Filled Map

Image Map

Filters

Filters

List Box

Number Range Filter

Datepicker and Datepicker Range

Assists

Tabs

Image

Line

Text

Text Box

Ellipse

Rectangle

Report Page Size and Display Settings

Add Charts

Mobile Layout View

Filter Subscriptions for Charts

Multi-Tabbed Page

Tooltips

X Axis Type Settings - Continuous and Categorical

Conditional Colors

Parameter-Driven Tab Switching

Export

Analysis

Exploratory Analysis

Creating Parameters

Aggregation for Measures

Quick Calculated Measures

Chart Reference Lines

What-if Analysis

Using Parameters in Component Titles

Using Parameters in Calculated Measures

Show Items with No Data

Lineage Analysis

Relative Date Filtering

Component-Level Filtering

Cross-Filtering

Drill down

Drill through

Sorting

Cross-Model and Cross-Data Source Analysis

Calculated Measures

Top/Bottom N

AI Agent

How to Enable the AI Feature

LLM Configuration

Insight Component

Preparing Data for AI

LLM Permission Management

Embedded

Share Link

Reports REST API

White Label

Pass parameters through URL

Embedding Reports Using XDM

Tools

Data Dictionary

GeoJSON Map

System

User Creation and User Types

JSON Web Token (JWT)

Modify Password

Backup and Restore

Mail Server Configuration

LDAP

OAuth2 Authentication

SAML2 Authentication

CAS Authentication

Access Control List

FAQs

Time Axis

Advanced

MDX Functions

Best Practices

Performance Tuning

Increasing Memory Limit for Datafor Server

Filter by last date in the cube

Security & Compliance

Subscription Agreement (North America/LatAm/APAC)

Privacy Policy

Service Level Agreement (SLA)

On this page

Home
Model
50 sql建模

50 sql建模

About 19 wordsLess than 1 minute

2025-12-09

sql建模

Previous pageCalculated Field

Next pageMeasure

Datafor Documentation

Copyright ©2025 Datafor All rights reserved.