Running Total tool
The Running Total tool calculates a cumulative sum on a numeric field per record in a file.
Open the Candy Production datafile, then use the Input Data tool to bring the file onto the workspace. Next, locate the Running Total tool under Transform and drag it down onto the workspace. Connect the Running Total tool to the Input Data tool.
Look for the "Create Running Total" box in the Configuration Pane and select "Candy Total".
Now Click on RUN. A new column, RunTot_CandyTotal has been added to the spreadsheet. This column contains the running total of all boxes of candy packed by all workers.
Go back and in the box, "Group By" in the Configuration Pane, select Salesperson and run the workflow again.
Once the workflow is run, the RunTot_CandyTotal is now a running total of candy packed and is grouped by worker.
Summarize tool
The Summarize tool can conduct a host of summary processes such as grouping, summing, and count.
Disconnect and delete the Running Total tool from the Candy Production datafile in the last workflow. Locate the Summarize tool under transform, drag it onto the workspace and connect it to the Candy Production datafile.
Click to select the field to perform summaries on. Use the Select drop-down to the right to make multiple field selections.
First, highlight the field to use.
Click on Add to add the field to the Actions box. Next, use the dropdown menu to specify the summary action to be taken. Summary actions are defined by the data type added, so some actions maybe grayed out and unavailable. For this workflow, select "Group By" for Salesperson and "Sum" for CandyTotal. This will give us a total of candy packed by each person.
Click in the "Output Field Name" to change the name of the field.
When finished with selections, run the workflow and view results.
The results show a list of each salesperson and the number of boxes of candy packed by that person.
Copyright © Baylor® University. All rights reserved.
Report It | Title IX | Mental Health Resources | Anonymous Reporting | Legal Disclosures