"Adding and Editing Data" 分类下的文档该分类下有62篇文档创建该分类下的文档
Difference in Empty Value Handling Between FineBI 6.1 and 6.0
文档创建者:帆软用户yBn24yxsvz      创建时间:04-07 10:48      标签:      编辑:1次    |   浏览:6次

摘要:OverviewThe main differences between FineBI 6.1 and 6.0 lie in the handling of Null, empty strings (&[阅读全文:]

Data Matching/Query
文档创建者:Roxy      创建时间:04-28 20:01      标签:      编辑:7次    |   浏览:9522次

摘要:OverviewApplication ScenarioDuring data processing, when data is scattered across multiple data table[阅读全文:]

[Learning Path of Data Editing]
文档创建者:Roxy      创建时间:05-14 15:12      标签:      编辑:42次    |   浏览:84408次

摘要:OverviewDuring data processing, you often first import data, then clean the data, adjust the data str[阅读全文:]

Calling Data Extracted Across Subjects
文档创建者:Lily.Wang      创建时间:09-03 15:29      标签:      编辑:15次    |   浏览:18206次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.1.2Added the control parameter SystemOptimization[阅读全文:]

Data Source Switchover for Analysis Subjects
文档创建者:_189594      创建时间:12-18 21:11      标签:      编辑:1次    |   浏览:330次

摘要:OverviewVersionFineBI VersionFunctional Change6 .1/6.1.4Before: Lacked field matching steps for sourc[阅读全文:]

Data Editing Overview
文档创建者:Nicola-徐偲妤      创建时间:03-31 16:19      标签:      编辑:5次    |   浏览:2251次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Optimized the data editing page and added func[阅读全文:]

Data Management
文档创建者:Penny.Kong-孔蓬琳      创建时间:03-24 09:56      标签:      编辑:7次    |   浏览:1324次

摘要:OverviewVersionFineBI VersionFunctional Change6.0-6.0.2Enabled the system to automatically redirect y[阅读全文:]

Data Volume Description
文档创建者:frenadmin1234      创建时间:05-06 14:54      标签:      编辑:13次    |   浏览:1083次

摘要:OverviewVersionFineBI VersionFunctional Change6.0-6.0.2Changed the logic of simplest tables. For[阅读全文:]

Relavant Issues of Special Characters During Data Editing
文档创建者:Roxy      创建时间:07-08 11:13      标签:      编辑:6次    |   浏览:10021次

摘要:OverviewDescriptionAfter you use special characters during data editing, some functions are unable to[阅读全文:]

Field Missing Solutions and Field Name Passing Rules
文档创建者:Lily.Wang      创建时间:05-08 11:43      标签:      编辑:6次    |   浏览:3619次

摘要:Field Missing and Error Reporting in DatasetDescriptionYou may encounter an error indicating that the[阅读全文:]

Subject Model Merging Principle
文档创建者:Lily.Wang      创建时间:02-18 16:36      标签:      编辑:9次    |   浏览:16854次

摘要:OverviewAfter learning this document, you will grasp the most important merging logic of subject mode[阅读全文:]

Common Errors During Data Editing
文档创建者:Lily.Wang      创建时间:06-13 10:41      标签:      编辑:1次    |   浏览:368次

摘要:Self-Service Dataset Editing Permission Being RevokedDescriptionA prompt "The dataset editing pe[阅读全文:]

Model View Overview and Construction Method
文档创建者:Haley      创建时间:05-08 10:22      标签:      编辑:2次    |   浏览:1853次

摘要:OverviewVersionFineBI VersionFunctional Change6.0.8/6.0.10Supported the auto-selection of recommended[阅读全文:]

Data Integrity Insurance of the Subject Model
文档创建者:Ethan.Chen-陈维泰      创建时间:06-12 16:21      标签:      编辑:2次    |   浏览:254次

摘要:OverviewApplication ScenarioIn the Join operation, you manually select Left Join, Right Join, Full Jo[阅读全文:]

Subject Model Advantage
文档创建者:Haley      创建时间:04-14 14:13      标签:      编辑:4次    |   浏览:384次

摘要:OverviewAfter learning the subject model's principles, you may discover its advantages.This docum[阅读全文:]

Official Recommendation for Subject Model Usage
文档创建者:mt6666      创建时间:07-14 15:49      标签:      编辑:1次    |   浏览:1233次

摘要:OverviewThis document introduces the model structures recommended by FineBI.Recommended Model Structu[阅读全文:]

Getting Started with a Simple Example
文档创建者:mt6666      创建时间:07-14 15:43      标签:      编辑:1次    |   浏览:849次

摘要:OverviewThe subject model helps simplify multi-table analysis in FineBI to improve analysis efficienc[阅读全文:]

Adding Data of the Current Project
文档创建者:Penny.Kong-孔蓬琳      创建时间:03-20 15:18      标签:      编辑:5次    |   浏览:1977次

摘要:OverviewApplication ScenarioEnterprises are generally business users, and data that business users ne[阅读全文:]

Adding a Condition Label Column
文档创建者:Julia.Hu-胡佳涵      创建时间:04-28 10:11      标签:      编辑:2次    |   浏览:1493次

摘要:OverviewVersionVersionFunctional Change6.0.5/Application ScenarioCondition Label Column allows y[阅读全文:]

Changing Columns to Rows (Reverse Data Pivot)
文档创建者:Haley      创建时间:03-28 18:32      标签:      编辑:1次    |   浏览:896次

摘要:OverviewVersionFineBI VersionFunctional Change6.0.3/Expected EffectColumn to Row refers to converting[阅读全文:]

Deleting Duplicate Data
文档创建者:Haley      创建时间:03-31 09:49      标签:      编辑:1次    |   浏览:982次

摘要:OverviewVersionFineBI VersionFunctional Change6.0.7/Application ScenarioScenario One: Handling Dirty[阅读全文:]

Displaying Characters Corresponding to Numeric Codes
文档创建者:Roxy      创建时间:10-13 14:58      标签:      编辑:10次    |   浏览:5088次

摘要:OverviewExpected EffectSometimes you need to display the text character corresponding to the value fi[阅读全文:]

Converting Field Types
文档创建者:Roxy      创建时间:10-14 11:01      标签:      编辑:14次    |   浏览:9768次

摘要:OverviewExpected EffectSometimes you need to convert the text field to the value field. For example,[阅读全文:]

Adding a Formula Column
文档创建者:Julia.Hu-胡佳涵      创建时间:03-23 15:41      标签:      编辑:2次    |   浏览:1484次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Added the entry to, and changed the name of&nb[阅读全文:]

Join
文档创建者:Penny.Kong-孔蓬琳      创建时间:03-31 10:04      标签:      编辑:7次    |   浏览:2472次

摘要:OverviewVersionFineBI VersionFunctional ChangeV6.0Optimized the logic of Join in Permission Inhe[阅读全文:]

Splitting Rows and Columns
文档创建者:Penny.Kong-孔蓬琳      创建时间:03-31 18:02      标签:      编辑:3次    |   浏览:1469次

摘要:OverviewVersionFineBI VersionFunctional ChangeV6.0.6/Application ScenarioWhen you edit data, you can[阅读全文:]

Handling Match Failure in Join
文档创建者:Lily.Wang      创建时间:07-15 15:52      标签:      编辑:6次    |   浏览:4191次

摘要:OverviewBackgroundWhen you perform Join, if the merge basis fields of the two tables are different, t[阅读全文:]

Data Editing Use Guide
文档创建者:doreen0813      创建时间:04-16 19:30      标签:      编辑:85次    |   浏览:64483次

摘要:OverviewOn FineBI's data editing page, you can quickly perform operations such as data cleaning,[阅读全文:]

Fuzzy Search of Text Fields
文档创建者:Lily.Wang      创建时间:06-23 14:42      标签:      编辑:4次    |   浏览:7350次

摘要:OverviewDuring fuzzy search (different from exact search), the search system automatically retrieves[阅读全文:]

Union All
文档创建者:doreen0813      创建时间:04-17 16:32      标签:      编辑:28次    |   浏览:953518次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/Application ScenarioIf you perform Union All ([阅读全文:]

Adding an Assignment Column
文档创建者:Lily.Wang      创建时间:07-28 16:51      标签:      编辑:13次    |   浏览:6120次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Changed Add Column > Group Assignment [阅读全文:]

Filter
文档创建者:doreen0813      创建时间:04-17 14:23      标签:      编辑:33次    |   浏览:40720次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Allowed you to filter data through table heade[阅读全文:]

Adding a Summary Column
文档创建者:Lily.Wang      创建时间:08-02 11:40      标签:      编辑:7次    |   浏览:6449次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Changed Add Column > Summary Value to Summa[阅读全文:]

Getting Time
文档创建者:Lily.Wang      创建时间:07-23 17:33      标签:      编辑:4次    |   浏览:4663次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Optimized the name and entry of getting time.O[阅读全文:]

Time Interval
文档创建者:Lily.Wang      创建时间:07-23 16:14      标签:      编辑:8次    |   浏览:4650次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Changed the time interval name and entry.Optim[阅读全文:]

Merging Tables
文档创建者:April陶      创建时间:08-11 10:03      标签:      编辑:11次    |   浏览:6225次

摘要:OverviewApplication ScenariosMerging tables is to merge several different but associated tables into[阅读全文:]

Combining Multiple Indicators into Another Category
文档创建者:Lily.Wang      创建时间:05-09 12:01      标签:      编辑:15次    |   浏览:6484次

摘要:OverviewPreviewThis document introduces how to calculate the proportions of the top few indicators an[阅读全文:]

Calculating the Mode
文档创建者:April陶      创建时间:09-18 15:07      标签:      编辑:5次    |   浏览:6477次

摘要:OverviewPreviewYou may need to calculate the mode occurrence number of the consumption amount to eval[阅读全文:]

Splicing Different Texts in the Same Column
文档创建者:Roxy      创建时间:11-13 17:10      标签:      编辑:4次    |   浏览:6229次

摘要:OverviewPreviewThis document introduces how to splice different texts in the same column and separate[阅读全文:]

Replacing the Data of a Specified Column
文档创建者:用户y1180505      创建时间:06-26 14:41      标签:      编辑:2次    |   浏览:449次

摘要:OverviewRequirement DescriptionYou may need to replace a certain field after creating several compone[阅读全文:]

Extracting Data from One of Two Time Columns
文档创建者:doreen0813      创建时间:01-22 17:25      标签:      编辑:18次    |   浏览:8520次

摘要:OverviewApplication ScenariosScenario description: In the sample data Resume Table, some employees on[阅读全文:]

Calculating the Time Field N Hours/Minutes/Seconds After a Specified Time
文档创建者:zsh331      创建时间:03-30 15:40      标签:      编辑:9次    |   浏览:3828次

摘要:OverviewRequirement DescriptionDate functions are widely used in work and life, and so are the adding[阅读全文:]

Determining Whether a Date Field Is Within a Specified Period
文档创建者:Roxy      创建时间:10-16 16:58      标签:      编辑:10次    |   浏览:5459次

摘要:OverviewPreviewYou may need to determine whether a time field is within a specified period. For examp[阅读全文:]

Calculating the Number of Workdays Between Two Dates
文档创建者:Lily.Wang      创建时间:02-05 18:18      标签:      编辑:8次    |   浏览:6543次

摘要:OverviewPreviewYou may need to calculate the number of workdays between the start time and the end ti[阅读全文:]

Dynamic Time Display
文档创建者:Roxy      创建时间:12-04 16:00      标签:      编辑:7次    |   浏览:8224次

摘要:OverviewYou may need to display the current time or the number of days to go until a countdown date.P[阅读全文:]

Calculating the Last Day of each Month
文档创建者:Roxy      创建时间:10-16 17:16      标签:      编辑:5次    |   浏览:7411次

摘要:OverviewPreviewYou may need to extract the data of the last day of each month, such as the last day o[阅读全文:]

Time Interval Calculation
文档创建者:Roxy      创建时间:10-16 10:39      标签:      编辑:6次    |   浏览:10633次

摘要:OverviewPreviewYou may need to calculate the interval between two time fields, such as the interval b[阅读全文:]

Column from Other Tables
文档创建者:Haley      创建时间:03-31 10:04      标签:      编辑:3次    |   浏览:1050次

摘要:OverviewVersionFineBI VersionFunctional Change6.0-6.0.5Added the Create Merge Calculation function.6.[阅读全文:]

Changing Rows to Columns
文档创建者:帆软用户KkGsxgKeOS      创建时间:04-28 14:06      标签:      编辑:1次    |   浏览:812次

摘要:OverviewVersionFineBI VersionFunctional Change6.0.3/PreviewThe Row to Column function can change a on[阅读全文:]

Row-to-Column Conversion
文档创建者:doreen0813      创建时间:06-19 16:46      标签:      编辑:41次    |   浏览:32692次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/Application ScenariosThe Row to Column function can[阅读全文:]

Retrieving Data of the Latest Time
文档创建者:Roxy      创建时间:12-21 15:02      标签:      编辑:6次    |   浏览:7882次

摘要:OverviewVersionFineBI Version6.0PreviewYou want to only keep the data with the latest time for the sa[阅读全文:]

Determining Sales Based on a Certain Day's Sales Volume
文档创建者:Haley      创建时间:07-05 16:48      标签:      编辑:0次    |   浏览:650次

摘要:OverviewPreviewView the daily sales compared to the sales of a fixed day based on the sales of a cert[阅读全文:]

Merging Same Values into One Group
文档创建者:Haley      创建时间:07-04 17:11      标签:      编辑:0次    |   浏览:736次

摘要:OverviewFunctionsBusinesses want to compile a list of all customers. However, in the original data, e[阅读全文:]

Dense Ranking
文档创建者:Lily.Wang      创建时间:07-14 17:24      标签:      编辑:5次    |   浏览:8589次

摘要:OverviewPreviewRanking effect: 1 1 1 4 5Dense ranking effect: 1 1 1 2 3How to achieve the effect of d[阅读全文:]

Calculating Cumulative Values Starting from a Specified Time
文档创建者:Roxy      创建时间:12-14 16:43      标签:      编辑:7次    |   浏览:5909次

摘要:OverviewPreviewFor example, calculate cumulative values of contract amounts starting from 2020/06/01.[阅读全文:]

Sorting
文档创建者:doreen0813      创建时间:04-17 15:49      标签:      编辑:16次    |   浏览:19845次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Allowed sorting a column in the table header f[阅读全文:]

Converting Text or Numeric Time Values to Dates
文档创建者:Lily.Wang      创建时间:05-22 16:16      标签:      编辑:25次    |   浏览:23085次

摘要:OverviewApplication ScenarioThere are various formats for you to record time, but some of which are s[阅读全文:]

Group Summary
文档创建者:Haley      创建时间:03-31 13:53      标签:      编辑:3次    |   浏览:2139次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.3Added Group Condition.Application ScenariosFor[阅读全文:]

Overview of Adding Data
文档创建者:Julia.Hu-胡佳涵      创建时间:03-23 15:08      标签:      编辑:5次    |   浏览:1616次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.4Adjusting the order of data tables in the subj[阅读全文:]

Basic Functions of the Added Column
文档创建者:帆软用户KkGsxgKeOS      创建时间:04-28 13:52      标签:      编辑:1次    |   浏览:777次

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.2Added functions to the added column in data ed[阅读全文:]

Field Settings
文档创建者:Julia.Hu-胡佳涵      创建时间:03-22 15:41      标签:      编辑:2次    |   浏览:1128次

摘要:OverviewFor online video learning, see Field Settings.VersionFineBI VersionFunctional Change6.0-6.0.2[阅读全文:]

Adding Excel Data
文档创建者:Julia.Hu-胡佳涵      创建时间:03-22 16:58      标签:      编辑:1次    |   浏览:1934次

摘要:OverviewApplication ScenariosFineBI supports analyzing local Excel tables.FunctionsYou can click My A[阅读全文:]