You can modify the parameters of a formula in the Template sheet of the spreadsheet.
Prerequisite
A table view is created for the query or the ad-hoc analysis.
Procedure
Start the query or the ad-hoc analysis.
Click Output if the table is hidden.
Activate the Data tab bar.
Click the cell for which you want to change the parameters.
This example shows a function with 4 parameters:
=QUERY_ITEM("73fda0fc-eab0-42ba-adaf-9b019da5918e";TRUE;TRUE;B2)
The first parameter is the item’s ID (GUID of the model) followed by TRUE. This value represents the Align result. True means Vertically (False means Horizontally). The next parameter TRUE means Merge result (FALSE means do not merge). The last parameter defines the Relationship to cell. In this case B2. That means that the item in cell B2 (Group) is superordinate to the Model. This parameter is optional.
If you move the mouse pointer to cell C2 (Model), the parameters are shown.
Double-click cell C2 (Model) allows to change values:
Modify the settings as required and click OK. The changed parameters are used in the formula.
You have changed the parameters used in this formula.
If you cannot see the changes, refresh the view (F5) or click a different cell and then back to this one.