Summary view grouped by date - can I include missing dates?
Let's say I have a table like this:
May 1, A
May 1, B
May 1, C
May 2, A
May 3, A
May 3, B
May 5, A
May 5, B
Using the "Summary Report", grouping by Full Date, and displaying count for column B, I get this Summary:
May 1, 3
May 2, 1
May 3, 2
May 5, 2
Is there a way to include the date where there were no entries, so basically get this instead:
May 1, 3
May 2, 1
May 3, 2
May 4, 0
May 5, 2