Perform Calculations Overview

You need to perform calculations across your data which extract meaningful insights and derive new data points for reporting, summarization, visualization, and dashboard tasks. These calculations need to be able to be designed and executed without having to rely on any complex syntax or scripting languages while providing the flexibility to support highly custom expressions and transformations easily. You need to perform these calculations on data which exists across many different sources, structures, and formats without requiring you to have to grapple with technical configurations or code.

With Flow Analytics workflows and a powerful configure-not-code development environment, you can rapidly design solutions which perform and automate any calculation across the entirety of your required data. Flow can access, extract, and unify all required data for your operations and allows you to develop powerful expressions which can execute virtually any data transformation or computation. You can deliver the results of your calculations through rich reports, dashboards, visualizations, and other data communication mediums. Calculations can be embedded as logic into workflows and have their execution be fully automated once developed.

Get Started With Flow Analytics Workflows

Completely free - no trial period or credit card required.

Fully functional - access all the core features of the Flow platform.

Develop custom workflows - use our advanced, configure-not-code development environment to build custom solutions.

Free help and support - full documentation and how-to videos along with free online, telephone or email support.

Example Calculation Workflows

Workflow Example 1 - Building Expressions

This workflow demonstrates an example of applying expressions to data. The expression builder is used to create simple to complex mathematical and arithmetic transformations on our target data collection. We embed the expression steps as actions into the workflow which allows the calculations to be repeatable and performed in an automated context.

Watch Video
Workflow Example 2 - String Functions

This workflow demonstrates an example of configuring expressions to perform various date and string calculations which cleanse a dataset. Dirty data is transformed and standardized by applying a sequence of operations within the expression builder. We add the string functions as actions to the workflow which allows for the calculations to be repeatable and automated.

Watch Video

Data Calculation and Expressions Actions Overview

Action Type Description  
Arithmetic Operations The Arithmetic Operations provides rich arithmetic functions for calculating and designing mathematical expressions and transformations against your data. view actions →
Boolean/Logical Operations The Boolean Operation Expression Library provides logical operations (And, OR, NAND, XOR, ISNull etc..) for evaluating logical conditions and deriving new logic data points. view actions →
Comparison Operations The Comparison Operations expression library provides functions for comparing the values of data points, variables, and literals. Comparison operations generate booleans as a result which can be used to sequence up complex transformations and conditions. view actions →
Date Operations The Data Operations expression library provides functions for computing and transforming datetime values. This includes extraction of summary date components from raw date values, date calculations and manipulation, time distance functions, and more. view actions →
Single List Statistics Operations The Single List Statistics Operations expression library provides statistical functions which operate on a single data point and compute scalar variable values as a result. The statistical expression library can be applied to hypercubes to build multidimensional expressions which can compute statistics over many aggregations at once. view actions →
Regular Expression Operations The Regular Expression operation library provides pattern matching functions and pattern evaluation / transformation expressions which allow for complex transformations, replaces, data cleansing operations, and more. view actions →
String Operations The String Operations expression library provides a vast library of text manipulation and text cleansing functions. The String Operation library can be used to clean and transform text values to compute new data points and correct anomalies in existing text data point values. view actions →
Paired List Statistics Operations The Paired List Statistics Operations expression library provides statistical functions which operate on pairs of numeric data point and compute scalar variable values as a result. The Paired List Statistics expression library can be applied to hypercubes to build multidimensional expressions which can compute paired statistics over many aggregations at once. This allows for the computation of hypercube multidimensional correlations, hypercube slope and regression calculations and more. view actions →
Time Series Operations The Time Series Operations expression library provides transformation functions for manipulating time series numeric data. These operations include moving differences, moving averages, moving medians, interpolation and imputation functions and more. view actions →
Probability Operations The Probabiliy Operations library provides functions for computing combinations, permutations, and other expressions core to fundamental probability theory. view actions →
Date Arithmetic Operations The Date Arithmetic Operations library provides functions for measuring the distances between different datetime data point values. This includes functions for measuring differences in days,weeks, years between two datetime values and the ability to persist the results of these computations as new data points. view actions →
HyperCube Statistics Operations The HyperCube Statistics operations provide multidimensional expression libraries for computing and summarizing across hypercubes. view actions →

Additional Calculation Information & Resources

Blog Posts
Post Description  
Flow Crash Course - Part 5 - Generic Expressions and Data Point Computing This is the fifth blog post in our crash course series on Flow. In this blog post, I provide an introduction to Generic Expressions in the Flow Computing Framework. view post →
Flow Crash Course - Part 6 - HyperCube Computation This is the sixth blog post in our crash course series on Flow. In this blog post, I provide an introduction to HyperCube Computation in the Flow Computing Framework. view post →
How to Perform a HyperCube Time Series Analysis This blog post provides a worked example of a hypercube time series analysis. Date expressions are used to extract and compute summary time dimensions from a raw datetime data point value. A hypercube is built on the extracted datetime dimensions. Time series computations are then performed on the hypercube to summarize changes in values over time. view post →
Videos
Video Title Video Description  
Flow Tutorials - Fill Value FunctionThis video provides a worked example demonstrating how to use the Fill Value operator in the expression builder. The fill value operator allows you to fill a data point or variables value as part of your workflow.view video →
Flow Tutorials - Euclidean DistanceThis video provides a worked example demonstrating how to configure and implement the Euclidean Distance operator in the expression builder.view video →
Flow Tutorials - LogBase10 FunctionThis video provides a worked example demonstrating how to configure and implement the LogBase10 arithmetic operator in the expression builder.view video →
Flow Tutorials - Log FunctionThis video provides a worked example demonstrating how to configure and implement the Logarithm operator in the expression builder.view video →
Flow Tutorials - CeilingThis video provides a worked example demonstrating how to configure and implement the Ceiling operator in the expression builder.view video →
Flow Tutorials - FloorThis video provides a worked example demonstrating how to configure and implement the Floor operator in the expression builder.view video →
Flow Tutorials - RoundToThis video provides a worked example demonstrating how to configure and implement the RoundTo operator in the expression builder.view video →
Flow Tutorials - Arithmetic MinThis video provides a worked example demonstrating how to configure and implement the Arithmetic Minimum operator in the expression builder.view video →
Flow Tutorials - Arithmetic MaxThis video provides a worked example demonstrating how to configure and implement the Arithmetic Maximum operator in the expression builder.view video →
Flow Tutorials - Absolute Value FunctionThis video provides a worked example demonstrating how to configure and implement the Absolute Value operator in the expression builder.view video →
Flow Tutorials - SubtractionThis video provides a worked example demonstrating how to configure and implement the Subtraction operator in the expression builder. This video shows how to subtract two data points and store the result of the operation as a new data point.view video →
Flow Tutorials - DivisionThis video provides a worked example demonstrating how to configure and implement the Division operator in the expression builder. This video shows how to divide two data points and store the result of the operation as a new data point.view video →
Flow Tutorials - AdditionThis video provides a worked example demonstrating how to configure and implement the Addition operator in the expression builder. This video shows how to add two data points and store the result of the operation as a new data point.view video →
Flow Tutorials - MultiplicationThis video provides a worked example demonstrating how to configure and implement the Multiplication operator in the expression builder. This video shows how to subtract two data points and store the result of the operation as a new data point.view video →
Flow Tutorials - Power FunctionThis video provides a worked example demonstrating how to configure and implement the Power operator in the expression builder.view video →
Flow Tutorials - Square RootThis video provides a worked example demonstrating how to configure and implement the Square Root operator in the expression builder.view video →
Flow Tutorials - Boolean Equality OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Equality operator in the expression builder.view video →
Flow Tutorials - NOr OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Nor (Not OR) operator in the expression builder.view video →
Flow Tutorials - Nand OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Nand (Not And) operator in the expression builder.view video →
Flow Tutorials - XORThis video provides a worked example demonstrating how to configure and implement the Boolean XOr (Exlusive OR) operator in the expression builder.view video →
Flow Tutorials - Bit OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Bit Transformation operator in the expression builder.view video →
Flow Tutorials - Not OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean Not operator in the expression builder.view video →
Flow Tutorials - Or OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean OR operator in the expression builder.view video →
Flow Tutorials - And OperatorThis video provides a worked example demonstrating how to configure and implement the Boolean And operator in the expression builder.view video →
Flow Tutorials - Get First Word FunctionThis video provides a worked example demonstrating how to configure and implement the Get First Word operator in the expression builder. The Get First Word operator allows you to extract the first word from a target string argument and is often used in natural language processing tasks.view video →
Flow Tutorials - Contains Non Alphanumeric FunctionThis video provides a worked example demonstrating how to configure and implement the ContainsNonAlphanumeric operator in the expression builder. The ContainsNonAlphanumeric is used to evaluate if target string values contain non-alphanumeric characters.view video →
Flow Tutorials - Remove SymbolsThis video provides a worked example demonstrating how to configure and implement the Remove Symbols operator in the expression builder.view video →
Flow Tutorials - Remove Alphabetic FunctionThis video provides a worked example demonstrating how to configure and implement the Remove Alphabetic operator in the expression builder.view video →
Flow Tutorials - Contains Alphabetic FunctionThis video provides a worked example demonstrating how to configure and implement the Contains Alphabetic operator in the expression builder.view video →
Flow Tutorials - Contains Numeric FunctionThis video provides a worked example demonstrating how to configure and implement the Contains Numeric operator in the expression builder.view video →
Flow Tutorials - First N Characters FunctionThis video provides a worked example demonstrating how to configure and implement the First N Characters operator in the expression builder.view video →
Flow Tutorials - Remove Numeric FunctionThis video provides a worked example demonstrating how to configure and implement the Remove Numeric operator in the expression builder.view video →
Flow Tutorials - Validate Email FunctionThis video provides a worked example demonstrating how to configure and implement the Validate Email operator in the expression builder.view video →
Flow Tutorials - Trim FunctionThis video provides a worked example demonstrating how to configure and implement the Trim operator in the expression builder.view video →
Flow Tutorials - Default Blanks FunctionThis video provides a worked example demonstrating how to configure and implement the Default Blanks operator in the expression builder.view video →
Flow Tutorials - EndsWith FunctionThis video provides a worked example demonstrating how to configure and implement the EndsWith operator in the expression builder.view video →
Flow Tutorials - StartsWith FunctionThis video provides a worked example demonstrating how to configure and implement the StartsWith operator in the expression builder.view video →
Flow Tutorials - Substring to End FunctionThis video provides a worked example demonstrating how to configure and implement the SubstringToEnd operator in the expression builder.view video →
Flow Tutorials - Last Index Of FunctionThis video provides a worked example demonstrating how to configure and implement the Last Index Of operator in the expression builder.view video →
Flow Tutorials - Word Count FunctionThis video provides a worked example demonstrating how to configure and implement the Word Count operator in the expression builder.view video →
Flow Tutorials - Remove Non-Numeric FunctionThis video provides a worked example demonstrating how to configure and implement the Remove Non-Numeric operator in the expression builder.view video →
Flow Tutorials - Format Phone FunctionThis video provides a worked example demonstrating how to configure and implement the Format Phone Number operator in the expression builder.view video →
Flow Tutorials - Replace HTML Tags FunctionThis video provides a worked example demonstrating how to configure and implement the Replace HTML Tags operator in the expression builder.view video →
Flow Tutorials - Contains HTML Tags FunctionThis video provides a worked example demonstrating how to configure and implement the Contains HTML Tags operator in the expression builder.view video →
Flow Tutorials - Remove Non Alpha Numeric FunctionThis video provides a worked example demonstrating how to configure and implement the Remove Non Alpha-numeric operator in the expression builder.view video →
Flow Tutorials - Substring FunctionThis video provides a worked example demonstrating how to configure and implement the Substring operator in the expression builder.view video →
Flow Tutorials - Contains FunctionThis video provides a worked example demonstrating how to configure and implement the Contrains String operator in the expression builder.view video →
Flow Tutorials - Replace StringThis video provides a worked example demonstrating how to configure and implement the Replace String operator in the expression builder.view video →
Flow Tutorials - Index Of FunctionThis video provides a worked example demonstrating how to configure and implement the Index Of operator in the expression builder.view video →
Flow Tutorials - Compute Length of StringThis video provides a worked example demonstrating how to compute the length of a string using the Length operator in the expression builder.view video →
Flow Tutorials - ProperCase FunctionThis video provides a worked example demonstrating how to configure and implement the ProperCase operator in the expression builder.view video →
Flow Tutorials - To Upper FunctionThis video provides a worked example demonstrating how to configure and implement the To Upper operator in the expression builder.view video →
Flow Tutorials - To Lower FunctionThis video provides a worked example demonstrating how to configure and implement the To Lower operator in the expression builder.view video →
Flow Tutorials - Concat With Space SeparatorThis video provides a worked example demonstrating how to configure and implement the Concat With Space Seperator operator in the expression builder.view video →
Flow Tutorials - Data Point AdditionThis video provides a worked example demonstrating how to perform addition operations against two data points.view video →
Flow Tutorials - Data Point MultiplicationThis video provides a worked example demonstrating how to perform multiplication operations against two data points.view video →
Flow Tutorials - Year Difference Date ArithmeticThis video provides a worked example demonstrating how to take the difference in years between two datetime data points by using the Year Difference Date Arithmetic operator.view video →
Flow Tutorials - Month Difference Date ArithmeticThis video provides a worked example demonstrating how to take the difference in months between two datetime data points by using the Month Difference Date Arithmetic operator.view video →
Flow Tutorials - Week Difference Date ArithmeticThis video provides a worked example demonstrating how to take the difference in weeks between two datetime data points by using the Week Difference Date Arithmetic operator.view video →
Flow Tutorials - Day Difference Date ArithmeticThis video provides a worked example demonstrating how to take the difference in days between two datetime data points by using the Day Difference Date Arithmetic operator.view video →
Flow Tutorials - Extract Day of Week StringThis video provides a worked example demonstrating how to configure and implement the Extract Day of Week String operator in the expression builder.view video →
Flow Tutorials - Extract Month StringThis video provides a worked example demonstrating how to configure and implement the Extract Month String operator in the expression builder.view video →
Flow Tutorials - Extract QuarterYear String FunctionThis video provides a worked example demonstrating how to configure and implement the Extract QuarterYear String operator in the expression builder.view video →
Flow Tutorials - Extract Quarter String FunctionThis video provides a worked example demonstrating how to configure and implement the Extract Quarter String operator in the expression builder.view video →
Flow Tutorials - Add/Subtract HoursThis video provides a worked example demonstrating how to add and subtract hours from a target datetime data point using the Add Hours operator in the expression builder.view video →
Flow Tutorials - Add/Subtract DaysThis video provides a worked example demonstrating how to add and subtract days from a target datetime data point using the Add Days operator in the expression builder.view video →
Flow Tutorials - Extract Days From NowThis video provides a worked example demonstrating how to compute the distance in days between a target datetime and the current date using the Days From Now operator in the expression builder.view video →
Flow Tutorials - Extract Hours From Now FunctionThis video provides a worked example demonstrating how to compute the distance in hours between a target datetime and the current date using the Hours From Now operator in the expression builder.view video →
Flow Tutorials - Minutes From Now FunctionThis video provides a worked example demonstrating how to compute the distance in minuets between a target datetime and the current date using the Minutes From Now operator in the expression builder.view video →
Flow Tutorials - From Unix Time Stamp FunctionThis video provides a worked example demonstrating how to configure and implement the From Unix Timestamp operator in the expression builder.view video →
Flow Tutorials - To Unix TimeStamp FunctionThis video provides a worked example demonstrating how to configure and implement the To Unix Timestamp operator in the expression builder.view video →
Flow Tutorials - Extract Numeric YearMonthThis video provides a worked example demonstrating how to configure and implement the Extract Numeric YearMonth operator in the expression builder.view video →
Flow Tutorials - Extract Numeric YearQuarterThis video provides a worked example demonstrating how to configure and implement the Extract Numeric YearQuarter operator in the expression builder.view video →
Flow Tutorials - Extract Numeric WeekdayThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Weekday operator in the expression builder.view video →
Flow Tutorials - Extract Numeric WeekThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Week operator in the expression builder.view video →
Flow Tutorials - Intro to Pop ChunkThis video provides a worked example demonstrating how to configure and implement the Pop Chunk function.view video →
Flow Tutorials - Extract Numeric Day of MonthThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Day of Month operator in the expression builder.view video →
Flow Tutorials - Extract Day of YearThis video provides a worked example demonstrating how to configure and implement the Extract Day of Year operator in the expression builder.view video →
Flow Tutorials - Extract Numeric MonthThis video provides a worked example demonstrating how to configure and implement the Extract Numeric Month operator in the expression builder.view video →
Flow Tutorials - Extract Year FunctionThis video provides a worked example demonstrating how to configure and implement the Extract Year operator in the expression builder.view video →
Flow Tutorials - Sum and DivisionThis video provides a worked example demonstrating how to configure and implement a compound expression using the Sum and Division operators.view video →
Flow Tutorials - HyperCube Time Series AnalysisThis video provides a worked example demonstrating how to perform a HyperCube Time Series analysis in Flow. This video takes a look at the Moving Difference time series operator evaluated across a hypercube which aggregates target data by a time period of interest.view video →