摘要: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[阅读全文:]

摘要: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[阅读全文:]

摘要:OverviewRFM analysis, a simple and practical customer analysis method proposed by American database m[阅读全文:]

摘要: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[阅读全文:]

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

摘要:OverviewDefinitionAn ABC inventory classification system, also known as the Pareto Analysis, primary[阅读全文:]

摘要: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[阅读全文:]

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

摘要:OverviewConceptRetention analysis, an analysis model, is used to analyze users' engagement/a[阅读全文:]

摘要: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[阅读全文:]

摘要:OverviewData analysis demand is increasing rapidly in enterprises.In this topic, you will learn pract[阅读全文:]

摘要:OverviewSyntaxLUNAR(year, month, day)Returns the lunar time corresponding to the current datePar[阅读全文:]

摘要:1. OverviewThis article describes how to create and use calculation functions in FineBI using example[阅读全文:]