Activity III: Create a visualization component that allows a user to filter the data based on the store type

Using the data table from the Excel Reader node, summarize the total sale for individual customers and the store type with a GroupBy node.
- Select CustomerID and StoreType as groups.
- Choose the following aggregation methods
  - First for AgeGroup, CustomerGroup
  - Sum for Price
  - Unique Count for ProductNr
Create a component to visualize the aggregation results for a store type specified by a user
- Ask a user to select a store type (online or onsite) with the Value Selection Configuration node. Use the Dropdown menu on the StoreType column (make sure to lock the column), with Online Store as the default. Pass on the selection as the flow variable store_type.
- Filter the aggregation table by a store type using a Row Filter node. The Column to test is the StoreType column. For the matching pattern, make a flow variable connection from the Value Selection Configuration node and use the flow variable store_type.
- In preparation for visualization, use a Color Manager node to assign colors to different classes of the First(AgeGroup) column.
- Use the following four view nodes to visualize the data in four separate branches, with one view node per branch:
  - Table View
  - Scatter Plot: set horizontal dimensions to Sum(Price), vertical dimensions to UniqueCount(ProductNr), and color dimension to First(AgeGroup)
  - Bar Chart: choose First(AgeGroup) and occurrence count
  - Parallel Coordinates Plot: exclude CustomerID and StoreType
- Wrap all the nodes after the GroupBy node into a component. Adjust the composite view layout, if desired. The resulting component can be configured to select a desired store type.

01_Flow Variable and Component - Solution

Used extensions & nodes

KNIME Base nodesTrusted extension

KNIME Excel SupportTrusted extension

KNIME JavasnippetTrusted extension

KNIME Quick FormsTrusted extension

KNIME ViewsTrusted extension

Legal

KNIME Base nodes

KNIME Excel Support

KNIME Javasnippet

KNIME Quick Forms

KNIME Views