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.

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.

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.

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.

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 → |

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 → |

Video Title | Video Description | |
---|---|---|

Flow Tutorials - Fill Value Function | This 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 Distance | This video provides a worked example demonstrating how to configure and implement the Euclidean Distance operator in the expression builder. | view video → |

Flow Tutorials - LogBase10 Function | This video provides a worked example demonstrating how to configure and implement the LogBase10 arithmetic operator in the expression builder. | view video → |

Flow Tutorials - Log Function | This video provides a worked example demonstrating how to configure and implement the Logarithm operator in the expression builder. | view video → |

Flow Tutorials - Ceiling | This video provides a worked example demonstrating how to configure and implement the Ceiling operator in the expression builder. | view video → |

Flow Tutorials - Floor | This video provides a worked example demonstrating how to configure and implement the Floor operator in the expression builder. | view video → |

Flow Tutorials - RoundTo | This video provides a worked example demonstrating how to configure and implement the RoundTo operator in the expression builder. | view video → |

Flow Tutorials - Arithmetic Min | This video provides a worked example demonstrating how to configure and implement the Arithmetic Minimum operator in the expression builder. | view video → |

Flow Tutorials - Arithmetic Max | This 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 Function | This video provides a worked example demonstrating how to configure and implement the Absolute Value operator in the expression builder. | view video → |

Flow Tutorials - Subtraction | This 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 - Division | This 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 - Addition | This 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 - Multiplication | This 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 Function | This video provides a worked example demonstrating how to configure and implement the Power operator in the expression builder. | view video → |

Flow Tutorials - Square Root | This 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 Operator | This video provides a worked example demonstrating how to configure and implement the Boolean Equality operator in the expression builder. | view video → |

Flow Tutorials - NOr Operator | This 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 Operator | This 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 - XOR | This 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 Operator | This 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 Operator | This video provides a worked example demonstrating how to configure and implement the Boolean Not operator in the expression builder. | view video → |

Flow Tutorials - Or Operator | This video provides a worked example demonstrating how to configure and implement the Boolean OR operator in the expression builder. | view video → |

Flow Tutorials - And Operator | This 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 Function | This 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 Function | This 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 Symbols | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This video provides a worked example demonstrating how to configure and implement the Validate Email operator in the expression builder. | view video → |

Flow Tutorials - Trim Function | This video provides a worked example demonstrating how to configure and implement the Trim operator in the expression builder. | view video → |

Flow Tutorials - Default Blanks Function | This video provides a worked example demonstrating how to configure and implement the Default Blanks operator in the expression builder. | view video → |

Flow Tutorials - EndsWith Function | This video provides a worked example demonstrating how to configure and implement the EndsWith operator in the expression builder. | view video → |

Flow Tutorials - StartsWith Function | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This video provides a worked example demonstrating how to configure and implement the Substring operator in the expression builder. | view video → |

Flow Tutorials - Contains Function | This video provides a worked example demonstrating how to configure and implement the Contrains String operator in the expression builder. | view video → |

Flow Tutorials - Replace String | This 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 Function | This 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 String | This 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 Function | This video provides a worked example demonstrating how to configure and implement the ProperCase operator in the expression builder. | view video → |

Flow Tutorials - To Upper Function | This 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 Function | This 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 Separator | This 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 Addition | This video provides a worked example demonstrating how to perform addition operations against two data points. | view video → |

Flow Tutorials - Data Point Multiplication | This video provides a worked example demonstrating how to perform multiplication operations against two data points. | view video → |

Flow Tutorials - Year Difference Date Arithmetic | This 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 Arithmetic | This 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 Arithmetic | This 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 Arithmetic | This 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 String | This 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 String | This 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 Function | This 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 Function | This 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 Hours | This 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 Days | This 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 Now | This 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 Function | This 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 Function | This 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 Function | This 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 Function | This 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 YearMonth | This 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 YearQuarter | This 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 Weekday | This 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 Week | This 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 Chunk | This video provides a worked example demonstrating how to configure and implement the Pop Chunk function. | view video → |

Flow Tutorials - Extract Numeric Day of Month | This 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 Year | This 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 Month | This 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 Function | This 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 Division | This 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 Analysis | This 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 → |