Using the same application, I need to add the number of quotes each agency produced. I thought that by creating a date value per interval, I could at least see nulls. The best I can do is see agencies that have at least one interval with a value. If’s it’s zero across date intervals, then they’re not listed (fyi - nulls and/or zero values are not suppressed). Feels like the value of 0 (zero) should be added along with the date value.
Here is a condensed version of what I’m loading right now.