← All features

Canvas nodes

Pivot

Turn distinct values into columns and summarize each group.

How it works

Choose the fields that define rows and the field whose values should become columns. Select an aggregation to fill the resulting grid.

Click Pivot on Canvas to open its settings and output. The output counts each product under its sales channel.

Simple example

Set Product as the row field and Channel as the source of new columns, then choose Count. The output has a row per product and a count for each sales channel.

Pivot selected in n0is Canvas in the simple example.
n0is Canvas · Sample dataView full size

Input

5 rows
ProductChannel
MugOnline
MugOnline
MugStore
BowlStore
BowlOnline

Node output

2 rows
ProductOnlineStore
Mug21
Bowl11

Complex workflow

Filter to paid orders, then pivot by Region and Product with Channel as the column field. Sum Amount in each cell to compare paid sales across channels for the same region and product.

Pivot selected in n0is Canvas in the complex workflow.
n0is Canvas · Sample dataView full size

Input

5 rows
RegionProductChannelStatusAmount
NorthMugOnlinePaid32
NorthMugOnlinePaid48
NorthMugStorePaid24
SouthMugOnlinePaid57
SouthBowlStorePaid82

Node output

3 rows
RegionProductOnlineStore
NorthMug8024
SouthMug570
SouthBowl082