Looking to create a hover button for dashboard navigation.

@Darshan Patel​ Hi Darshan

I have created a new dashboard labelled Seg Dashboard Solution with few changes. Here are the steps taken.

Step 1

After duplicating the Seg Dashboard, a new worksheet called Dynamic Button Report is created.

Then a parameter called [Button Selection] is created.

This parameter will later allow us to switch between Unfilled and Filled variants of the Report button using Actions.

Step 2

Then a new calculated field called [Dynamic Button Report] is created.

This calculation states that when the parameter selection is set to Filled then this field will output Filled, while Unfilled will be the output when the parameter is set to another value that is not Filled.

In the Marks card, change the Mark type to Shape from the picklist.

Then, place this calculated field into the Marks card inside the Shape box and click on the Shape button to select the relevant images.

NOTE: In this solution, we are using the parameter we created earlier to switch between the two shapes dynamically. So first, set the [Button Selection] parameter value to either Filled or Unfilled first before assigning the shape.

Once one of the shapes is assigned, come back out to the worksheet level and set the [Button Selection] to another value and repeat the image assignment process.

Once done, both images would have been assigned and this can be confirmed by switching between the different values in the parameter and seeing the images change.

Step 3

Create a calculated field [Filled Selection]. In this calculated field, it is simply a string between single quotation marks.

'Filled'

Step 4

Place [Filled Selection] in the Detail box of the Marks card in the worksheet Dynamic Button Report. By now, we should be able to see something similar to the image below.

Step 5

Then we will create a calculated field called [Unfilled Selection].

Once again, this is simply a string between two single quotation marks.

'Unfilled'

We will explain how this is used in the next steps.

Step 6

Go to the worksheet Segment.

Drag and drop the calculated field [Unfilled Selection] into the Detail box of the Marks card.

Step 7

Create a new worksheet called Segment Dashboard Title.

Then create a calculated field [Segment Title].

It is simply a string that will be displayed as a title for the dashboard.

Once created, place this field in the Text box of the Marks card.

Step 8

While inside the worksheet Segment Dashboard Title, drag and drop the field [Unfilled Selection] into the Detail box of the Marks card.

Step 9

Go to the dashboard Seg Dashboard Solution.

Then create a new horizontal container above the worksheet Segment and place the worksheets Dynamic Button Report and Segment Dashboard Title next to each other as shown.

Step 10

Then in the dashboard view, go to the menu on top called Dashboard. Within the Dashboard menu, select Actions. We will create two Parameter Actions to drive the change of the Report buttons.

In the Actions pop up menu window, click on the Add Action pull down menu and select Change Parameter.

The first parameter action is called Hover Action to Show Filled Report Button.

The second parameter action is Hover Action to Show Unfilled Report Button.

What we are doing here is applying hover action for all the adjacent sheets so that when a mouse is moved away from the Report button worksheet, it will push 'Unfilled' value to the parameter [Button Selection] hence forcing the Unfilled Report button to display.