Create and Edit Custom and Favourite Variables

Users have the ability to create and edit custom and favourite variables for mapping and reporting.

Create a Favourite Variable
Create and Edit Custom Variables Using the Aggregated Calculation Method
Create and Edit Custom Variables Using the Formula Calculation

                                                                                                                                                                        

Create a Favourite Variable
1. In the side panel, select My Data > Variables

2. Click Create New.

mceclip0.png

2. Click Favourite. The following dialog box will appear.

mceclip11.png

3. From the Select a data source drop-down list, choose the dataset which includes your variable of interest. You may also search for the name of the variable using the Search bar. 

4. Expand the categories and click the box beside the variables you'd like to select as your Favourites.

mceclip12.png

5. Click Create. A status message indicating that the variable has been created will appear in the lower right corner of the screen.

6. To view a full list of your favourite variables, navigate to the side panel and select My Data > Variables

Tip: You can reorder your variables by dragging and dropping them within the Order column. Favourite and custom variables will be grouped together.

                                                                                                                                                                        

Create and Edit Custom Variables Using the Aggregated Calculation Method
1. In the side panel, click My Data > Variables.

2. Click Create New.

mceclip0.png

  • Custom Variables are created by using a calculation
  • Favourite Variables have been flagged for future use in one of the other datasets

3. Click Custom. The following dialog box will appear.

mceclip2.png

4. In the Name field, type the name of the new variable that you wish to create.

5. In the Category Description drop-down list, choose Custom.

Tip: You can also create your own category. To create a new category, type the name in the Category Name field. Ensure you press Enter or Tab, or your newly created Category Description will not be saved. 

mceclip5.png

6. You can add a description in the Description box.

7. You can add any tags that you would like to include in the Tags box. 

8. Click Create. A status message indicating that the variable has been created will appear in the lower right corner of the screen.

9. Click the name of your new variable in the Variables List or Design Variable in the status message.

 

Edit Custom Variables
These steps will focus on the Formula Builder section of this page.

1. In the Dataset list, choose the dataset you wish to use. mceclip6.png

2. In the Calculation Method list, choose Aggregate.

3. In the Output Variable Type menu, choose Count or Consumption.

  • Choose Count to sum the number of items selected
  • Choose Consumption when reporting on dollars and volumetric data, to work with consumption reports

Tip: If you are creating a custom variable based on consumption variables, you need to choose Consumption in this menu. Note that when you choose Consumption, it acts as a filter and only shows the consumption variables in the variable list from the chosen dataset.

4. In the variables list to the right of the formula bar, select the variables that you would like to use. You may also search for the name of the variable using the Search bar. 

mceclip0.png

5. Drag and drop the selected variable into the Formula box.

Note: The benchmark should be populated automatically when you select the first variable.

6.  Drag and drop the second variable into the Formula box.

Note: If you chose the Aggregate Calculation Method, there is no need to add a plus sign (+). Any variables chosen will automatically be added together.  

mceclip1.png

7. When you are finished, click Save changes. A status message indicating that the variable has been saved will appear in the lower right corner of the screen.

Caution
There are some intricacies users should be aware of when creating custom variables:

  • This is not a cross-tab tool, it will not uniquely merge variables (adding two variables together will not result in identifying individuals who do both activities)
  • You should use variables from the same database and the same category
  • Do not use variables in the same formula which have different benchmarks
  • Custom consumption variables should only be used in Consumption tool
                                                                                                                                                                        

Create and Edit Custom Variable Using the Formula Calculation Method
1. In the side panel, click My Data > Variables

2. Click Create New.

mceclip0.png

  • Custom Variables are created by using a calculation
  • Favourite Variables have been flagged for future use in one of the other datasets

3. Click Custom. The following dialog box will appear.

mceclip3.png

4. In the Name field, type the name of the new variable that you wish to create.

5. In the Category Description drop-down list, choose Custom.

Tip: You can also create your own category. To create a new category, type the name in the Category Name field. Ensure you press Enter or Tab, or your newly created Category Description will not be saved. 

mceclip5.png

6. You can add a description in the Description box.

7. You can add any tags that you would like to include in the Tags box.

8. Click Create. A status message indicating that the variable has been created will appear in the lower right corner of the screen.

9. Click the name of your new variable in the Variables List or Design Variable in the status message.

 

Edit the Custom Variable
These steps will focus on the Formula Builder section of this page.

1. In the Dataset list, choose the dataset you wish to use.

2. In the Calculation Method list, choose Formula.

There are three Variable Output Types:

  • Count is used to add-up the number of items selected
  • Consumption is used for dollars and volumetric data, to work with consumption reports
  • Relative is used for calculations of medians, percentages, and averages so that they are formatted properly in reports and placed in the right column

3. In the Output Variable Type menu, choose Relative.

4. Use a combination of the variables list and formula buttons to build a formula similar to the example shown and detailed below.

mceclip3.png

i. Begin by selecting the open bracket.

ii. Click to add a second open bracket to ensure the order of operations is maintained.

iii. From the variables list, drag and drop the appropriate variable you may need to expand more than one section to find the variables you are looking for.

mceclip1.png

iv. Click the plus sign (+) in the Formula toolbar. 

mceclip8.png

v. Continue to add any other variables, separating them with additional plus signs (+).

vi. Once complete, place a closing bracket at the end of the formula.

vii. Click the division sign (÷).

viii. Drag and drop the benchmark.

ix. Place another closing bracket after the benchmark.

x. Click the multiplication sign (x).

xi. Click Numeric, type 100, and click Add.

   mceclip9.png

xii. Click Save changes. A status message indicating that the variable has been saved will appear in the lower right corner of the screen.

5. To view a full list of your custom variables, navigate to the side panel and select My Data Variables.

Caution
There are some intricacies users should be aware of when creating custom variables:

    • This is not a cross-tab tool, it will not uniquely merge variables (adding two variables together will not result in identifying individuals who do both activities)
    • Generally, you should use variables from the same database and the same category
    • Do not use variables in the same formula which have different benchmarks
    • Custom consumption variables should only be used in Consumption tools
Powered by Zendesk