How to Create New Variables using Manual

How to Create New Variables using Manual

Users can manually create variables by navigating to the Manual tab located at the top left of the screen. In this section, they can specify a name for the new variable. For example, to scale down a TV-related variable by 1000, the user might name it TV_1000. In the Define Formula field, the specific variable to be modified can be entered. As the user types, the system displays matching variables for easy selection.

After defining the formula, the user can click the Add button on the right side. This action adds the new variable to the list under New Variables on the right side of the screen. For instance, to create a total variable by adding multiple variables, the user can enter the formula (variable1 + variable2 + variable3) and click Add again.

For more complex operations, such as using SQL functions to split a variable by time periods, users can also utilize the Manual tab. For example, to split the variable TV_GRP into different time periods for differential coefficients, a SQL CASE WHEN statement can be employed:

CASE WHEN 'Date' BETWEEN '2017-01-01' AND '2019-12-28' THEN 'variable' ELSE 0 END

In this example, the values in quotes represent respective columns in the data cube. After defining the formula, users should click the Add button to save it. Note that the variables are only saved at this stage; to create them and display them on the Data Classification page, users must click the Generate Variables button located at the bottom right of the page.


    • Related Articles

    • Create New Variables

      The "Create New Variables" feature enables users to generate a variety of variables, including event flags, dummy variables, holiday indicators, and seasonality variables. Users can perform arithmetic operations and SQL actions to split variables by ...

    • Finalizing Variables and Importing/Exporting in Create New Variables

      Finalizing Variables After creating all variables—whether manually, through event flags, holidays, or seasonality—users must click the Generate Variables button located at the bottom right of the screen to finalize them. The platform will ...

    • How to Create Event Flags using Create New Variables

      To create event flags, users should navigate to the Event Flag tab. Here, they can enter the name of the event, such as Election. If the event is recurring annually, users can add multiple dates by clicking the Add Date link located below the date ...

    • Variable Classification Process Using Subgroups

      Steps for Classifying Variables into Subgroups To classify variables under a subgroup, users should click on the expand icon next to the main bucket (e.g., Media). Users can either create a new group within the main bucket or select an existing ...

    • Guide to the All Projects Screen and Project Creation Process

      All Projects Screen When you log in to the URL, you will land on the All Projects page. When you log in for the first time, you may see a blank page with only a ‘Create New’ button at the top right-hand side of the screen. If you have created ...