Glossary

Browse our Data Node Terms.

Sends an email notification to a list of recipients when triggered.

Creates a new Data App when triggered.

Sets off action nodes in the Dataflow when a source is modified.

Creates a new table of summarized values.

Adds new columns of values that are calculated from other columns.

Calculates the average from a set of input numbers.

Returns the minimum value of the selected number column in the input.

Returns the maximum value of the selected number column in the input.

Adds the total of all input numbers or values or adds all the values in a column.

A function that provides the length of the adjacent side divided by the hypotenuse length.

A function that provides the input number of a ratio between the long side (hypotenuse) and the side that is counter to an acute angle in a right triangle.

Removes the negative sign (-) in front of a number. It displays a positive number.

Rounds the input number to the highest integer number closest to the input.

Rounds the input number to the lowest integer number closest to the input.

Replaces the input number with the nearest integer number.

Divides two single numbers (of any type) or two columns of numbers.

Multiples two single numbers (of any type) or two columns of numbers.

Subtract two singles (of any type) or two columns of numbers.

Adds two single numbers (of any type) or two columns of numbers.

An editable text field that can be changed.

A number that can be changed into a decimal (float), integer, or an unassigned integer.

Output is true if the value of inputA is less than the value of inputB.

Output is true if the value of inputA is bigger than the value of inputB.

Output is true if the value of inputA and inputB are the same.

Evaluates if the condition of an input value is true or false.

Sends an email notification to a list of recipients when triggered.

Creates a new Data App when triggered.

Sets off action nodes in the Dataflow when a source is modified.

Produces a random number that remains the same regardless if the node is re-evaluated.

Produces a random number that regenerates every time the node is evaluated.

Generates a unit of measurement.

Generates a Date value.

Generates a value of currency.

Generates a true or false value.

Uppercase or lowercase a text column.

Reorders a set of columns in a table.

Remove rows from the top or bottom of a table.

Remove groups from an input table.

Takes several characters from the left or right side of the text as a new column.

Splits a column into multiple columns using a delimiter value.

Remove rows from the top or bottom of a table.

Keep rows at the top or bottom of a table.

Combines columns, entire tables, or both by joining them based on the columns and join direction selected.

Calculates the number of groups in a table.

Replaces the value of a cell for all rows that match a search condition.

Change the type, name, or type and name of columns.

Divides two single numbers (of any type) or two columns of numbers.

Renames a set of columns from a table.

Renames a set of columns from a table.

Trim columns and remove blank rows.

Extracts a set of columns from a table.

Append rows together, sharing columns with the same name and type.

Picks data from a Revit source.

Transforms JSON file to a table.

Locates text string within a JSON file.

Filters a JSON file.

Pick header row by index and infer types from the following rows. Also, setting zero keeps headers but re-evaluates column types.

Combines two text fields together.

Multiples two single numbers (of any type) or two columns of numbers.

Selects and copies a specific column from a table.

Outputs the position (index) of a value in a table.

Displays appended copies of the input value.

Displays all the rows between two specific positions.

Extracts the distinct values from an input array.

Calculates the number of rows in a table.

Outputs the row at a specific index in a table.

Provides the index of a specific value (opposite to ElementAtIndex).

Gives the position (index) of a value in a table.

Uses selected fields to sort table records in ascending or descending order.

Filters inputs based on values in a column.

Groups table records based on the selected field.

Treemap charts visualize data as a hierarchical set of nested rectangles. Each branch of the tree has a rectangle that is tiled with smaller rectangles denoting sub-branches.

Stacked bar chart shows how a larger section is divided into smaller sections and what the relation of each part has on the total amount.

Use scorecards to graphically represents your data. Scorecards are a great way to highlight a particular piece of information.

A pie chart is a circle that is divided into sectors that represent a proportion of the whole.

Line charts show data plotted as a range of data points called markers. Line charts are helpful to show how specific data changes over equal periods.

Horizontal bar charts work the same way as traditional bar charts except that they’re oriented horizontally.

Displays the input data as a gauge chart within the Dataflow. Use this tool to inspect your data.

Funnel charts visualize the progressive reduction of data as it goes from one phase to another. Data in each phase is categorized as different portions of the whole (100% of the total).

Donut charts function similarly to pie charts, but they can provide a better data intensity ratio since the circle’s center isn’t there.

A bar chart contains rectangular bars with lengths proportional to the values that they represent. While one axis of a bar chart compares particular categories, the other axis represents a distinct value.

Area charts are similar to line charts, except the area below the line is filled in with color. They represent the changes in quantitative values over equal periods.

Displays the input data in a tabular format. Use this tool to inspect your data as you build a Dataflow.