Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

Perform the following steps to derive formulas for the data columns in Sigma Studio:

  1. Click Data Builder and collate data based on your requirement.

    Tip

    Refer Creating Data Aggregator for Complex Report – Sample 1 for more information on collating data sources using Data Builder.


  2. Click any child data.

    All the data information appears on the right-hand side of the page.

  3. Click Derived Columns tab.

  4. Provide name for the new column in Derived Column ID field.

  5. Enter the formula for the column in Formula field.

  6. Click Save.
  7. 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.

  8. Click Save to save the data aggregator.