"Adding and Editing Data" 分类下的文档该分类下有59篇文档创建该分类下的文档
Data Editing Overview
文档创建者:Nicola-徐偲妤      创建时间:03-31 16:19      标签:      编辑:5次    |   浏览:1339次

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

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

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

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

摘要: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次    |   浏览:9830次

摘要: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次    |   浏览:3435次

摘要: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次    |   浏览:16641次

摘要: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次    |   浏览:236次

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

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

摘要: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次    |   浏览:70次

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

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

摘要: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次    |   浏览:375次

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

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

摘要: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次    |   浏览:1273次

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

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

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

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

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

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

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

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

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

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

摘要: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次    |   浏览:813次

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

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

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

Proportion Analysis for Multiple Indicators
文档创建者:Lily.Wang      创建时间:05-11 11:19      标签:      编辑:19次    |   浏览:9799次

摘要:OverviewExpected EffectPlace different indicators on the same pie chart to display their percentages.[阅读全文:]

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

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

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

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

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

摘要: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次    |   浏览:7012次

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

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

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

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

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

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

摘要: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次    |   浏览:6002次

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

[Analysis Subject] Data Overview
文档创建者:Roxy      创建时间:05-14 15:12      标签:      编辑:40次    |   浏览:83862次

摘要:OverviewBefore conducting data analysis, business users need to create analysis subjects in which the[阅读全文:]

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

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

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

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

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

摘要: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次    |   浏览:6308次

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

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

摘要: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次    |   浏览:6076次

摘要: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次    |   浏览:259次

摘要: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次    |   浏览:8316次

摘要: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次    |   浏览:3479次

摘要: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次    |   浏览:5264次

摘要: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次    |   浏览:6269次

摘要: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次    |   浏览:7930次

摘要: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次    |   浏览:7019次

摘要: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次    |   浏览:10304次

摘要: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次    |   浏览:643次

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

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

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

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

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

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

摘要: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次    |   浏览:396次

摘要: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次    |   浏览:345次

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

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

摘要: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次    |   浏览:5468次

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

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

摘要: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次    |   浏览:22274次

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

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

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

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

摘要: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次    |   浏览:427次

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

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

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

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

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