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.
You need to select the “group” checkbox for that field, and select the total as “count”
Thanks a lot pgr, I appreciate.
But it’s still not working.
Please take a look at the screenshot below:
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:
https://suitecrm.com/suitecrm/forum/developer-help/20227-how-to-add-other-charts-in-report-charts-for-ex-line-chart-bubble-chart-gauge-chart-funnel-chart-etc?start=%1$d#72590 (code is a few posts below)
You also have the brand new Analytics which requires installing a special software, but is very powerful: https://docs.suitecrm.com/admin/suitecrm-analytics/