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

[Mac-Rae]

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

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
   
   

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