I'm trying to create a summary report that counts interactions over a 24 hour period by hour. It works great but in order to make the data useful, I need to force a value into the summary list so that when there are no interactions, the hour still appears with a zero value.
The hour field just grabs the hour of the day from a timestamp of the interaction. The Total is a Summary count of the Hour field. I would like it to show all of the hours of the day whether or not they have a Total. I created another table called HOD that has 24 records with one number field and tried to use the relation to do this, but it's not working. I know I'm close, but I'm need some help to nudge me in the right direction.