"Data Processing" Doc in this DirectoryThere are 47 docs under this directory.Create a Doc in this Directory
Upload Field Types That Are Correctly Recognized By Excel
Author:doreen0813      Create Time:09-06 15:03      Tag:      Edit:8 Times    |   View:463 Times

Summary:1 OverviewFineBI supports add EXCEL dataset , users can upload csv , xls, xlsx three f[Full Text:]

Date n(h/min/sec) after the specified date
Author:zsh331      Create Time:03-30 15:40      Tag:      Edit:9 Times    |   View:473 Times

Summary:1.Overview1.1 Problem descriptionDate function is widely used in daily work and life. It is particula[Full Text:]

Number of working days between two dates
Author:Lily.Wang      Create Time:02-05 18:18      Tag:      Edit:8 Times    |   View:434 Times

Summary:1. Overview1.1. Expected effectA group of interns came to the company, and their wages were settled a[Full Text:]

Display time in dynamic
Author:Roxy      Create Time:12-04 16:00      Tag:      Edit:6 Times    |   View:446 Times

Summary:1. OverviewUsers sometimes need to show "how long is the current time before a certain target ti[Full Text:]

Share and collaborate self-service dataset
Author:Roxy      Create Time:08-03 09:12      Tag:      Edit:25 Times    |   View:563 Times

Summary:1. Overview1.1 VersionFineBI versionJAR packageFunction changes5.1.52020-08-04-5.1.72020-11-03Add a l[Full Text:]

Multiple indicators combined for percentage analysis
Author:Lily.Wang      Create Time:05-11 11:19      Tag:      Edit:14 Times    |   View:482 Times

Summary:1. Overview1.1 Expected effectPlace different indicators on the same pie chart to show the percentage[Full Text:]

Take one of the two time data columns
Author:doreen0813      Create Time:01-22 17:25      Tag:      Edit:17 Times    |   View:414 Times

Summary:1.DescriptionScenario description: In the personnel resume table, there is possibility that employees[Full Text:]

Difference between self-service dataset of processing and analyzing property
Author:Roxy      Create Time:04-23 15:59      Tag:      Edit:27 Times    |   View:502 Times

Summary:1 Overview1.1 ConceptSelf-service dataset referst to processed tables. Users can create self-service[Full Text:]

Merging data tables with multi-to-multi relationships
Author:susie      Create Time:07-03 16:02      Tag:      Edit:9 Times    |   View:375 Times

Summary:1.  Overview1.1 Problem descriptionThe user has two data tables "FRDemo_PersonnelAlteration[Full Text:]

Permission Inheritance
Author:doreen0813      Create Time:02-13 16:49      Tag:      Edit:35 Times    |   View:587 Times

Summary:1. Overview1.1 VersionFineBI versionJAR package versionFunction changes5.12020-01-15-5.1.52020-09-02P[Full Text:]

Field settings
Author:doreen0813      Create Time:04-17 15:40      Tag:      Edit:25 Times    |   View:875 Times

Summary:1. Overview1.1 VersionFineBI versionFunction changes5.1-5.1.11Added the function of adjusting the fie[Full Text:]

Volume limit of self-service dataset
Author:Roxy      Create Time:11-12 13:59      Tag:      Edit:24 Times    |   View:1361 Times

Summary:1. Overview1.1 VersionFineBI versionJAR package5.12020-01-151.2 Reason for the volume limit of datase[Full Text:]

Basic functions of new column
Author:doreen0813      Create Time:04-17 15:30      Tag:      Edit:30 Times    |   View:824 Times

Summary:1.Overview1.1 VersionFineBI versionJAR package versionfunction changes5.1--5.1.52020-09-02The group b[Full Text:]

Multi-table merge/statistical scenario
Author:susie      Create Time:07-02 17:36      Tag:      Edit:8 Times    |   View:446 Times

Summary:1.Overview1.1 Application scenarioThere are four tables A, B, C, D, where table A is associated with[Full Text:]

Basic functions of left and right merge
Author:doreen0813      Create Time:04-17 16:20      Tag:      Edit:52 Times    |   View:827 Times

Summary:1. Overview1.1 VersionFineBI versionJAR package versionfunction changes5.1--5.1.52020-09-02left and r[Full Text:]

Basic functions of filter
Author:doreen0813      Create Time:04-17 14:23      Tag:      Edit:31 Times    |   View:984 Times

Summary:1. Overview1.1 VersionFineBI versionFunction changes5.1-5.1.14When setting "in/not in" cond[Full Text:]

Splice different text in one column of data
Author:Roxy      Create Time:11-13 17:10      Tag:      Edit:5 Times    |   View:403 Times

Summary:1. Overview1.1 Expected effectThe user needs to stitch together different pieces of text in a column[Full Text:]

Basic functions of group summary
Author:doreen0813      Create Time:04-17 14:49      Tag:      Edit:44 Times    |   View:734 Times

Summary:1. Overview1.1 VersionFineBI VersionJARFunction changes5.1--2020-08-04Remove copy-to-group feature fr[Full Text:]

Judge sales based on a particular day
Author:Lily.Wang      Create Time:06-12 14:33      Tag:      Edit:8 Times    |   View:394 Times

Summary:1. Overview1.1 Expected effectSee how daily sales compare to a fixed date, using a particular day&#39[Full Text:]

Self-service dataset of analyzing property
Author:doreen0813      Create Time:04-16 16:21      Tag:      Edit:58 Times    |   View:652 Times

Summary:1.Overview1.1 VersionFineBI VersionJAR package versionfunction changes  5.12020-01-15Delete quic[Full Text:]

Tied rankings without occupancy
Author:Lily.Wang      Create Time:07-14 17:24      Tag:      Edit:6 Times    |   View:409 Times

Summary:1. Overview1.1 Expected effectsThe effect of tied rankings with occupancy: 1 1 1 4 5The effect of tie[Full Text:]

Manage self-service dataset
Author:doreen0813      Create Time:04-16 17:43      Tag:      Edit:47 Times    |   View:519 Times

Summary:1. OverviewFor video learning, see: self service dataset operation.1.1 VersionsFineBI versionJAR vers[Full Text:]

Self-service dataset of processing property
Author:doreen0813      Create Time:04-16 11:43      Tag:      Edit:60 Times    |   View:566 Times

Summary:1.OverviewFor online video learning of self-service dataset, please click: Introduction to self-servi[Full Text:]

Create self-service dataset
Author:doreen0813      Create Time:04-16 19:30      Tag:      Edit:68 Times    |   View:1336 Times

Summary:1.Overview1.1 VersionFineBI VersionJAR packagefunction variation5.12020-01-15-5.1.102021-02-05For the[Full Text:]

Self-service dataset overview
Author:Roxy      Create Time:05-14 15:12      Tag:      Edit:36 Times    |   View:1243 Times

Summary:1.OverviewSelf-service dataset refers to tables obtained by users after conducting self-service analy[Full Text:]

Suggestions for using self-service dataset
Author:Lily.Wang      Create Time:12-04 17:42      Tag:      Edit:5 Times    |   View:436 Times

Summary:1. OverviewWhen using a self-service dataset, some operations can affect the performance of the self-[Full Text:]

A date is within a specified time period
Author:Roxy      Create Time:10-16 16:58      Tag:      Edit:9 Times    |   View:361 Times

Summary:1.Overview1.1 Expected EffectUsers sometimes need to determine whether a time field is within a speci[Full Text:]

Field loss and delivery rules
Author:Lily.Wang      Create Time:05-08 11:43      Tag:      Edit:7 Times    |   View:380 Times

Summary:1. The field in the self-service dataset is missing and an error is reported1.1 ProblemSometimes[Full Text:]

Displays characters to numeric codes
Author:Roxy      Create Time:10-13 14:58      Tag:      Edit:7 Times    |   View:338 Times

Summary:1. Overview1.1 Expected EffectSometimes users need to display the "text" character correspo[Full Text:]

Time Function Handling Null Values
Author:Lily.Wang      Create Time:09-02 15:14      Tag:      Edit:5 Times    |   View:368 Times

Summary:1. Overview1.1 Problem DescriptionIf there is a null value in the time field or the time format is in[Full Text:]

Convert year-month-day date format to year-month
Author:April陶      Create Time:09-28 16:53      Tag:      Edit:10 Times    |   View:553 Times

Summary:1. Overview1.1 Expected effectThe effect of converting the year-month-day date format to month is sho[Full Text:]

Calculate the mode
Author:April陶      Create Time:09-18 15:07      Tag:      Edit:5 Times    |   View:470 Times

Summary:1. Overview1.1 Expected effectCalculate the mode of the user's consumption amount in the data, an[Full Text:]

Take the last day of the month under the current date
Author:Roxy      Create Time:10-16 17:16      Tag:      Edit:6 Times    |   View:476 Times

Summary:1 Overview1.1 Expected effectSometimes users need to get the data of the last day of each month.&nbsp[Full Text:]

Group summary to achieve de-duplication
Author:Lily.Wang      Create Time:05-28 15:48      Tag:      Edit:3 Times    |   View:523 Times

Summary:1. Overview1.1 Expected effectThe merchant wants to make a list of all users who consume, but in the[Full Text:]

Questions about special characters in self-service dataset
Author:Roxy      Create Time:07-08 11:13      Tag:      Edit:9 Times    |   View:415 Times

Summary:1. Overview1.1 Problem phenomenonAfter the user uses some special characters in the self-service data[Full Text:]

Get the latest time data
Author:Roxy      Create Time:12-21 15:02      Tag:      Edit:6 Times    |   View:417 Times

Summary:1 Overview1.1 VersionFineBI version5.11.2 Expected effectWith the information of the same store ID, t[Full Text:]

Calculate time difference
Author:Roxy      Create Time:10-16 10:39      Tag:      Edit:5 Times    |   View:556 Times

Summary:1 Overview1.1 Expected effectSometimes users need to calculate time difference between two time data.[Full Text:]

Merge multiple indicators into other categories
Author:Lily.Wang      Create Time:05-09 12:01      Tag:      Edit:15 Times    |   View:384 Times

Summary:1. Overview1.1 Expected effectWhen making statistics, you can focus on caculating respective proporti[Full Text:]

Calculate the cumulative value from the specified time
Author:Roxy      Create Time:12-14 16:43      Tag:      Edit:6 Times    |   View:418 Times

Summary:1. Overview1.1 Expected effectFor example, using 2014-01-01 as the starting time, calculate the &quot[Full Text:]

Display volume of the self-service dataset
Author:Roxy      Create Time:05-14 15:16      Tag:      Edit:10 Times    |   View:619 Times

Summary:1. Overview1.1 VersionFineBI versionFunction changes5.1-1.2 Problem descriptionSometimes users may se[Full Text:]

Converts text or numeric time values to date format
Author:Lily.Wang      Create Time:05-22 16:16      Tag:      Edit:20 Times    |   View:554 Times

Summary:1. Overview1.1 Problem descriptionUsers record time in a variety of formats, some store it as a text[Full Text:]

Field type conversion
Author:Roxy      Create Time:10-14 11:01      Tag:      Edit:6 Times    |   View:381 Times

Summary:1. Overview1.1 Expected effectSometimes users need to convert a "text" field to a "val[Full Text:]

筛除数据场景拓展
Author:Lily.Wang      Create Time:11-30 18:12      Tag:      Edit:1 Times    |   View:377 Times

Summary:1. 概述在实际的分析中,我们经常需要过滤排除掉一部分数据。当需要剔除的数据需要使用多个字段作且条件进行筛选时,就无法直接使用 FineBI 自带的过滤功能。例如,要剔除「省份为湖南」且「类别为办公用品[Full Text:]

文本字段模糊查询
Author:Lily.Wang      Create Time:06-23 14:42      Tag:      Edit:0 Times    |   View:816 Times

Summary:1. 概述模糊查询区别于精确搜索,搜索系统自动按照用户输入关键词对文本类型的字段进行检索,得到某个范围内的值。用户可以在自助数据集或组件处中进行模糊过滤查询:自助数据集过滤:过滤基础功能组件过滤:图表过[Full Text:]