MashZone NextGen 10.2 | Appendix | Legacy Presto components | Mashables and Mashups | Mashups in MashZone NextGen Wires | Creating Mashups in Wires | Add Actions or Other Blocks | Pivot Data
 
Pivot Data
The Simple Pivot action allows you to ?aggregate calcs based on distinct values of one field and group by another ? flattened to simple records
group results into two levels, get an aggregate calculation on subgroups (the second level) and flatten the result into a simple"table" of records and fields. This is similar to pivot tables in spreadsheets.
With results in the following form, for example:
records
+ record
- salesperson
- item
- region
- qty
You could use the Group action to get subtotals by region for each item. The results would have one record for each unique item-region combination. If you group on the item field and subgroup by region the results look something like this:
records
+ record
- salesperson
- item
- north
- east
- south
- west
- central
The columns for north through central each contain the subtotal for that region.
Pick a record table to pivot data
The repeating record that identifies the table of data to pivot. This defaults to the first repeating record in the results you have connected as input to this block.
Click in this field to select a different repeating record. See Select Fields or Paths for Block Properties with the Path Selector for more information.
Pick a field to group records on
Click in this field to select the field for the top level grouping of this pivot table. See Select Fields or Paths for Block Properties with the Path Selector for more information.
The unique values for this field are used to group records from the results.
Pick a field to generate column headers
Click in this field to select the field for the second level of grouping for this pivot table. See Select Fields or Paths for Block Properties with the Path Selector for more information.
Each unique value of this field adds a column to the result records for this block with the aggregate calculation for that subgroup. The new column name is the corresponding unique value.
Note: Actual column names may not match the unique values exactly because they must meet XML name standards. Wires automatically alters column names to meet this requirement.
Pick a field to aggregate values for specified group & column
Click in this field to select the numeric result field to use in aggregate calculations for the selected subgroup. See Select Fields or Paths for Block Properties with the Path Selector for more information.
How would you want to aggregate values?
Select the aggregate function you want to apply to subgroups from the list:
*Average
*Count
*Maximum
*Minimum
*Sum
Or use the Path Selector to supply the function name dynamically. See Select Fields or Paths for Block Properties with the Path Selector for more information.

Copyright © 2013-2018 | Software AG, Darmstadt, Germany and/or Software AG USA, Inc., Reston, VA, USA, and/or its subsidiaries and/or its affiliates and/or their licensors.
Innovation Release