+ Start a Discussion

Dashboard Rpt - How to show all dates, not just dates with Record Count > 1

I've created a dashboard which is showing the results from a report that is grouped by date. The report criteria is looking for opportunities that are owned by user Ted and have a stage that contains the word "win". The dashboard shows the date and the number of matching records per date. I want the dashboard to show all dates, even if there are no matching records (i.e. the record count would be 0 on that date.) Is this possible? How can I achieve this result?
You can't do that in the current release of Salesforce; you simply can't report on data that is not in the system. However, if you are an EE user, you could create an S-Control dashboard component (in Flex or even AJAX) to display the report and filling in the blanks.

~ sfdcfox ~