function readOnly(count){ }
Sign Up ›
Starting November 20, the site will be set to read-only. On December 4, 2023,
forum discussions will move to the Trailblazer Community.
Learn More

Browse by Topic
ShowAll Questionssorted byDate Posted
+ Start a Discussion
TxPartnerTxPartner 

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?
sfdcfoxsfdcfox
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 ~