Summary:1. Overview1.1 VersionFineBI VersionJAR PackageFunction Changes5.1--5.1.72020-11-05Function definitio[Full Text:]

Summary:1. Overview1.1 ConceptThe full name of ABC classification should be ABC classification inventory cont[Full Text:]

Summary:1. Extracted data1）OverviewSyntaxQUARTER(serial_number,format)Returns the quarter of the time. If no[Full Text:]

Summary:1. OverviewWhen the calculation data is very large, the traditional accurate deduplication count may[Full Text:]

Summary:1. OverviewGrammarAVG_AGG(array)According to the current analysis dimension, the summary average valu[Full Text:]

Summary:1. OverviewJudge the condition. If the calculation result of the specified condition is "TRUE&qu[Full Text:]

Summary:1. OverviewFinebi supports the use of a variety of formula and functions. These formula or functions[Full Text:]

Summary:1. Overview1.1 VersionFineBI VersionJAR PackageFunction Changes5.1.112021-04-02Real time data formula[Full Text:]

Summary:1. Overview1.1 Expected effectSplice the three fields of "Region", "Account Manager&qu[Full Text:]

Summary:Q1: Can't the fields in the formula be entered manually?A: No, the field needs to be selected in[Full Text:]

Summary:1. Overview1.1 VersionFineBI VersionJAR PackageFunction Changes5.1--5.1.72020-11-05Function definitio[Full Text:]

Summary:1. Overview1.1 VersionFineBI VersionJAR PackageFunction Changes5.1--5.1.72020-11-05Function definitio[Full Text:]

Summary:1. OverviewWhen processing data, users often use regular expressions to describe certain string match[Full Text:]

Summary:1. Overview1.1 Expected effectExample 1: For example, you need to calculate the average sales of the[Full Text:]

Summary:1. Overview1.1 VersionFineBI VersionJAR PackageFunction Changes5.1--5.1.72020-11-05Function definitio[Full Text:]

Summary:1. Overview1.1 Expected effectUsers sometimes need to intercept the character at a specified position[Full Text:]

Summary:1. Overview1.1 Expected viewCount the number of occurrences of the same character in the field. For e[Full Text:]

Summary:1. Overview1.1 VersionFineBI VersionJAR PackageFunction Changes5.1--5.1.72020-11-05Function definitio[Full Text:]

Summary:1. Overview1.1 VersionFineBI VersionFunction Changes5.1.5-1.2 Application scenariosAggregate function[Full Text:]

Summary:1. Overview1.1 Expected effectFor example, add a serial number to the "Contract ID", as sho[Full Text:]

Summary:1. Overview1.1 VersionFineBI VersionJAR PackageFunction Changes5.1--5.1.72020-11-05Function definitio[Full Text:]

Summary:1. Overview1.1 Expected effectMany users now have data tables with various special values, such as ne[Full Text:]

Summary:1. Overview1.1 Expected effectData desensitization refers to the deformation of data through desensit[Full Text:]

Summary:1. Overview1.1 Application scenarioFineBI has provided a large number of self-contained functions, wh[Full Text:]

Summary:1. Overview1.1 Version          FineBI      JARFunction[Full Text:]

Summary:1. Overview1.1 Version          FineBI version        &n[Full Text:]

Summary:OverviewThis article sifts, organizes, categorizes, and arranges the practical application documents[Full Text:]

Summary:1. Overview 1.1 Background User stickiness refers to the degree of dependence and re-consumption expe[Full Text:]

Summary:1. OverviewHow to complete a data analysis project and write a data analysis report?2. Operation step[Full Text:]

Summary:1. OverviewIn the process of data analysis, if we want to understand the data, we need to explore fro[Full Text:]

Summary:1. Overview1.1 BackgroundLi Mingming is a personnel. One day, the boss told her to use the company&#3[Full Text:]

Summary:1. Overview1.1 Expected effectSometimes, you need to convert the "Text" or "Value&quot[Full Text:]

Summary:1. Overview1.1 BackgroundBreakeven analysis, also known as breakeven analysis or cost-volume-profit a[Full Text:]

Summary:1. OverviewIn Excel:"Condition count (COUNTIF/COUNTIFS)": count the number of data pieces t[Full Text:]

Summary:1. OverviewAfter acquiring business data, users may not be able to directly calculate and visually di[Full Text:]

Summary:1. Overview1.1 Application scenarioDuring data processing, the data of multiple data tables are often[Full Text:]

Summary:1. Overview1.1 BackgroundXiao Xia, a human resources student, found that the number of resignees in t[Full Text:]

Summary:1. OverviewThis paper arranges some date formulas commonly used, so that users can quickly use these[Full Text:]

Summary:1. OverviewIn data analysis, users often use IF judgment conditions to clean and process the existing[Full Text:]

Summary:1. OverviewWhen performing data merging, the splicing and merging of fields and the split of columns[Full Text:]

Summary:1. Overview1.1 Expected effectUse the "Product" table to calculate the comparison of "[Full Text:]

Summary:1. Overview1.1 BackgroundXiao Guo is the person in charge of a department store. He wants to analyze[Full Text:]

Summary:1. Overview1.1 BackgroundAs a product manager, Li Lei often encounters a lot of product requirements.[Full Text:]

Summary:1. Overview1.1 Expected effectRepurchase rate within the month =The number of people who purchased tw[Full Text:]

Summary:1. Overview1.1 ConceptClassify and analyze the life status of existing customers. Two dimensions[Full Text:]

Summary:1. OverviewRow-to-column conversion of row-to-column conversion describes how to perform row-to-colum[Full Text:]

Summary:1. Overview1.1 ConceptThis article uses the AARRR model to analyze user operations. The AARRR model i[Full Text:]

Summary:1. Overview1.1 ConceptInventory turnover is the ratio of the cost of goods sold to the average invent[Full Text:]

Summary:1. Overview 1.1 ConceptThe DuPont analysis method uses the relationship between several major financi[Full Text:]

Summary:1. Overview1.1 ConceptThe repurchase rate refers to the number of purchases in the recent period of t[Full Text:]

Summary:1. Overview1.1 ConceptBy studying user consumption data, we can correlate different products and expl[Full Text:]

Summary:1. Overview1.1 Purpose of analysisProduce a simplified business analysis report.Analyze the budget co[Full Text:]

Summary:1. Overview1.1 ConceptThe conversion funnel model is a method for analyzing the conversion effect of[Full Text:]

Summary:1. Overview1.1 ConceptRetention analysis is an analysis model used to analyze user participation/acti[Full Text:]

Summary:1. Overview1.1 Expected effectCount how many supplierids (1,10,11) each product has, using the "[Full Text:]

Summary:1. OverviewUsing FineBI can help users conveniently perform data processing and data visualization di[Full Text:]

Summary:1. OverviewWhen using data for data analysis, some basic analytical thinking is often used, such as t[Full Text:]

Summary:1. Overview1.1 Expected effectThe total row count counts all occurrences of a dimension field in a ce[Full Text:]

Summary:1. IndexIn the process of data analysis, it is usually necessary to use various models to prove one&#[Full Text:]

Summary:1. Overview1.1 Application scenariosThe count of a dimension field after the duplicate data is remove[Full Text:]

Summary:1. Overview1.1 ConceptBoston Matrix (BCG Matrix), also known as market growth rate-relative market sh[Full Text:]

Summary:1. Overview1.1 Expected effectColumn to row conversion is a conversion of a two-dimensional table to[Full Text:]

Summary:1. OverviewThis article describes the types of calculation that can be used in FineBI.You can use the[Full Text:]

Summary:1. OverviewThis article describes how to create and use calculation functions in FineBI using example[Full Text:]

Summary:1. OverviewGrammarABS(number)Return the absolute value of the specified number, which is always non-n[Full Text:]

Summary:1. Overview1.1 Expected effectYou can use the StringCat function to splice strings in BI. For example[Full Text:]

Summary:1. 概述语法CONCATENATE(text1,text2,...)将数个字符串合并成一个字符串参数1Text1,text2,...需要合并成单个文本的文本项2. 注意事项可使用多个任意类型参数3.[Full Text:]

Summary:1. Overview1.1 Expected effectFind the percentage of the top six sales neighborhoods in terms of the[Full Text:]

Summary:1. Overview1.1 Expected effectUsers sometimes need to clean out some unwanted characters in the data.[Full Text:]

Summary:1. Overview1.1 Expected effectCheck the values in the fields and group them according to the field va[Full Text:]

Summary:1. Overview1.1 Problem descriptionWhen there are many conditions that need to be judged, it will be m[Full Text:]

Summary:1. Overview1.1 VersionFineBIJARFunction Changes  5.1--5.1.72020-11-05Function interpretation opt[Full Text:]

Summary:1. Overview1.1 Version          FineBI       JARFunction[Full Text:]

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

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

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

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

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

Summary:1. Overview1.1 Expected effectSometimes users need to assign different values to different fields at[Full Text:]

Summary:1. OverviewSyntaxDAYS360(start_date,end_date,method)Using a 360-day year algorithm (30 days per month[Full Text:]

Summary:1. OverviewSyntaxTODAY()Get the current date.2. PrecautionNo parameterSince 5.1.12, date field-value[Full Text:]

Summary:1. OverviewCOUNTD_ AGG() performs deduplication count on the data of the specified dimension (the num[Full Text:]

Summary:1. OverviewCOUNT_ AGG() counts the data of the specified dimension (the number of non empty cells). W[Full Text:]

Summary:1. OverviewIf the logical value of any parameter is TRUE, then return TURE; if the logical value of a[Full Text:]

Summary:1. Extract data1）OverviewGrammarINT(number)Returns the nearest integer value after the number is roun[Full Text:]

Summary:1. OverviewGrammarROUND(number,num_digits)Returns a number rounded by a specified number of digits.Pa[Full Text:]

Summary:1. OverviewSUM_ AGG is used to summarize and sum the data of the specified dimension (dragged into th[Full Text:]

Summary:1. OverviewOperator is used to specify the type of calculation to perform on the elements in the form[Full Text:]

Summary:1. Overview1.1 Expected effect1.2 Implementation ideasUse the quick calculation functions ACC_SU[Full Text:]

Summary:1. Overview1.1 Problem descriptionUsers sometimes use the formula when the formula is not legal, this[Full Text:]

Summary:1. Overview1.1 Problem descriptionWhen using FineBI, it is sometimes necessary to find the cumulative[Full Text:]

Summary:1. Overview1.1 VersionFineBI VersionJAR PackageFunction Changes5.1  --5.1.72020-11-05Functi[Full Text:]

Summary:1. Overview1.1 Version          FineBI Version        &n[Full Text:]

Summary:1. Overview1.1 VersionFineBIJARFunction Changes5.1--5.1.72020-11-05Optimize definition of functionsCl[Full Text:]

Summary:1. Overview1.1 Version         FineBI   JARFunction Changes [Full Text:]

Summary:1. OverviewGrammarPERCENTILE_AGG(array,percentile)According to the current analysis dimension, the va[Full Text:]

Summary:1. OverviewGrammarSTDEV_AGG(array)According to the current analysis dimension, the standard deviation[Full Text:]

Summary:1. OverviewGrammarMAX_AGG(array)According to the current analysis dimension, the maximum value of the[Full Text:]

Summary:1. OverviewGrammarVAR_AGG(array)According to the current analysis dimension, the variance of the indi[Full Text:]

Summary:1. OverviewGrammarMEDIAN_AGG(array)According to the current analysis dimension, the median of the ind[Full Text:]