Flag During a Calculation

Flag During a Calculation

During a calculation, you may wish to flag your output data set. The Flags section allows you to:

  • Use the current Flag to your calculated data as set for the input variable
  • Change to a new flag from the available Flags
  • Calculate or compute the conditions for using Flag(s)

Note

If you choose to use a conversion table during your calculation, then you may not Use Current Flag with your data.

Use Current Flag

To continue flagging your output data with the same flag as set for the input variable, you can select to Use Current Flag. However, if you choose to use a conversion table during your calculation, then you may not Use Current Flag with your data.

 

Change Flag

To choose an alternative flag for your output data, you apply a Flag from the drop down menu in the Output Flag panel.

 

Calculate Flag

Using the Flag Index number, the Flags can be defined according to logic given in the flag formula box.

For example you can use an IF statement:

  • Enter IF(a>#,x,y) into the Output Flag Formula box where 'a' is the variable, # is a real value, and x and y are the Flag Index Numbers.
    • Where the value for variable 'a' is greater than #, the output result will be flagged x.
    • Otherwise the output result will be flagged y.

You can use any valid logic in combination with Operators to customise your Output Flag conditions.

Note

The Calculation process tag will be automatically assigned to your data when you perform a calculation. Data that has been processed using the calculation tool can be identified by filtering by the Calculation process type in the main filter panel.

 

See also:

  • Set Flags
  • Formulae
  • Conversion Tables

    • Related Articles

    • Calculation Templates

      DataSight allows you to save your Calculation as a template that can be accessed later: To pre-fill level, variable, time shifting, formula, flags and output fields in Calculation as defined in the saved template. To be used as reference by any other ...

    • Set Flags

      To create, modify or delete Flags, select Flags on the DataSight Ribbon. The Flags grid view appears listing the existing database flags. Add a Flag Select Flags tab in the Main Panel. Click New on the Quick Access Toolbar. The Flag window appears. ...

    • Flags

      DataSight Flags can be used to assign and visually identify data for quality coding or quality assurance purposes. Flags are user-defined subjective categories, that are database specific and can be used to: Communicate to multiple stakeholders the ...

    • Graphical Flagging

      Graphical Flagging allows you to assign your user-defined flags to data points using a graphical interface. You can use the tool to quickly identify and visually flag a continuous series of data. In much the same way as Standards, the Graphical ...

    • Permissions

      DataSight application security allows administrators to enable and disable modules in DataSight for different accounts, as well as configuring Row Level security to enable and disable access to data based on Levels and Flags. If a user is granted ...