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.
Last updated
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.
Last updated
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.
Display number of tasks to finish.
Display number of customer closed.
To enable the widget, ensure that your setup meets the following requirements: have at least one column with a or widget, and one or more columns with a , or 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.
Query - You can specify a query to limit the results.
X axis - Choose a column for the X axis. If nothing is selected, the record name will be used as 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.
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.
