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
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
Context
Prevents the reports module from being fully effective.
Your Environment