I am trying to create a calendar view of my data. I do not have data for every day of the month, therefore I am left with numerous blank spaces.
I want every day of the month to appear, but instead of blanks, I want 0's to appear.
Undoubtedly some conditional formatting is required. I tried ifnull ([measure]),0 however, this confuses matters.
Below is a shot of what I currently have;