You can hide a widget if it is not required to be displayed on the dashboard for any reason. The multiple scenarios for using this functionality are given below.

Scenario 1: Show/Hide a Chart Manually

For hiding a widget manually, click Widget List, hover over the widget title, and click the Hide Widget Icon ().
The widget gets hidden (disappears) from the Dashboard page. Also, the widget title in the list gets blurred, and a Show Widget Icon () appears next to it.


If you want to view the widget again, click the Show Widget Icon ( ). The widget appears in the same position.

(info) Note:

You can use this functionality in the Edit Mode only.

Scenario 2: Show/Hide a Chart using Condition

In RubiSight, you can choose to show or hide charts based on a specific condition using the Show/Hide Charts formatting option. It applies to all widgets.



To use Show/Hide Charts formatting option, first plot a chart using the features from the dataset.
For example, we plot a Column Chart and a Line Chart using the same set of dimensions and measures: the Average of Sales by Region and Category.
Also, we create a binary categorical parameter named Chart_Value for the two charts, with two values, Column, and Line, as shown below.



We plot a Parameter widget on the same dashboard page using this parameter. Refer to Using Parameters in RubiSight in RubiSight User Guide.
The default value for the created parameter is Column.
The figure below shows the dashboard containing the two charts and the Parameter Widget in the Edit Mode.



To apply the Edit Condition,

  1. Turn the Apply toggle "ON".
  2. Click Edit Condition. The Show/Hide Chart Condition window is displayed.
  3. Create a condition using the Expression Builder. 

The expression created in the builder should

  • either be a conditional statement or
  • should have Boolean values (true or false) as output

(info)Notes:

  • By default, the Show/Hide Charts option and Edit Condition tab are disabled (the Condition is False).
  • If the output of the expression does not contain a condition, then the expression builder gives an error message "Expression is invalid due to non-conditional statement" on validation.
  • You can create and add only one Condition to a widget.
  • The effect of Show/Hide Condition can be seen in View Mode only.

For example, we use the Comparator Operator (==) to create conditions separately for the Column and Line charts using the created parameter.
We create the following expression for the Column Chart. When the Chart_Value = Column, the Column Chart is shown; else, it is hidden.




Also, we create the following expression for the Line Chart. When the Chart_Value = Line, the Line Chart is shown; else, it is hidden.



The above expressions are valid because their output can be True or False.
Now, switch to the View Mode. Since the default value for Chart_Value is Column, the Column Chart is shown, and Line Chart is hidden.

Now, select the radio button for the Line option in the Parameter Widget. The Chart-Value is Line for the Line Chart. Hence, the Line Chart is shown, and Column Chart is hidden.


Scenario 3: Show/Hide using a Boolean Constant String Value (True/False)

Now, from Scenario 2,

  1. Change the Show/Hide Condition for the Column Chart from Chart_Value == Column to simply True. It means that the Condition for the Column Chart is always true.
  2. Keep the Condition for the Line Chart unchanged.

If you switch to View Mode, you see that the Column Chart is always shown for any selection of the Parameter widget.

Case 1: When the Parameter Widget selection = Column


Case 2: When Parameter Widget selection = Line



Scenario 4: Show/Hide using Features

You can use the features/columns from the dataset used to plot the chart for the show/hide condition.

Condition: "If the selected value (while creating the expression) corresponds with the first value in the sorting order of the feature, the column is shown in the View Mode, else hidden."

For example, we plot a Column and a Line Chart for the Average of Sales by Order Priority and Region. The first value for Order Priority in the two charts are Critical and Medium, respectively, as shown below.



Next, we create the following expression for both charts. When the Order Priority = Medium, the charts are shown, else hidden.



Now, switch to the View Mode. The Column Chart is hidden while the Line Chart is shown since it satisfies the Condition.


Scenario 5: Show/Hide for Text, HTML, and Image Widgets

Although Text, HTML, and Image widgets do not need datasets to plot, you can still apply the Show/Hide condition on them using a dataset present in the dashboard. Once you select a dataset for any charts, you can create a condition using a feature present in the dataset.
Click Format and click the Select Dataset drop-down to add a dataset. Select the dataset you want to add to the charts from the list.
For example, in the dashboard, we have a dataset named Sp_Sample_Superstore. It contains a feature named Order Priority with four categorical values C (Critical), H (High), M (Medium), and L (Low).


Figure: Selecting Dataset

Condition: "If the selected value (while creating the expression) corresponds with the first-row value of the feature in the dataset, the column is shown in the View Mode, else hidden."

For example, we plot a Text Chart, an HTML Chart (a simple table), and an Image Chart, as shown below.


The snippet of the dataset used to plot the charts is shown below.

As you can see, the value in the first row for Order Priority is "C."
Next, we create the following conditions for the three charts as explained above.

  • For Text and Image Charts, Order Priority = C
  • For HTML Chart, Order Priority = M

Now, switch to the View Mode. The HTML Chart is hidden while the Text and Image charts are shown since they satisfy the Condition.


Table of Contents