Unable to Pass Multiple Values in an Action from a Single Mark

Resolution

CLICK TO EXPAND STEPS

Option 1: Filter Actions

For Filter Actions, it is possible to create a view where the end user clicks the header to pass multiple dimension member values. The attached example workbook uses the sample data set Superstore to demonstrate the following directions:

Step 1: Create the source Sheet

Select Analysis > Create Calculated Field
In the Calculated Field dialog box that opens, do the following, and then click OK: and Name the calculated field. In this example, the calculated field is named "Click Here".
- In the formula field, create a calculation similar to the following:
- "Click this text to navigate to 'Target Sheet' >"
Drag [Click Here] to the Rows shelf.
Drag [Customer Name] to Detail on the Marks card.
In the dropdown on the Marks card, select Polygon.
Navigate to Format > Borders…
In the left-hand Format Borders pane, under Row Divider, for Pane, select None and close the Format Borders pane.
Navigate to Analysis > Table Layout > uncheck Show Field Labels for Rows.

Step 2: Create the dashboard

Drag "Sheet 1" and "Source Sheet (filter)" onto a dashboard.
Right-click the Customer Name filter and select Apply to Worksheets > Selected Worksheets…
In the Apply Filter to Worksheets dialog, check Source Sheet and click OK.
Navigate to Dashboard > Actions…
In the Actions dialog click Add Action > Filter…
In the Add Filter Action dialog, do the following:
- For Source Sheets, check only Source Sheet (filter).
- For Run action on, choose Select.
In the dropdown menu under Target Sheets, select Target Sheet (filter).
Click OK in each open dialog to close them

CLICK TO EXPAND STEPS

Option 2: URL Actions

For URL Actions, it is possible to send a table calculation that creates a comma separate list of values, which will then be used to filter the published view. The attached example workbook uses the sample data set Superstore to demonstrate the following directions:

Step 1: Create the source Sheet

Select Analysis > Create Calculated Field
In the Calculated Field dialog box that opens, do the following, and then click OK:
1. Name the calculated field. In this example, the calculated field is named "Click Here"
2. In the formula field, create a calculation similar to the following: "Navigate to published target sheet"
Drag [Click Here] to the Rows shelf
Drag [Customer Name] to Detail

Create a calculated field with a name like "Feeder Calc" with a calculation similar to the following:

IF FIRST()= 0
THEN MIN([Customer Name])
ELSEIF MIN([Customer Name]) != LOOKUP( MIN([Customer Name]), -1 )
THEN PREVIOUS_VALUE("") + "," + MIN([Customer Name])
ELSE PREVIOUS_VALUE("")
END

Create a calculated field with a name similar to "Value to Send in URL Action" with a calculation similar to the following:
```
IF LAST() = 0
THEN [Feeder Calc]
END
```
Drag [Value to Send in URL Action] to the Rows shelf
Right-click [Value to Send in URL Action] on the Rows shelf and select Compute Using > Customer Name
Right-click [Value to Send in URL Action] on the Rows shelf and uncheck Show Header
Navigate to Format > Borders…
In the left-hand Format Borders pane, under Column Divider, for Pane, select None and close the Format Borders pane
Navigate to Analysis > Table Layout > uncheck Show Field Labels for Rows

Step 2: Create the dashboard

Drag "Sheet 2" and "Source Sheet (url)" onto a dashboard
Right-click the Customer Name filter and select Apply to Worksheets > Selected Worksheets…
In the Apply Filter to Worksheets dialog, check Source Sheet and click OK
Navigate to Dashboard > Actions…
In the Actions dialog click Add Action > URL…
In the Add Filter Action dialog, do the following:
1. For Source Sheets, check only Source Sheet (url)
2. For Run action on, choose Select
3. For the URL, enter something like: {URL of published view}?Customer Name=<AGG(Value to Send in URL Action)>
Click OK in each open dialog to close them