Reports - Getting Nulls to Show as 0's In Report for Grouping Purposes

đź’¬ General Discussion
1

Looking to put together a report that displays various data points by month - like the number of opportunities closed, etc.

The problem with the Reporting module is that there seems to be no way for me to set it such that, if 0 opportunities were closed in April, show 0 instead of ignoring the April “group” altogether.

Does anyone know any solutions for this?

Having this functionality would hugely improve our data and graphs.

2

Unfortunately there is no way the reports can fill in missing Months. You can either develop a custom report based on your criteria or maybe try KReports which does allow to have custom queries where you can put 0 condition if not data found for the month.