Perform the following steps to derive formulas for the data columns in Sigma Studio:
Click Data Builder and collate data based on your requirement.
Refer Creating Data Aggregator for Complex Report – Sample 1 for more information on collating data sources using Data Builder.
Click any child data.
All the data information appears on the right-hand side of the page.- Click Derived Columns tab.
- Provide name for the new column in Derived Column ID field.
- Enter the formula for the column in Formula field.
- Click Save.
- Once the derived column is saved, it gets displayed on the right side. You can also delete the derived column by clicking the close icon.
- Click Save to save the data aggregator.
Add Comment