Beeline Enterprise reports are based on your data, and there are hundreds of fields you can include in reports. Functions let you filter and manipulate data retrieved from fields to create your desired outputs.
You can use Functions on Date and Financial fields. Plus, you can use a Static Value Function on some fields to create a fixed value in your reports.
Functions available on Date fields
Date fields measure time; they have functions such as "between", "since", or "until" certain dates.
| Date field | Description |
|---|---|
| #of Day | Numerical value for the day of the month. For example, the 15th day of January. |
| #ofMonth | Numerical value for the month of the year. For example, the 11 month in the year, which is November. |
| #of Year | Numerical value for the year, expressed as four digits. |
| Abbrev of Month | The abbreviated name of the month, such as Jan, Feb, and more. |
| Business Days Between | The number of recorded days separating specific events or timestamps, excluding non-business days before and after an event or timestamp. |
| Business Hours Between | The number of recorded hours separating specific events or timestamps, excluding non-business minutes before and after an event or timestamp. This allows you to quickly determine the working hours between two dates by excluding weekends and off-hours. It is essential for effective time management and compliance with labor laws. |
| Business Minutes Between | The number of recorded minutes separating specific events or timestamps, excluding non-business days before and after an event or timestamp. |
| Count | Count the number of occurrences. |
| Days Between | The number of days separating specific events or timestamps. |
| Days Since | Number of days that have elapsed after the value of a field was met. For example, the number of days after the Start Date of an assignment. |
| Days Until | Number of days before the value of a field is met. For example, the number of days before the Current End Date of an assignment. |
| Distinct Count | A data analysis concept that determines the number of unique items within a given dataset. It identifies how many different values exist rather than the total number of entries. |
| Hours Between | The number of hours separating specific events or timestamps. |
| Hours Since | Number of hours that have elapsed after the value of a field was met. For example, the number of hours after the Start Date of an assignment. |
| Hours Until | Number of hours before the value of a field is met. For example, the number of hours before the Current End Date of an assignment. |
| Length | The character length of the field. |
| Max | Maximum value of the field. |
| Min | Minimum value of the field. |
| Minutes Between | Ad hoc Function. The number of minutes separating specific events or timestamps. |
| Minutes Since | Number of minutes that have elapsed after the value of a field was met. For example, the number of minutes after the Start Date of an assignment. |
| Minutes Until | Number of minutes before the value of a field is met. For example, the number of hours before the Current End Date of an assignment. |
| Name of Month | Full name of the month, such as January, February and more. |
Functions available on Financial fields
The Functions available in Financial fields let you perform math operations or sum a column. Include them to report on "totals," "amounts" and "rates" to get insights into your program savings.
| Financial field | Description |
|---|---|
| % of Sum | The total value shown as a percentage. |
| Avg | Median value of the field. |
| Count | Number of occurrences. |
| Distinct Count | Determines the number of unique items within a given dataset. It identifies how many different values exist rather than the total number of entries. |
| Length | Character length of the field. |
| Math Operation | Gives you access to a Settings icon where you can define the math process used to solve problems. Math Operation lets you manipulate numbers or combine numbers to find totals, separate quantities to find differences, and group and share numbers into equal parts. |
| Max | Maximum value of the field. |
| Min | Minimum value of the field. |
| Percent Of Value | Expresses how much of the whole is represented by a specific field, shown as a percentage. This is helpful in simplifying the comparison of ratios and proportions or profit margins. |
| Rank | Groups fields in order. |
| Std Dev | A statistical measure that represents the amount of dispersion or variation of a set of values from its mean. It tells you how spread out the data is from the average or expected value. |
| Sum | Used to calculate the total of all non-null numeric values in a report. Helps summarize data effectively. |
| Var | Difference between a budgeted, planned or standard cost and the actual amount incurred/sold. Variances can be computed for both costs and revenues. Intrinsically connected with planned and actual results and the effects of the difference between those two on your program’s performance. |
Static Value functions
You can assign a Static Value function to some fields so that they have a fixed value in your reports. Assigning a Static Value function results in a consistent output value for that field. You can assign a Static Value function to a field when the specific data you want isn’t available in the exact format you need.
Here are a few examples of Enterprise fields to which you might assign a Static Value:
-
Billing Business Organization Name
-
Client Name
-
Cost Center Name
-
Work Location
When you assign a Static Value, you can use the Setting icon to open a Function Options dialog where you can define the Value for the field.