Simple Report
Introduction
Simple Report creates a summary of values in an entryset. It can calculate the sum, average, count, variance, min, max, average or standard deviation of entries in an attribute. For example, Simple Report can determine the maximum "Price" for each "Date" or the sum of all "Revenue" generated by each "Salesperson".
To configure the Simple Report, you must first connect an entryset with a minimum of two attributes to its "Set Entryset" input connector. Then, use the Property Panel to specify which calculation and attributes the report targets. Additionally, you can change which attributes the report targets with the "Set Group-by Attributes" and "Set Process Attributes" input connectors. The report created is an entryset with as many attributes as are selected to Group-by and Process, one for each selected Process attribute and one for eacb Group-by attribute.
Property Panel:
Simple Report Properties
- Function
- The function to apply to the selected Process attributes.
- Sort output
- Whether to sort the output entryset.
- Process Attributes
- Specifies which attributes the report function is applied to. The contents of the Process attributes are first grouped by the Group By attributes and then processed by the Report function. Multiple attributes can be selected by holding down "Ctrl" and clicking the attribute names.
- Group-by Attributes
- Each entry with the same value for this attribute has the values in its Process attributes grouped together and they are then processed by the Report function. Multiple attributes can be selected by holding down "Ctrl" and clicking the attribute names.
Input Menu:
Set Entryset
Sets the entryset from which the report is generated.
Accepted Datatypes:
- Entryset
- An entryset with at least two attributes.
Triggered Outputs:
- Output Message:
- Get Report
Set Group By Attribute
Sets which attributes stores the entries' name, which is used to group the values processed by the report.
Accepted Datatypes:
- Text or an entryset
- Name of an attribute in the entryset a list of attributes in the entryset
Triggered Outputs:
- Output Message:
- Get Report
Set Process Attribute
Sets which value attribute the report function is applied to.
Accepted Datatypes:
- Text or an entryset
- Name of an attribute in the entryset or a list of attributes in the entryset
Triggered Outputs:
- Output Message:
- Get Report
Output Menu:
Get Report Entryset
Gets an entryset containing the report.
Output Datatype:
- Entryset
- The entryset that results from the defined grouping and processing.
Triggered By:
- Input Message:
- Set Entryset
- Input Message:
- Set Group By Attribute
- Input Message:
- Set Process Attribute
- Action:
- Fire-On-Connect