Show Hide Charts

Show Hide Charts

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, 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. Select the dataset.
  3. Click Edit Condition.



    The Show/Hide Chart condition window is displayed.
  4. Create a condition using the Expression Builder. 



    The expression created in the builder should
    1. either be a conditional statement or
    2. 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).


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.



    • Related Articles

    • Show blank as zero

      Showing blanks as zero in widgets Show Blank as Zero functionality allows you to represent Null values as zero in widgets. It is available in line chart, column chart, bar chart, stacked bar chart, stacked column chart, filter widget and table ...
    • Formatting Custom Charts

      RubiSight provides three charts which are different than the rest of the charts. They are - Text HTML Image
    • Creating Charts using Widgets

      To create a chart using widgets, follow the steps given below. Open the Dashboard in edit mode. Refer to Editing a Dashboard. The Dashboard is displayed. In the WIDGETS pane, click the widget you want to use. Note: Hover over any widget to see its ...
    • Viewing Data in Preview Pane

      You can view the data entries in the selected dataset in the PREVIEW pane in the data dictionary. To view the data in the PREVIEW pane, follow the steps given below. Select the dataset from the data dictionary canvas. The features of the dataset are ...
    • Adding Widget in "At a Glance" View

      Adding a widget in the "At a Glance" view makes it easy for you to see the created charts directly on the home page. This feature is user login specific. The user who has added the charts in a glance view can only see those charts on the Rubiscape ...