AnsweredAssumed Answered

Forcing a value in a summary list...

Question asked by GeoffreyMartin3300 on Nov 2, 2017
Latest reply on Nov 8, 2017 by philmodjunk

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.

Outcomes