Adding Formulas in Data Aggregator

Owned by Mahisha Chandrakumar CTOO (Unlicensed)
Last updated: May 08, 2023 by DevaDarshini.S

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.

    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.

    Tip

    Complex formulas for derived columns based on conditions can be specified in any of the following ways:

    • Using the CASE WHEN expression in the SQL select statement while creating the datasource in Studio

    OR

    • For other samples of  Java Expression Language (JEXL) operators, Refer JEXL operators.
  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.

Copyright © Intellect Design Arena Limited.

All rights reserved. These materials are confidential and proprietary to Intellect Design Arena Limited and no part of these materials should be reproduced, published in any form by any means, electronic or mechanical including photocopy or any information storage or retrieval system nor should the materials be disclosed to third parties without the express written authorization of Intellect Design Arena Limited.