Using parameters
A parameter is a container or a placeholder such as a number, date, or string that can replace a constant value or a list of values. Create Worksheet parameters to optimize your data inquiries. Use parameters to run different scenarios with adjustable values, without creating or modifying the constants in formulas for each new value.
Parameters are useful for 'what-if' analysis, financial planning, cohort analysis, and so on. When you create parameters for your Worksheet, you guide users in their exploration of the data as they search on your Worksheet.
To learn how to create parameters, see Create parameters.
Using parameters
Use parameters within formulas to run different scenarios when searching on your data or viewing Liveboards or Answers. For example, you may want to forecast your sales for the next month, based on various rates of growth. You might create a parameter, called growth %, with a range from 0 to 1 and a default value of .1. Then, you create a formula called profit forecast, defined by profit * (1 + growth %). You can then create Answers and Liveboards that use this formula and change the parameter value to view your forecasted profit if your sales grow by 25%, 53%, and so on.
Parameters work like column names in formulas, but appear in green. For more information about formulas, see Add a formula to a search.
Changing parameter values in an Answer
When you create or view an Answer that contains a formula with a Parameter, you’ll know: ThoughtSpot displays the name of the parameter and its current value below the Answer description, in the row where it displays filters.
To change the parameter value, follow these steps:
-
Navigate to the Answer you would like to change the parameter for.
-
Select the parameter in the filter/parameter row.
-
The parameter dialog appears. To view more information about the parameter, such as how to use it and what data type it supports, hover over the information icon next to the parameter name:
-
Depending on the type of parameter, you may see a text box or a list of values. Above the text box, you may see a range of values you can use; for example, you may see "Enter a value between 0 and 10000."
If there is a text box, enter a value in the text box that is valid for the data type and is within the specified range, if there is one. If there is no range, enter any value that is valid for the data type. For example, if the data type is
integer, you can’t enter a decimal such as6.4.If there is a list of values, select the value you would like to use.
-
If you would like to return the parameter to its default value, select Reset to default in the lower left corner of the dialog.
-
After you enter a new value or reset the value to the default value, select Apply.
Changing parameter values in a Liveboard
When you create or view a Liveboard that contains a formula with a parameter, you’ll know: ThoughtSpot displays the name of the parameter and its current value below the Liveboard description, in the row where it displays filters.
If the parameter is not currently in use for any visualizations in the Liveboard, it does not appear for users in view mode. To ensure that all users can see and use the parameter, follow these steps. You must have edit access for the Liveboard.
-
Select the Edit button at the upper right of the Liveboard. If this button is grayed out, you do not have edit privileges for the Liveboard. To resolve this, contact your administrator or the creator of the Liveboard.
-
In the top menu bar that appears, select + Add parameter.
-
The Parameters sidebar appears at the left edge of your screen. Double-click on any parameter you would like to add, or select the edit icon
that appears when you hover over the parameter name. -
The parameter dialog appears. To view more information about the parameter, such as how to use it and what data type it supports, hover over the information icon next to the parameter name:
-
Depending on the type of parameter, you may see a text box or a list of values. Above the text box, you may see a range of values you can use; for example, you may see "Enter a value between 0 and 10000."
If there is a text box, enter a value in the text box that is valid for the data type and is within the specified range, if there is one. If there is no range, enter any value that is valid for the data type. For example, if the data type is
integer, you can’t enter a decimal such as6.4.If there is a list of values, select the value you would like to use.
-
If you would like to return the parameter to its default value, select Reset to default in the lower left corner of the dialog.
-
After you enter a new value or reset the value to the default value, select Apply.
-
Select Save in the upper right corner of your screen.
To change the value of a parameter from view mode for a Liveboard, follow these steps. Note that if you only have view access to a Liveboard, you can’t save the Liveboard with the altered parameter value.
-
Navigate to the Liveboard you would like to change the parameter for.
-
Select the parameter in the filter/parameter row.
-
The parameter dialog appears. To view more information about the parameter, such as how to use it and what data type it supports, hover over the information icon next to the parameter name:
-
Depending on the type of parameter, you may see a text box or a list of values. Above the text box, you may see a range of values you can use; for example, you may see "Enter a value between 0 and 10000."
If there is a text box, enter a value in the text box that is valid for the data type and is within the specified range, if there is one. If there is no range, enter any value that is valid for the data type. For example, if the data type is
integer, you can’t enter a decimal such as6.4.If there is a list of values, select the value you would like to use.
-
If you would like to return the parameter to its default value, select Reset to default in the lower left corner of the dialog.
-
After you enter a new value or reset the value to the default value, select Apply.
