Calculated Column Overview
- 10 Nov 2021
- 2 Minutes to read
- Print
- DarkLight
This documentation version is deprecated, please click here for the latest version.
Calculated Column Overview
- Updated on 10 Nov 2021
- 2 Minutes to read
- Print
- DarkLight
Article summary
Did you find this summary helpful?
Thank you for your feedback
Overview
Calculated Columns are Data Fields that work to extend Report data. In the platform, these Calculated Column options can allow the user to incorporate other Designer Elements (e.g. Flows), get specific calculations for dates and time, decrypt sensitive Report data, and much more. The Calculated Column options are detailed below.
Calculated Column Options
| Calculated Column | Function |
|---|---|
| AddFieldByValue | Allow user to add value to selected Data Field |
| AddFields | Allows the user to add two Data Fields together |
| CombineTextFields | Allows the user to combine two Data Fields into one column |
| DivideFieldByValue | Allows the user to divide a Data Field by the desired value |
| DivideField | Allows the user to divide two Data Fields |
| EncryptedOrPIIDataField | Allows the user to decrypt encoded data defined when creating a Data Structure |
| FlowInlineField | Allows the user to define and run a Flow to perform lookups by displaying strings in a Report |
| GetDateAge | Shows the duration in the year, month, and days between the selected column date to the current. |
| GetDate | |
| GetDayofWeek | Get the day of the week from the selected Data Field |
| GetDaysBetween | Get days difference between two dates |
| GetHoursBetween | Get hours difference between two dates |
| GetMilliSecondsBetween | Get milliseconds difference between two dates |
| GetMinutesBetween | Get minutes difference between two dates |
| GetMonth | Get month number without year from selected Data Field
|
| GetRemainderFromFields | Get remainder from two Data Fields |
| GetSecondsBetween | Get seconds difference between two dates |
| GetTimesBetween | Get time difference between two dates |
| GetYear | Get year from selected Data Field |
| HideOldDates | Allows the user to hide or display null values from a Data Field based on the value provided in the Hide Dates Older Than field |
| ImageDocumentInlineField | |
| ImageUrlInlineField | |
| LiveUpdateColumnInlineField | |
| MatchInlineField | Adds a column where the user can put conditions to show different values on each row as desired |
| MatchRegex | Filters the RegexPattern provided by the user for a Data Field and displays only the rows where the RegexPattern is matched |
| MergeTextInlineField | Provides the Text Merge Editor where multiple Data Fields can be grouped together |
| MultiplyFieldByValue | Allows the user to multiply the value with selected Data Field |
| MultiplyFields | Allows the user to multiply two Data Fields |
| OpenURLInlineField | Allow user to construct an URL and provide a link at runtime to open that URL |
| PercentField | Allows the user to calculate a percent using two Data Fields |
| RunFlowInlineField | Allows the user to run a Flow from a Report |
| SplitCamelCaseInlineField | Return column data in Camel Case form |
| SubtractFieldByValue | Allow the user to subtract value from selected Data Field |
| SubtractFields | Allows the user to subtract two Data Fields |
| TimespanTotalSecondsField | Displays timespan in seconds |
| TimespanTotalMinutesField | Displays timespan in minutes |
| TimespanConstantFormatField | Displays timespan in a constant format: (hh\:mm\:ss) |
| TimespanCustomFormatField | Displays timespan in a custom format, the default format is “hh\:mm\:ss” and with this column, the user can change the format |
| TruncateTextInlineField | Displays the shortened value of another Data Field |
| YesNoInlineField | Displays Yes or No values and can be used with a Boolean column; a Boolean column shows True or False values |
Was this article helpful?
