"Editing Data" 分类下的文档该分类下有43篇文档创建该分类下的文档
Adding a Condition Label Column
文档创建者:Julia.Hu-胡佳涵      创建时间:04-28 10:11      标签:      编辑:2次    |   浏览:575次

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

Changing Columns to Rows
文档创建者:Haley      创建时间:03-28 18:32      标签:      编辑:1次    |   浏览:378次

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

Changing Row to Column in Self-Service Dataset
文档创建者:帆软用户KkGsxgKeOS      创建时间:04-28 14:06      标签:      编辑:1次    |   浏览:344次

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

摘要:OverviewVersionFineBI VersionFunctional Change6.0/Application ScenariosSome datasets may not be suita[阅读全文:]