AOR Reports Module Group Option Issues


I am trying to create some basic reports using SuiteCRM AOR Reports module. I am creating a report on Opportunities module.

  1. I have selected my fields like below with Group options checked against Sales Stage. Please see the below image.

  1. 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
Shijin Krishna

Hi All,

Any help with this?