FineBI Application Document Collection

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 the 

Specified Time

Application to Sorting

Displaying Top N Data Dynamically

Multi-Column Sorting

Tied Rank not Taking up Positions

Displaying the Title Dynamically

Displaying the Title Dynamically

Field Format Conversion

Converting Text or Numeric Time Fields to Date Fields

Converting Text Field to Numeric Field

Displaying the Character Corresponding to the Numeric Code

Setting Data Group and Format

Merging Data Tables

Multi-Index Merging for Proportion Analysis

Left and Right Merge

Application to Filter

Displaying Data for a Period of Time Before and After Filtering 

Component Values Dynamically

Calculating the Number of New Additions Within a Period of Time 

Dynamically

Filtering Data of Work Day

Searching the Maximum Value Within a Period of Time

Filtering Indicator Fields not Appearing in the Table

Filtering Data of Custom Time Period

Row and Column Conversion

Converting Row to Column in Self-service Dataset

Converting Row to Column in Basic Table

Converting Column to Row

Retrieving Data of the Latest Time

Retrieving Data of the Latest Time

Others

Two Ways to View the Data Behind the Chart

Judging Sales Based on a Certain Day's Sales

Grouping and Summarizing to Remove Duplicate Data

External User Analysis

RFM Analysis

ABC Analysis

Conversion Analysis

Shopping Basket Analysis—Association Rules

Retention Analysis

AARRR User Operations Analysis

Customer Inflow and Outflow Analysis

Requirement Analysis Method

Internal Operations Analysis

DuPont Analysis