Stacked & grouped bar charts show 1 value instead of actual count #5187

New issue

Open

opened 2026-02-20 16:31:06 -05:00 by deekerman · 0 comments

deekerman commented

2026-02-20 16:31:06 -05:00

Owner

Originally created by @Mac-Rae on GitHub (Apr 25, 2024).

Issue

A report created to show stacked or grouped bar charts doesn't work as expected. For example see screenshot which shows a chart where data blocks are the value of 1 and not the correct value from the report. This is replicable on the live demo.

Expected Behavior

This report should display the data blocks with the right value and "height" associated with each block.

Actual Behavior

This report only shows data blocks with value of 1.

Possible Fix

Steps to Reproduce

Create a new report and select a module like Accounts
Add 3 data points, for example ID/Name, Type and Assigned To.
Apply a count to Name, Hide Type, and Group by Assigned To
Set the main group to Type
Add a charts
Set the X and Y inputs to those charts as X = Assigned To and Y = Name/ID

Context

Prevents the reports module from being fully effective.

Your Environment

SuiteCRM Version used: 7.14.3
Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Version 124.0.6367.62 (Official Build) (64-bit)
Environment name and version (e.g. MySQL, PHP 7): UKN demo.suitecrm.com
Operating System and version (e.g Ubuntu 16.04): UKN demo.suitecrm.com

Originally created by @Mac-Rae on GitHub (Apr 25, 2024).     #### Issue   A report created to show stacked or grouped bar charts doesn't work as expected. For example see screenshot which shows a chart where data blocks are the value of 1 and not the correct value from the report. This is replicable on the live demo. ![image](https://github.com/salesagility/SuiteCRM/assets/45397629/499fbe45-9f08-439d-8818-c1de0397fb85) ![image](https://github.com/salesagility/SuiteCRM/assets/45397629/66f0401a-da6d-41a7-9647-e24a3cd2d45c) #### Expected Behavior  This report should display the data blocks with the right value and "height" associated with each block. #### Actual Behavior   This report only shows data blocks with value of 1. #### Possible Fix  #### Steps to Reproduce   1. Create a new report and select a module like Accounts 2. Add 3 data points, for example ID/Name, Type and Assigned To. 3. Apply a count to Name, Hide Type, and Group by Assigned To 4. Set the main group to Type 5. Add a charts 6. Set the X and Y inputs to those charts as X = Assigned To and Y = Name/ID ![image](https://github.com/salesagility/SuiteCRM/assets/45397629/dbf519d9-9c5c-4495-b166-b9e13c918ec0) ![image](https://github.com/salesagility/SuiteCRM/assets/45397629/e97f0200-6a66-46ba-83e1-7a565ff74e5f) #### Context   Prevents the reports module from being fully effective. #### Your Environment  * SuiteCRM Version used: 7.14.3 * Browser name and version (e.g. Chrome Version 51.0.2704.63 (64-bit)): Version 124.0.6367.62 (Official Build) (64-bit) * Environment name and version (e.g. MySQL, PHP 7): UKN demo.suitecrm.com * Operating System and version (e.g Ubuntu 16.04): UKN demo.suitecrm.com