I am trying to create some basic reports using SuiteCRM AOR Reports module. I am creating a report on Opportunities module.
- I have selected my fields like below with Group options checked against Sales Stage. Please see the below image.
- And the Reports result is like below. But I am expecting the count of Opportunities with each sales stage coming under Count colomn.
Now I changed the Report fields to Below
And the results comes like below with duplicates.
Please let me know if I am missing something.
How can I create a Reports which shows the Sales Stage and Count of Opportunities. I would like to have chart with Sales Stage on X axis and Count on Y axis. Is this possible with the AOR Reports module?
I am using SuiteCRM 7.9.9 with PHP 7.7.1 and MySQL 5.7.19
Thanks in advance