Chart By Category X
The "Chart By Category X" section widget generates charts based on counts or any column data for a specific section, with the added flexibility of optional aggregation methods for category data.
The "Chart By Category X" section widget provides the same powerful charting capabilities as the dashboard Chart By Category X widget, but applies them specifically to data within a section context. This widget generates versatile charts based on counts or any column data, with optional aggregation methods for category data. It uses Select or ForeignKey columns to categorize data, enabling customized visualizations tailored to specific laboratory workflows within your experimental records.
Use Cases
Section-Specific Reporting: Generate charts within a specific experimental record or section
Experiment Visualization: Display data distributions specific to an experiment or protocol
Sample Analysis: Visualize sample properties or characteristics within a section
Progress Tracking: Monitor task completion or workflow progress for a specific project section
Quality Control: Display test results or quality metrics within inspection records
Interface
Read-only View
The widget displays a bar chart where the x-axis represents different categories and the y-axis shows either the count of records or a value derived from a specified aggregation method. The visualization is contained within the section and updates based on the configured filters and data sources.
Users can click the Download button to retrieve the source data in a downloadable format for further analysis.
Edit View
The edit view is not applicable for this widget as it is designed for data visualization and reporting purposes only. Configuration is performed through the widget settings panel.
Configuration
This widget shares the same configuration options as the dashboard Chart By Category X widget. For detailed configuration instructions, please refer to the Configuration section of the dashboard widget documentation.
Key Configuration Settings
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.
X axis sorting: Choose how to sort the X axis values.
String (A-Z)
String (Z-A)
RID (Ascending)
RID (Descending)
X axis format: Choose how to format foreign key values on the X axis. 'Full' shows the complete value (e.g., 'TRT24: Untreated Control'), while 'Name only' shows just the name part after the colon (e.g., 'Untreated Control'), grouping records with the same name together.
Full (UID: Name)
Name only
Series: Choose one or more columns for the data series. Number or Formula 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.
Group: Choose a column to group the data by. When a group is specified, the x_axis values become categories, group values become series, and series values are aggregated for each combination.
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
Sum
Max
Median
Min
Average
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 auto update when empty: If checked, this widget will perform a live calculation when empty.
The widget requires at least one column with a Select or ForeignKey widget, and optionally one or more columns with Number, Formula, or Consumption widgets for aggregation analysis.
Additional Functions
Data Export
Click the Download button in the widget interface
The source data will be downloaded in a format suitable for further analysis
Auto-Update
When "Should auto update" is enabled, the widget automatically recalculates and refreshes the chart when underlying data changes, ensuring your visualizations stay current with your laboratory data.
Related Documentation
For comprehensive details about this widget, including advanced configuration options and use cases, please visit the dashboard Chart By Category X widget documentation.
Last updated