Group Report by Status - Bar Chart

SuiteCRM Forum - English Language SuiteCRM General Discussion
1

Hi guys,

I was wondering if I could get help with this.

I’m trying to create a report, with a bar chart, which shows the status of contacts on the x-axis & the total number of people in each status on the y-axis.

Right now, I’m having a hard time combining similar status into the same bar on the chart.

From the attached screenshot, there are 3 contacts with the status “deposit” and rather than combine this into a single bar, they are treated as individual items.

Would appreciate if someone could help out with this.

2

You need to select the “group” checkbox for that field, and select the total as “count”

3

Thanks a lot pgr, I appreciate.

But it’s still not working.

Please take a look at the screenshot below:

4

I’m sorry, I played around with all the options for a long time and I also couldn’t get it to work :huh:

If you are able to handle a bit of PHP you might prefer this way:

You also have the brand new Analytics which requires installing a special software, but is very powerful:

5

Having the same problem. Is there any solution to this aside from the php or the analytics tool?
PS: PHP solution link is currently not working btw…

6

Thanks for the warning. Link updated.