This document filters, organizes, classifies, and typesets the actual application documents of FineBI, forming a content collection that basically covers various aspects of FineBI's actual use.
The document is classified into different chapters according to the difficulty level and content module.
You can click the title to jump to the corresponding article.
Updating...
Linkage
Linkage Settings Between Components
Clearing the Linkage Effect
Canceling the Linkage Settings Between Components
Jump
Component Jump Introduction
Drilling
Data Drilling for Common Fields
Sorting
Sorting Overview
Filter
Dashboard Filter Introduction
Basic Functions of Filter Component
Calculating Proportion
Proportion Introduction
Calculating YoY and MoM
YoY and MoM Introduction
Chart
How to Select the Right Chart
Data Cleaning & Integration & Calculation
Overview of Data Cleaning & Integration
Function Introduction
Getting Started with Calculation
Selecting Calculation Type
Function Calculation Format
Common Questions/Common Formula Combinations
FAQs of Common Function Syntax
Common Date Formula
Important Functions
Using the IF Function for Data Processing
Overview of Aggregate Functions
Overview of Quick Calculation Functions
Data Cleaning
Text character processing
Special Character Processing
Infinity/Negative/Null Values Displayed as 0
Removing Certain Characters from a String
Searching Duplicate Data in Different Column Fields
Date data processing
Counting the Number of Occurrences of a Character in a Field
Checking If a Field Contains a String
Regular Expression Example
Data Integration
Truncating/concatenating characters
Data Merging/Truncation/Splitting
Data Matching and Searching
Concatenating Data from Different Columns
Truncating the Content After Specified Characters
Appearing Multiple Times
Grouping and assigning values
Grouping by Time Interval
Assigning Values Based on Multiple Conditions
Data Calculation
Calculation and statistics
Conditional Sum and Count
Marking serial number
Adding Serial Numbers to a Table
Mean/Mode calculation
Calculating the Average of the Previous N Days/ Under Non-Unique Data Conditions
Calculating the Cumulative Average
Cumulative value calculation
Calculating Cumulative Values Starting from a Specified Time
Application to Sorting
Displaying the Top N Dynamically
Multi-Column Sorting
Dense Ranking
Displaying the Title Dynamically
Displaying Title Dynamically
Field Format Conversion
Converting Text or Numeric Time Values to Dates
Converting Field Types
Displaying Characters Corresponding to Numbers
Setting Data Group and Format
Merging Data Tables
Proportion Analysis for Multiple Indicators
Left and Right Merge
Application to Filter
Dynamically Displaying Data for a Time Period Before & After Filtering Component
Dynamically Calculating the Number of New Additions Within a Certain Time Period
Filtering Data of Working Days
Searching the Maximum Value Within a Certain Time Period
Filtering Indicator Fields not Appearing in the Table
Dynamically Filtering Data Through Binding the Parameter in Field Filter
Row and Column Conversion
Changing Row to Column in Self-Service Dataset
Changing Row to Column in Base Table
Changing Column to Row
Retrieving Data of the Latest Time
Others
Two Ways of Viewing Data Behind a Chart
Determining Sales Based on a Certain Day's Sales Volume
Merging Same Values into One Group
External User Analysis
RFM Analysis
ABC Analysis
Retention Analysis
Market Basket Analysis
Conversion Analysis
AARRR User Operation Analysis
Customer Inflow and Outflow Analysis
Demand Analysis — KANO Model
Internal Operations Analysis
DuPont Analysis
滑鼠選中內容，快速回饋問題
滑鼠選中存在疑惑的內容，即可快速回饋問題，我們將會跟進處理。
不再提示
10s後關閉
Submitted successfully
Network busy