概要:一.使用上のアドバイス1.DEFのネストレベルが過度に多くしないことDEF 関数のネストレベルを過度に多くしないことはお勧めします。バックエンドの計算では複雑なSQLが生成されるため、データ量が大きい場[全文:]

概要:I. An Overview of RFM AnalysisRFM analysis, a simple and practical customer analysis method proposed[全文:]

概要:I. An Overview of Market Basket AnalysisConceptMarket basket analysis is an analysis method that asso[全文:]

概要:I. An Overview of Retention AnalysisConceptRetention analysis, an analysis model, is used to ana[全文:]

概要:I. An Overview of Dupont AnalysisConceptDuPont analysis uses the relationship between key financial r[全文:]

概要: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[全文:]

概要:OverviewThis document introduces how to create and use the calculation function with the sample data[全文:]

概要: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[全文:]

概要:OverviewThis document introduces the calculation types you can use in FineBI.You can use the followin[全文:]

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

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

概要: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)[全文:]

概要: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[全文:]

概要:OverviewGrammarTODOUBLE(text)Converts a text to a Double object (a double-precision floating-point nu[全文:]

概要:OverviewGrammarRIGHT(text,num_chars)Returns the last or last several characters in the text, based on[全文:]

概要:OverviewGrammarUPPER(text)Converts all characters in a text to uppercase.Parameter 1TextText to be co[全文:]

概要:OverviewGrammarSPLIT(String1,String2 )Returns an array of character strings splited from String1 by t[全文:]

概要:OverviewGrammarREPEAT(text,number_times)Repeats a text a specified number of times.Parameter 1textTex[全文:]

概要:OverviewGrammarTOINTEGER(text)Converts a text to an Integer object.Parameter 1TextText to be converte[全文:]

概要:OverviewGrammarEXACT(text1,text2)Determines whether two text strings are identical. If they are exact[全文:]

概要:OverviewGrammarMID(text,start_num,num_chars)Returns a user-specified number of characters from a spec[全文:]

概要:OverviewDEF, DEF_ADD, and DEF_SUB functions allow users to modify or control the calculation level of[全文:]

概要:Extracted DataUsage 1OverviewGrammarREGEXP(str,pattern)Determines whether a character string (specifi[全文:]

概要:OverviewRaw text data to be processed often contain special or irregular characters. This document in[全文:]

概要:OverviewGrammarNVL(value1,value2,value3,...)Returns the first non-null value among all parameters.Not[全文:]

概要:OverviewGrammarISNULL(object)Determines whether an object is null or empty.Parameter 1objectObject to[全文:]

概要:OverviewGrammarSTARTWITH(str1,str2)Determining whether str1 starts with str2.Parameter 1str1Character[全文:]

概要:OverviewGrammarPROPER(text)Capitalizes the first letter and letters that follow any non-letter charac[全文:]

概要:OverviewGrammarCODE(text)Returns a numeric code for the first character in a text string. The returne[全文:]

概要:OverviewGrammarCHAR(number)Returns the character specified by a number, by which you can convert code[全文:]

概要:OverviewGrammarLOWER(text)Converts all characters in text to lowercase.Parameter 1textText to be conv[全文:]

概要:OverviewBackgroundThis document introduces how to compare the sales volume of the chosen category wit[全文:]

概要:OverviewBackgroundThe accumulated sales as of each month every year can be calculated through the qui[全文:]

概要:OverviewBackgroundThis article introduces how to calculate the sales growth rate of one year compared[全文:]

概要:OverviewBackgroundCohort analysis groups users by their shared purchase characteristics. For example,[全文:]

概要:OverviewBackgroundIt is easy to calculate whether each state hit the profit goal, but such a general[全文:]

概要:OverviewBackgroundTo know how many users consume once a month, every two months, every three months,[全文:]

概要:OverviewBackgroundSam, person in charge of a department store, wants to analyze the competitiveness o[全文:]

概要:Overview GrammarTRIM(text)Returns the text with all leading and trailing spaces removed.Paramete[全文:]

概要:OverviewGrammarENDWITH(str1, str2)Determines whether str1 ends with str2.Parameter 1str1Character str[全文:]

概要:OverviewGrammarNUMTO (number, bool) or NUMTO (number)Returns number-converted Chinese texts.Parameter[全文:]

概要:OverviewGrammarLEFT(text, num_chars)Returns the first or first several characters in the text, based[全文:]

概要:OverviewGrammarSUBSTITUTE(text, old_text, new_text, instance_num)Substitutes new_text for old_text in[全文:]

概要:OverviewIn scenarios where frequent format conversion is required during data analysis, FineBI provid[全文:]

概要:OverviewGrammarTAN(number)Returns the tangent of a given angle.ParameternumberThe angle in radians yo[全文:]

概要:OverviewGrammarSIGN(number)Calculates the sine of a given angle.ParameternumberThe angle in radians y[全文:]

概要:OverviewGrammarRADIANS(angle)Converts degrees to radians.ParameterAngleAn angle in degrees to be conv[全文:]

概要:OverviewGrammarPOWER(number, power)Returns the result of a number raised to a power.Parameter 1number[全文:]

概要:OverviewGrammarPI(number)Returns the mathematical constant pi.ParameternumberWhen the number is empty[全文:]

概要:OverviewGrammarDEGREES(angle)Converts radians to degrees.ParameterAngleThe angle in radians to be con[全文:]

概要:OverviewGrammarCOS(number)Returns the cosine of an angle.ParameternumberThe angle in radians you want[全文:]

概要:OverviewGrammarATAN2(x_num, y_num)Returns the arctangent of X and Y coordinates. The arctangent is th[全文:]

概要:OverviewGrammarACOS(number)Returns the arccosine, namely inverse cosine, of a number. The arccosine v[全文:]

概要:OverviewGrammarACOS(number)Returns the arcsine, or inverse sine, of a number. The arcsine value is an[全文:]

概要:OverviewGrammarATAN(number)Calculates the arctangent, or inverse tangent, of a number. The parameter[全文:]

概要:OverviewGrammarEXP(number)Returns the nth power of e. The constant e is based on the natural logarith[全文:]

概要:Extracted Data VersionOverviewGrammarMOD(number, divisor)Returns the remainder after the number is di[全文:]

概要:OverviewGrammarPROMOTION(value1, value2)Returns the proportion increased from value1 to value2.Parame[全文:]

概要:Extracted Data VersionOverviewGrammarCEILING(number)Rounds up the number parameter to the nearest int[全文:]

概要:OverviewGrammarSQRT(number)Returns the arithmetic square root of a non-negative number. You can set n[全文:]

概要:Extracted Data VersionOverviewGrammarFLOOR(number)Rounds down the number parameter to the nearest int[全文:]

概要:OverviewGrammarMIN(number 1, number 2, ...)Returns the minimum value among listed parameters.Paramete[全文:]

概要:OverviewGrammarFACT(number)Returns the factorial of a number (equal to N in 1*2*3*...*N).Paramet[全文:]

概要:OverviewGrammarRANDBETWEEN(value1, value2)Returns a random integer between value1 and value2.When the[全文:]

概要:OverviewGrammarSIGN(number)Returns the sign of a number. Returns 1 for positive numbers, 0 for zero,[全文:]

概要:OverviewGrammarLN(number)Returns the natural logarithm of a number. The natural logarithm is based on[全文:]

概要:OverviewGrammarTRUNC(number, num_digits)Truncates a number to an integer or a decimal by removing spe[全文:]

概要:OverviewGrammarMAX(number 1, number 2, ...)Returns the maximum value among listed parameters.Par[全文:]

概要:OverviewThis document filters, organizes, classifies, and typesets the actual application documents o[全文:]

概要:OverviewDefinitionThe conversion funnel model analyzes the steps required to reach an outcome by outl[全文:]

概要:OverviewEARLIER: Get the value of the current row. It is only applicable to DEF, DEF_ADD, and DEF_SUB[全文:]

概要:OverviewBackgroundAs a product manager, John often has difficulty in meeting product demands, because[全文:]

概要:OverviewConceptThis document uses the AARRR model for user operation analysis. The AARRR model (also[全文:]

概要:Use ScopeUse LocationDashboardAdding Calculation IndicatorFunction ListFunctionDescriptionPERIOD_ANLS[全文:]

概要:OverviewProblemSometimes you may need to find the same data in different column fields (duplicate val[全文:]

概要:OverviewVersionFineBI Version6.0.9FunctionsIN is used to evaluate whether the result of the expressio[全文:]

概要:OverviewEffectAfter ranking the sales volume, you can filter out the top 30% of stores by sales volum[全文:]

概要:OverviewNOT is used to evaluate whether the expression meets a certain condition. If it belongs,[全文:]

概要:OverviewBackgroundIt is easy to calculate the purchase frequency of each client with an order detail[全文:]

概要:OverviewBackgroundYou may need to compare the business performance of stores in different regions bas[全文:]

概要:OverviewBackgroundIn addition to viewing the trend of profit changes over time easily, you may want t[全文:]

概要:OverviewVersionFineBI VersionFunctional Change6.0/Application ScenariosAfter configuring several comp[全文:]

概要:OverviewAfter you have finished creating table and chart components, you may need to further explore[全文:]

概要:OverviewSUM_AGG function is used to summarize and add up data for the specified dimension (dragg[全文:]