Report Grouping By Date With No Values - Ideas - Salesforce Trailblazer Community

All Ideas

Idea Details

Post an Idea
This idea has been merged into another idea. To comment or vote on this idea, please visit Charts over time should show datapoints when value is zero..
0  Points voting closed
Idea has been posted. Give it an upvote or downvote.

Report Grouping By Date With No Values

Reports & Dashboards

When you create a summary report and select a date field as a summary field, you have the option of grouping by day, week, etc. The problem is that is no records fall within a date period, there is no summary value for the period, and, therefore, no period. The lack of a value is particularly evident when trying to graph the result. For instance, if your values are: Mon - 5 Tue - 4 Wed - 0 Thu - 0 Fri - 3 The report, and the graph, only show: Mon - 5 Tue - 4 Fri - 3 What I want is an a type of outer join on the date field so that date groups (day, week, month, etc) within the overall date range are represented with a zero value that would smooth out the graphic results. And while I am at it, the day grouping join should also be able to include or exclude non-working days (like Saturday or Sunday).

· Flag

  • Upvotes
  • Downvotes



from AppExchange


Help us to keep IdeaExchange clean by pointing out overlapping ideas. We'll investigate your suggestion and merge the ideas if it makes sense.



Thanks for your merge suggestion. We will review it shortly and merge the ideas if applicable.

Salesforce takes abuse situations very seriously. Examples of abuse include but are not limited to posting of offensive language or fraudulent statements. To help us process your request as quickly as possible, please fill out the form below describing the situation. For privacy and security reasons, the final outcome of an abuse case may not be revealed to the person who reported it.


Thank you for your feedback. We take abuse seriously and will investigate this issue and take appropriate action.