Chart By Category X

The "Chart By Category X" widget generates charts based on counts or any column data, with the added flexibility of optional aggregation methods for category data.

Overview

The "Chart By Category X" widget in the Labii dashboard is a powerful tool that offers versatile chart display options. This widget can generate charts based on counts or any column data, with the added flexibility of optional aggregation methods for category data. The widget utilizes a Select or ForeignKey widget to categorize data, allowing for customizable and informative visualizations that can be tailored to specific needs.

Use case

• Display number of tasks to finish.

• Display number of customer closed.

Configuration

To enable the widget, ensure that your setup meets the following requirements: have at least one column with a Select or ForeignKey widget, and one or more columns with a Number, Formula or Consumption widget for aggregation analysis, which should return a numeric value. Once you've confirmed this, click the Edit button to configure the widget and proceed with the setup process.

• Table - Select a table to update the filter dropdown.

• Filter - You can specify a filter to limit the results. The default setting will use the complete data set if the filter is not specified.

• X axis - Choose a column for the X axis.

• Series - Choose one or more columns for the data series. Number, Formula or Consumption widgets must be used in the column. If no specific series is selected, the total count will be utilized as the data series by default.

• Data aggregation - Data aggregation is the process where raw data is gathered and expressed in a summary form. 'Sum' will be used if no specific series is selected.

  • None

  • Average

  • Max

  • Median

  • Min

• Chart title - Please provide the title of the chart.

• Height - Chart height in px. Default to 250px.

• Should auto update - If checked, this widget will perform a live calculation.

• Should update when empty - If checked, this widget will perform a live calculation when empty.

Interface

The widget displays a bar chart where the x-axis represents either the count of records or a value derived from a specified aggregation method. The y-axis, on the other hand, represents the different categories within the dataset. Additionally, users have the option to click on the "Download" button to retrieve the source data in a downloadable format. This functionality ensures that users can easily access and analyze the underlying data that the bar chart represents.