Override Values in Sheets enabled DW

Overview

You can override values in Sheets-enabled Discovery Wizard. For that, you need to have three values -Calculated Value, Input Value, and Resolved Value. The Calculated Value is the default value, Input Value is 0 and the Resolved Value is the override value. If the Input Value is greater than 0, then the Input Value becomes the Resolved Value and if the Input Value is 0, then the Calculated Value becomes the Resolved Value. Here

Step-by-Step Guide

1. Add Calculated and Resolved Value (Override Value) to your Excel model. Use the 'if' function to override the Calculated Value with Resolved Value. However, if there is a range of items, use the 'sum if' function.

   
   

2. We can see that when the Input Value is greater than 0, the Input Value becomes the Resolved Value. While, when the Input Value is 0, the Calculated Value becomes the Resolved Value.

   
   
3. Follow the steps to Add a Table in Sheets enabled DW.

4. If the Input Value is greater than Calculated Value then the Input Value becomes the Resolved Value and vice versa.

   
   

Resetting the Input Value

1. Follow the steps to Copy the Code Reference of Variables in Sheets enabled DW.

   
   

2. Copy the code reference of Calculated Value and Input Value and save it on your Notepad.

   
   
3. Follow the steps to Edit Group Variable.

4. Just BEFORE the "tabs", paste the below code:

      "google_sheets_override_variables": [
      {
        "Input Value - 549258": "Calculated Value - 8286cc"
      },
      {}
    ],

5. Paste the code references of Input Value and Calculated Value within the inverted commas as shown above.

6. Click Save.

7. Click Discovery Wizard on the Visualizer Type page.

8. A new icon appears next to the value whose code reference has been added in the Group Variable.

   
   
9. Click the icon to reset the value.

10. You can see that the value is reset.