摘要: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[阅读全文:]
摘要:OverviewThis document is applicable to users who have installed the Data Portal plugin to l[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/FunctionsFor security reasons, you can choose Syste[阅读全文:]
摘要:OverviewApplication ScenariosIn many analysis scenarios, you may want to analyze and visually display[阅读全文:]
摘要:OverviewThis document is applicable to users who have installed the Data Portal plugin to l[阅读全文:]
摘要:OverviewVersionFineBI Version6.0Application ScenariosThis document introduces the possible problems t[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/Application ScenariosThe decision-making platform a[阅读全文:]
摘要:OverviewApplication ScenariosFineBI allows jumping to web pages after clicking components.Scenario On[阅读全文:]
摘要:OverviewVersionFineBI VersionJAR Package6.0/Application ScenariosMost system-generated log files are[阅读全文:]
摘要:OverviewExpected EffectWhen viewing data with date as a dimension for statistical analysis, you may n[阅读全文:]
摘要:OverviewVersionFineBI VersionJAR Package6.0/FunctionsFile Dataset specifies the dataset that is[阅读全文:]
摘要:OverviewVersionFineBI Version5.0Application ScenariosHow to import or synchronize their department hi[阅读全文:]
摘要:OverviewVersionFineBI Version6.0Application ScenariosAuthorization Migration plugin can be used[阅读全文:]
摘要:OverviewThis document is applicable to users who have installed the Data Portal plugin to learn[阅读全文:]
摘要: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[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.4Moved BI Cache to General.FunctionsLog in[阅读全文:]
摘要:OverviewVersionFineBI Version6.0Application ScenariosIn addition to the normal login process, you may[阅读全文:]
摘要:OverviewVersionFineBI Version6.0Problem DescriptionThere may be some issues during plugin installatio[阅读全文:]
摘要:OverviewFunctionsAuthenticate User Password Only means authenticating whether the user has logged in[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/Application ScenariosFor security reasons, use[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.6Allowed admins to determine whether to enable[阅读全文:]
摘要: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[阅读全文:]
摘要:OverviewApplication ScenariosYou may need to use custom types of data sources for data analysis and d[阅读全文:]
摘要:OverviewVersionFineBI VersionJAR Package6.0/FunctionsExcel dataset refers to Excel files as the data[阅读全文:]
摘要:OverviewVersionFineBI VersionJAR Package6.0/FunctionsXML dataset refers to XML files as the data sour[阅读全文:]
摘要: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[阅读全文:]
摘要:OverviewData Portal plugin is a unified data query entrance provided by FanRuan.You can quickly find[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/6.0.9Optimized the icon of published data.6.0.12Add[阅读全文:]
摘要:OverviewVersionFineBI Version5.1Application ScenariosIn Resource Dimension of User Final Authori[阅读全文:]
摘要: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,[阅读全文:]
摘要:OverviewVersionFineBI Version6.0Application ScenariosYou can click Save as Subject to save the m[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0.4/6.0.5Added Data Used Space and Affected Users to[阅读全文:]
摘要: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[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0-FunctionsLog into FineBI as the admin and go to Sys[阅读全文:]
摘要: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[阅读全文:]
摘要:ProblemYou need to perform user authentication (The system will verify the entered username and passw[阅读全文:]
摘要:OverviewThis document briefly describes each data table and their fields in LogDB database.TableDescr[阅读全文:]
摘要:ProblemYou need to perform user authentication (The system will verify the entered username and passw[阅读全文:]
摘要:OverviewVersionFineBI Version5.1.16Application ScenariosFineBI prohibits incomplete authorization per[阅读全文:]
摘要:OverviewVersionFineBI Version6.0FunctionsQuery how many permissions a user has and who assigns the pe[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/FunctionsWhen users log into FineBI, the system nee[阅读全文:]
摘要:OverviewYou may meet problems such as no permissions when accessing dashboards or ineffective p[阅读全文:]
摘要:OverviewVersionFineBI VersionIntegrate Backend Single Sign-On PluginFunctional Change6.0V 1.1.1/6.0.1[阅读全文:]
摘要:OverviewThis article mainly introduces the causes and corrective methods of system registration probl[阅读全文:]
摘要:VersionFineBI VersionJAR Package6.0.112023-6-20My Analysis---Analysis Subject---Optimization of IN Fu[阅读全文:]
摘要:OverviewThis document describes how to specifically perform standalone and cluster project deployment[阅读全文:]
摘要:OverviewVersionFineBI Server VersionFunctional Change6.0/6.0.2If the user who created the account has[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0-6.0.5Added the Create Merge Calculation function.6.[阅读全文:]
摘要:OverviewApplication ScenariosWhen you want to filter through a field that does not participate in com[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/FunctionsUser notification saves the admin's ti[阅读全文:]
摘要:OverviewVersionFineBI VersionFunctional Change6.0/Application ScenariosAnalyze your own businesses by[阅读全文:]
摘要: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,[阅读全文:]