Skip to content

Widgets

Jump to bottom
Tarun Abichandani edited this page Jan 18, 2024 · 5 revisions

In Resseract Lite, widgets serve the purpose of crafting dashboards that can be saved for monitoring crucial metrics, sharing outcomes with stakeholders, and facilitating collaboration within your team.

Resseract supports the following widgets

Widget Structure

A widget in Resseract Lite will look like the following Widget

Move/Re-size Widget

The re-size handle can be used to move a widget across the dashboard Canvas. The widget can also re-sized using the ends of the widget.

Move Widget

Widget Menu

The Widget Menu has the following options:

  • Refetch: Used to re-fetch the data from backend and re-plot the data
  • Configure Analysis: This feature can be used to configure the analysis used in the Widget
  • Slice Targets: This feature can be enable the widget to be used as a slice component for other widgets. More details about slicing data is given here
  • Export as CSV: This option is used to export the data shown in the widget as a CSV
  • Chart Options: This option is used to modify the display option of the widget
  • Full Screen: This option is used to show the widget in full screen
  • Delete Widget: This option is used to delete the widget

Group By Analysis Configuration

Resseract Lite supports different types of analysis. When a widget is added GroupBy Analysis is triggered on the backend to aggregate that data. This GroupBy Analysis follows a series of steps as given below.

graph TD
    A[Load Data] --> B[Slice Data]
    B --> C[Group By]
    C --> D[Evaluate Expression]
    D --> E[Sort]
    E --> F[Display]
Loading

Step 1 : Load Data

In this step, data is loaded from the supported Static or Dynamic data sources. Refer Data Upload section on how to upload data. Let us consider an example where data is loaded as follows.

| Team         | Player     | Runs | Inning |
|--------------|------------|------|--------|
| Australia    | D Warner   | 98   | 1      |
| Australia    | S Smith    | 96   | 1      |
| Australia    | D Warner   | 102  | 1      |
| India        | V Kohli    | 134  | 1      |
| India        | MS Dhoni   | 183  | 1      |
| India        | MS Dhoni   | 101  | 1      |
| India        | V Kohli    | 56   | 1      |
| South Africa | H Amla     | 87   | 1      |
| South Africa | Q De Kock  | 76   | 1      |
| South Africa | J Kallis   | 14   | 1      |

Step 2 : Slice Data

The data loaded is now sliced using the slice expression (if provided). To slice data in widget, please follow the following steps

  1. From widget menu, click Configure Analysis
  2. Select the Group By analysis from the menu and add a slice expression
  3. Add a slice expression as follows and click Save

For the above data, if the slice expression is [Team] == "India" the data will look like this.

| Team         | Player     | Runs | Inning |
|--------------|------------|------|--------|
| India        | V Kohli    | 134  | 1      |
| India        | MS Dhoni   | 183  | 1      |
| India        | MS Dhoni   | 101  | 1      |
| India        | V Kohli    | 56   | 1      |

Step 3 : Group By

The sliced data is now grouped based on one of the column. The grouped column is given in the analysis or can be changed using Configure Analysis option in Widget Menu. When the data is grouped, values in other column are aggregated based on the aggregation given. To change the aggregation type and group by column of a widget follow given steps

  1. From widget menu, click Configure Analysis
  2. You can change the Group By Column, Numerical Aggregation and Categorical Aggregation
  3. Click Save

For the above data, if group by column is Player and Numerical Aggregation is SUM, the data will look like as follows

| Team         | Player     | Runs | Inning |
|--------------|------------|------|--------|
| India        | V Kohli    | 190  | 2      |
| India        | MS Dhoni   | 284  | 2      |

Step 4 : Evaluate Expression

User also has an option to plot an expression instead of Target Column. When an expression is given, the same is plotted on the graph. Note that if expression is given, no other column can be used with it

To add a expression please follow the given steps

  1. From widget menu, click Configure Analysis
  2. Add Expression
  3. Click Save

For the above data, if expression is [Runs]/[Inning], a new column will be added with the result of expression.

| Team         | Player     | Runs | Inning | Expression Result |
|--------------|------------|------|--------|-------------------|
| India        | V Kohli    | 190  | 2      | 95                |
| India        | MS Dhoni   | 284  | 2      | 142               |

Step 5 : Sort

The resultant data can now be sorted by any plotted column in ascending or descending structure

  1. From widget menu, click Configure Analysis
  2. You can modify the Sort Column and Sort Ascending as appropriate
  3. Click Save

For the above data, if Sort Ascending is FALSE, the data will look as follows

| Team         | Player     | Runs | Inning | Expression Result |
|--------------|------------|------|--------|-------------------|
| India        | MS Dhoni   | 284  | 2      | 142               |
| India        | V Kohli    | 190  | 2      | 95                |

Slicing Data

Slicing data involves extracting or isolating a particular subset of information from a larger dataset based on specific criteria or conditions. This process allows users to focus on and analyze specific portions of the data rather than the entire dataset. You can slice data in Resseract Lite using one of the following ways.

1. Slice using Slice Widget

Please refer Slice Widget for more details

2. Slice using existing widget

Certain widgets within Resseract Lite can function as a slicing source for other widgets. For example, if you have two bar graphs plotted, clicking on a bar in Widget 1 can be configured to act as a filter for Widget 2. To achieve this, follow the given steps

  1. In the source widget, from widget menu, click Slice Targets
  2. Select the widget that you want to slice and click Done
  3. Now if you click on any data point in source widget, data in second widget will be sliced

3. Add Slice in Analysis Configuration

When data is sliced using analysis configuration it is a static slice and cannot be changed on runtime. To add slice using analysis configuration follow the given steps

  1. From widget menu, click Configure Analysis

Slice Targets

  1. Select the Group By analysis from the menu and add a slice expression
  2. Add a slice expression as follows and click Save

Slice Configure Analysis

Clone this wiki locally