Compute Expression : to generate derived fields.
Merge with Source will merge compute expression fields with existing dataset fields.
Place SAQL in compute expression
Connect new node in dataflow and update the dataflow.
Recommended to run the dataflow after updating it.
Compute expressions work on a same row.
Compute Relative. Best usecase is change from previous.
Take snapshots of opportunities every month with its current state and amount.
Need to reorder the records from snapshot so that computations between previous can be done properly.
If you have built a dataset from CSV, than use edgeMart to add it to the dataflow builder.
Select "Partition By" as "opportunity name" here so that we can do relative analysis of same opportunity.
Selected expression type as source field as it reads actual field for comparison.
Selected expression type as SAQL
Add a register to dump these in a dataset.
You can add filter nodes to filter the datasets
You can create manual snapshotting of dataset. Using EdgeMart select a existing dataset and than register it.
After dataflow is run, again go to edgeMart and select DSTrended dataset generated from above step and append it to loadDS dataset. Connect it to register DSTrended dataset.
You can schedule this dataflow based on at what frequency we need to snapshot the data. This usecase will help in auditing data where snapshots need to be captured.
Another way to create snapshots is using "Snapshot Analytics" app template.
Slice can be used to drop some fields.
Flatten: it computes the closure so that people higher in the hierarchy can see the records owned by their Childs.
Always download JSON of dataflow before updating so that you have a backup copy.
Do not put filter on digest node as it applies to entire dataflow when other sections of dataflow might need those tuples. Instead use filter nodes and insert them at required points.
If you want to add fields, add them in sfdc digest node.Also N/A values mention them as default value in digest node. Then click on propagate so that those changes flow in a downstream.
