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 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

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