摘要:OverviewVersionFineBI VersionFunctional Change6.0/Application ScenarioData drilling allows you to gra[阅读全文:]

摘要:OverviewExpected EffectYou can use the Count function to count a dimension field by another spec[阅读全文:]

摘要:OverviewApplication ScenarioIn some cases, you need to count the distinct count of a dimension field[阅读全文:]

摘要:OverviewWhen tables from any data source are accessed in FineBI, the data types of the accessed data[阅读全文:]

摘要:OverviewDuring the base table processing, the data tables connected to FineBI have been cleaned basic[阅读全文:]

摘要:BackgroundIn daily work, you can hold various types of meetings, such as weekly meetings and project[阅读全文:]

摘要:OverviewExpected EffectThis document takes the Store Dimension table as an example to calculate[阅读全文:]

摘要:OverviewVersionVersionApplication Scenario6.0-Application ScenarioFineBI allows you to jump from the[阅读全文:]

摘要:OverviewProblemAnalysis functions (for example, the WINDOW function) can only be output and used dire[阅读全文:]

摘要:OverviewDuring data processing, you may want to calculate the time interval between the dates of the[阅读全文:]

摘要:OverviewApplication ScenarioIn most cases, you need to display the result of data analysis by charts.[阅读全文:]

摘要:OverviewAfter uploading and processing the data, you may need to visualize the data table and create[阅读全文:]

摘要:OverviewAfter processing the data, you need to use tables and charts to display all the data in detai[阅读全文:]

摘要:OverviewExpected EffectYou can use StringCat function in BI to combine character strings, for example[阅读全文:]

摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.1.4The PERCENTILE_AGG() function is supported for[阅读全文:]

摘要:OverviewSyntaxParameter  MONTHDELTA(date,delta)delta This function returns the date se[阅读全文:]

摘要:OverviewApplication ScenarioAbundant built-in functions are provided in FineBI, which are sufficient[阅读全文:]

摘要:OverviewBackgroundTime moving average is a commonly used data smoothing method, which filters out sho[阅读全文:]

摘要:OverviewCOUNT_AGG function is used to perform distinct count (not empty) for the specified dimension[阅读全文:]

摘要:OverviewCOUNT_AGG function is used to perform distinct count (not empty) for the specified dimension[阅读全文:]

摘要:OverviewSyntaxMEDIAN_AGG(Array)According to the current analysis dimension, this function returns the[阅读全文:]

摘要:OverviewSyntaxVAR_AGG(Array)According to the current analysis dimension, this function dynamically re[阅读全文:]

摘要:OverviewSyntaxMIN_AGG(Array)According to the current analysis dimension, this function returns the mi[阅读全文:]

摘要:OverviewSyntaxSUM_AGG(Array)According to the current analysis dimension, this function returns the st[阅读全文:]

摘要:Overview1. Function DefinitionThe SWITCH function can make judgements on multiple conditions and retu[阅读全文:]

摘要:OverviewConceptDuPont analysis uses the relationship between key financial ratios to comprehensively[阅读全文:]

摘要:OverviewSyntaxAVG_AGG(Array)Returns the summary average value of the indicator field based on the cur[阅读全文:]

摘要:OverviewDefinitionMarket basket analysis is an analysis method that associates two different products[阅读全文:]

摘要:OverviewIf any parameter logical value is TRUE, the function will return TRUE. Only when all paramete[阅读全文:]

摘要:OverviewSyntaxWINDOW_SUM(Indicator,[Grouping field 1,Grouping field 2,...],[Sorting field 1,Sorting m[阅读全文:]

摘要:OverviewSyntaxWINDOW_AVG(Indicator,[Grouping field 1,Grouping field 2,...],[Sorting field 1,Sorting m[阅读全文:]

摘要:OverviewSyntaxMAX_AGG(Array)According to the current analysis dimension, this function returns the ma[阅读全文:]

摘要:Extracted DataOverviewSyntaxWEEK(Serial_number,"F1") or WEEK(Serial_number,"F7")R[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxTODATE()Converts parameters in various date formats to date type.2. No[阅读全文:]

摘要:OverviewWhen dealing with date-type data, you often need to perform operations such as getting the cu[阅读全文:]

摘要:Extracted DataOverviewSyntaxDATEDIF(Start_date,End_date,Unit)Returns the number of days, months, or y[阅读全文:]

摘要:OverviewFineBI supports various functions. These functions have some differences in usage compared to[阅读全文:]

摘要:OverviewApplication ScenarioThe IF function is a commonly used logical function for data processing a[阅读全文:]

摘要:PositionPositionUsage ScopeEditing dataAdding a column and filteringNumeric fields (Some functions al[阅读全文:]

摘要:Usage ScopePositionEditing dataAdding a column and filteringComponentAdding a calculation fieldNote:F[阅读全文:]

摘要:OverviewSyntaxDATESUBDATE(Date1,Date2,Op)Returns the time interval between two dates.Parameter 1Date1[阅读全文:]

摘要:Usage ScopePositionEditing DataAdding a column and filteringComponentAdding a calculation fieldFuncti[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxDATETONUMBER(Date)Returns the number of milliseconds from January 1, 1[阅读全文:]

摘要:OverviewSyntaxDAYS360(Start_date,End_date,Method)Returns the number of days between two dates based o[阅读全文:]

摘要:OverviewSyntaxDAY(Serial_number,Format)Returns the day of a date. The returned value is an integer ra[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxINT(Number)Rounds a number down to the nearest integer.ParameterNumber[阅读全文:]

摘要:OverviewWhen processing data, regular expressions are often used to describe certain string-matching[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxMONTH(Serial_number,Format)Returns the month of a date. The returned v[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxMINUTE(Serial_number,Format)Returns the minute of a specified time. Th[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxHOUR(Serial_number,Format)Returns the hour of a specified time value.[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxDAYSOFQUARTER(Date)Returns the number of days of a certain quarter in[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxDATEDELTA(Date,Deltadays)Returns the date that is deltadays after the[阅读全文:]

摘要:OverviewYou can click Save Dashboard As to view the internal steps or operate the steps by yourself.E[阅读全文:]

摘要:OverviewSyntaxDAYSOFYEAR(Year)Returns the number of days a certain year contains.ParameterYearAny yea[阅读全文:]

摘要:OverviewSyntaxDAYVALUE(Date)Returns the number of days from the year 1900 to the specified date.Param[阅读全文:]

摘要:Extracted Data1.     OverviewSyntaxDAYSOFMONTH(Date)Returns the number of days of[阅读全文:]

摘要:OverviewSyntaxWEEKDATE(Year,Month,WeekOfMonth,DayOfWeek)Returns the date corresponding to a specified[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxQUARTER(Serial_number,Format)Returns the quarter in the date. If no pa[阅读全文:]

摘要:OverviewSyntaxTIME(Hour,Minute,Second)Returns the specified date and time. The date is the current da[阅读全文:]

摘要:OverviewSyntaxNOW()Gets the current time.NotesNo parameter is required in the function.ExampleIf you[阅读全文:]

摘要:Extracted Data1. OverviewSyntaxSECOND(Serial_number,Format)Returns the second of a specified time. Th[阅读全文:]

摘要:OverviewSyntaxYEARDELTA(Date,Delta)Returns the date several years (specified by delta) after the spec[阅读全文:]

摘要:OverviewSyntaxROUND(Number,Num_digits)Returns the number rounded to the specified number of decimal p[阅读全文:]

摘要:OverviewSyntaxWEEKDAY(Serial_number)Returns the day of the week corresponding to a date. Returns an i[阅读全文:]

摘要:OverviewSyntaxTODAY()Returns the current date.NotesNo parameter is required in the function.Supports[阅读全文:]

摘要:OverviewSyntaxDATE(Year,Month,Day)Returns a specific date.Parameter 1YearRepresents the year, which c[阅读全文:]

摘要:OverviewSyntaxLOG(Number,Base)Returns the logarithm of a number to the base you specify.Parameter 1Nu[阅读全文:]

摘要:OverviewSyntaxRAND()Returns an evenly distributed random number greater than or equal to 0 and less t[阅读全文:]

摘要:OverviewAn operator is used to specify the type of calculation to be performed on the elements in a f[阅读全文:]

摘要:OverviewSyntaxABS(Number)Returns the absolute value of the specified number. The value is always non-[阅读全文:]

摘要:OverviewThis document lists some common analysis scenarios for DEF-type functions.IndexTypeDocumentEn[阅读全文:]

摘要:OverviewSyntaxWINDOW_STDEV(Indicator,[Grouping field 1,Grouping field 2,...],[Sorting field 1,Sorting[阅读全文:]

摘要:OverviewSyntaxWINDOW_VAR(Indicator,[Grouping field 1,Grouping field 2,...],[Sorting field 1,Sorting m[阅读全文:]

摘要:OverviewVersionFineBI VersionFunctional Change6.1.2/Function DescriptionSyntaxRANK_AGG([Grouping fiel[阅读全文:]

摘要:OverviewSyntaxWINDOW_MAX(Indicator,[Grouping field 1,Grouping field 2,...],[Sorting field 1,Sorting m[阅读全文:]

摘要:OverviewSyntaxWINDOW_MIN(Indicator,[Grouping field 1,Grouping field 2,...],[Sorting field 1,Sorting m[阅读全文:]

摘要:I. An Overview of RFM Analysis1) RFM Analysis, developed by American database marketing institut[阅读全文:]

摘要:I. An Overview of Retention Analysis1) Retention Analysis is a crucial analytical model for eval[阅读全文:]

摘要:I. An Overview of Pareto Chart1) The Pareto Chart, an invaluable tool in business analytics, int[阅读全文:]

摘要:OverviewWINDOW functions are commonly used for cross-row calculation, that is, calculation on data wi[阅读全文:]

摘要:OverviewBackgroundUser loyalty refers to the degree of dependence and repeat consumption expectations[阅读全文:]

摘要:OverviewBackgroundYou consider each order a market basket and want to determine the association betwe[阅读全文:]

摘要:OverviewDefinitionYou can classify and analyze the lifecycle status of existing customers. Customers[阅读全文:]

摘要:OverviewDefinitionBoston Consulting Group Matrix (BCG Matrix) is also known as the growth-share matri[阅读全文:]

摘要:OverviewExpected EffectMonthly repurchase rate = Number of people who made two or more purchases in a[阅读全文:]

摘要:OverviewSyntaxCLEAN_WIDGET(Field 1,Field 2,Field   3....)/CLEAN_WIDGET("ALL")Function[阅读全文:]

摘要:OverviewCLEAN targets fields to ignore the filtering effect of these fields during the current DEF ca[阅读全文:]

摘要:VersionFineBI VersionFunctional Change6.0.16/OverviewThe IFERROR function is used to identify an[阅读全文:]

摘要:OverviewDEF_ADD function calculates the value of the aggregate indicator based on the dimension speci[阅读全文:]

摘要:OverviewBackgroundYou may need to calculate the data for a certain period, such as the sales of the p[阅读全文:]

摘要:OverviewExpected EffectText statements are often needed in report dashboards to describe or summarize[阅读全文:]

摘要:OverviewVersionFineBI VersionFunctional Change6.0/PreviewSometimes, unnecessary characters need to be[阅读全文:]

摘要:OverviewDEF_SUB calculates the value of the aggregate indicator based on the dimension in the analysi[阅读全文:]

摘要:OverviewThe DEF function calculates the value of the aggregate indicator based on the specified dimen[阅读全文:]

摘要:OverviewGrammarFIND(find_text,within_text,start_num)Returns the first specified substring (find_text)[阅读全文:]

摘要:OverviewMerging and splitting of fields are essential to data integration.In datasets, some fields ne[阅读全文:]

摘要:Extracted DataOverviewGrammarLEN(args)Returns the number of characters of a string.Parameter 1argsPar[阅读全文:]

摘要:OverviewGrammarCONCATENATE(text1,text2,...)Joins at least two strings into one.Parameter 1Text1,text2[阅读全文:]

摘要:Usage 1: Replacing Specified Content of a TextOverviewGrammarREPLACE(text,textorreplace,replacetext)R[阅读全文:]

摘要:OverviewGrammarINDEXOF(str1,index)Returns the character in str1 at the position specified by index.Pa[阅读全文:]