Using Dashboard Hierarchies

Using Dashboard Hierarchies

In a data dictionary, you can rearrange or change the order of the features in the newly created dataset using the Hierarchy function. The created hierarchy is used in the RubiSight application.
To use the created hierarchy in a dashboard, follow the steps given below.

  1. Create a Hierarchy from datasets in the Data Dictionary. Refer to Creating Hierarchy in Metadata Manager.
    For example, we create a hierarchy named New_Hierarchy using an HR dataset as shown below. The feature sequence in the newly created dataset, i.e., Department, EducationField, Gender, and MaritalStatus, is also shown in the figure below. Thus, the Department is in the first position, EducationField is in the second position, and so on.



  2. Create a dashboard. Make sure to select the Data Dictionary, containing the newly created hierarchy, as a dataset. Refer to Creating a Dashboard.
    For example, we add DataDictionary_New, containing New_Hierarchy, to the dashboard.
  3. Plot a widget of your choice.
    For example, we plot a Column Chart of the Average Job Satisfaction by Gender with Attrition as the Legend. This chart is the default plot. Here, Gender is the feature selected from the newly created hierarchy. You can see that Gender is in the third position in the hierarchy.


  4. Save the dashboard and click View Mode in the top-right corner. You can now see the widget in the View Mode.
  5. Two CTA arrows (Call To Action arrows) appear on the top right corner of the widget. These are
    • Drill Down ()
    • Roll Up (




To use the hierarchy, click any of the two CTA arrows. For example, we click the Drill Down CTA arrow. You can see that

    • The feature on the X-axis changes to MaritalStatus, and the graph gets replotted.
    • A Refresh arrow appears next to the Roll Up arrow. You see the default widget with Gender on the X-axis if you click Refresh.
    • The Drill Down CTA arrow gets disabled since MaritalStatus is the last feature in the hierarchy.



Starting from the Column Chart with Gender on the X-axis, click the Roll Up CTA arrow. You can see that

    • The feature on the X-axis changes to EducationField, and the graph gets replotted.
    • A Refresh arrow appears next to the Roll Up arrow. You see the default widget with Gender on the X-axis if you click Refresh.
    • None of the CTA arrows gets disabled since EducationField is neither the hierarchy's first nor the last feature.


(info)

Notes:

  • The created hierarchy can be used only in the RubiSight application.
  • Make sure to save the dashboard before navigating to the View Mode.
  • The hierarchies can be applied to any number of widgets plotted on the dashboard page.
  • The widgets for which this feature is supported are:
    • Column chart
    • Area chart
    • Line chart
    • Bar chart
    • Stacked-bar chart
    • Stacked-column chart
    • Stacked-area chart
    • Scatter plot
    • Waterfall chart
    • Pie chart
    • Donut chart
    • Scatter plot
    • Treemap chart
    • Wordcloud chart
  • If you select a numerical column to be added in a hierarchy, you need to change its data type to categorical.
  • For the columns selected in the hierarchy, all CRUD operations (Create, Read, Update and Delete) can be performed only in the Data Dictionary. (and not in the RubiSight dashboard)

    • Related Articles

    • Refreshing Dashboard using Scheduled Workflow

      The dashboards that you create are static, meaning the dashboard views do not change if the data they represent is changed. For this, you can use the refresh function provided by RubiSight. Refer to Refreshing a Dashboard. However, there can be ...

    • Hierarchies in Data Dictionary

      Creating Hierarchy In a data dictionary, you can rearrange or change the order of the features of the newly created dataset using the Hierarchy function. Note: The created hierarchy can be used only in the Dashboard application. To create the ...

    • Using Annotations on a Dashboard

      Annotations are used to add more information in a widget. The annotations are added in the form of numbers and text. To annotate a dashboard, follow the steps given below. Open the Dashboard in edit mode. Refer to Editing a Dashboard. The Dashboard ...

    • Using Filters

      When you plot a chart, all the data in the dataset is not required to be used. Also, within the data used, there might be sub-categories that you want to plot separately. You can view classified results in the charts using filters. Filters help you ...

    • Creating Visualization using Widgets on Dashboard

      You can create different visualizations using the different types of widgets provided by RubiSight. When the same data is represented in different ways, it can give different insights and help the decision-making process. The following sections ...