Skip to content

Widgets

Jump to bottom
Tarun Abichandani edited this page Jan 15, 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

  • Bar Chart
  • Pie Chart
  • Line Chart
  • Geo Map Chart
  • Data Table
  • Gauge / Dial Chart
  • Data Value Widget
  • Static Text Widget
  • Slice Widget

Analysis Configuration

When a widget is added on the backend the data is aggregated using the following pipeline.

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](ADD LINK) 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](ADD LINK) 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](ADD LINK) instead of Target Column. When an [expression](ADD LINK) is given, the same is plotted on the graph. Note that if [expression](ADD LINK) 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](ADD LINK).

| 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                |

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
Clone this wiki locally