[SalesForce] Add Report Chart to Lightning Components

As you have discovered, Salesforce is weak at reporting on missing data.

You might try creating an opportunity with one zero value revenue item in each of the missing months. I suspect that such an opportunity might distort other opportunity reports. It can, of course, be filtered out, but users will need to be instructed to do this.

In order to report on missing attendance, I had to create a new custom object. Each record represents a day of missing attendance for one site. I have one scheduled batch job that checks for missing attendance and another that checks each missing attendance record to see if it has been resolved. That was more complex than I would have preferred, but it does work.

In your case, you could have a custom object, RevenueItem_IncludeZeroes__c, where each existing Revenue Item would have a clone in RevenueItems_IncludeZeroes. In addition to the clones, you would need zero value records for the missing months. A single scheduled job could do the following:

1. Delete existing RevenueItem_IncludeZeroes__c records.
2. Clone existing RevenueItems into RevenueItem_IncludeZeroes__c records.
3. Scan the desired date range for months with no revenue items.
4. Create zero-value revenue items for missing months.

I don't know enough about your situation to tell you if RevenueItem_IncludeZeroes__c needs to be a master detail item or even if it needs to be related to the opportunity. In my case, I opted for simplicity and left the new object unrelated to existing objects (though it does contain enough info that I know what each records relations would be).

I was very happy to see, that in Spring 18 this issue seems to be resolved by Salesforce. There was no need to change anything on my end - it just works now on any Orgs I've checked so far - and looks awesome!

Thanks Salesforce for fixing this!