AOR Reports Module Group Option Issues

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hello,

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.

https://www.screencast.com/t/mOJRr6Qk1H1g

  1. And the Reports result is like below. But I am expecting the count of Opportunities with each sales stage coming under Count colomn.

https://www.screencast.com/t/rBuGa1mU58BA

Now I changed the Report fields to Below

https://www.screencast.com/t/2IbDWLzWw

And the results comes like below with duplicates.

https://www.screencast.com/t/iyexUXTdG

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

2

Hi All,

Any help with this?