Data Calculation

FineBI has powerful data calculation capabilities and provides rich function types. It is convenient for users to perform secondary processing on data to meet flexible and changeable business analysis demands.

feature

Regular Functions

FineBI has a variety of built-in conventional functions.

  • Logical functions, such as IF, AND, SWITCH, OR, etc.
  • Mathematical and trigonometric functions, such as MIN, MAX, RAND, etc.
  • Date functions, such as MONTH, YEAR, TODATE, etc.
  • Text functions, such as SUBTITUTE, FORMAT, LEFT, etc.

Aggregate Function

  • Different aggregation functions correspond to different aggregation methods, including summation, average, median, maximum value, minimum value, standard deviation, variance, deduplication count, and count.
  • As the user's analysis dimension switches, the calculated field will automatically adjust dynamically according to the dimension.
feature
feature

Def Function

  • Analysis function is a new type of function in FineBI 6.0 version, including def, def-add, def-sub and Earlier Function.
  • After the analysis function is combined with the original basic function, it can output calculation indicators of any level and any complexity based on limited data, covering more complex business scenarios, and solving solution implementation problems for users.

Other features

Data Calculation

learn more  >

Data Visualization

learn more  >

Sharing & Collaboration

learn more  >

Data Editing

learn more  >

Data Management

learn more  >

Data Calculation

learn more  >

Data Visualization

learn more  >

Sharing & Collaboration

learn more  >

Data Editing

learn more  >

Data Management

learn more  >

Data Calculation

learn more  >

Start a new journey of business intelligence and big data analysis with FineBI

Try it now and get over 100 data analysis templates for business scenarios in various industries.

Try FineBI for Free