I'm trying to create a crosstab that shows a total count for each hour. However, I have some rows without any data.
When I turn on "Show Empty Rows" it will fill in the missing data points for me but it also shifts the range by one hour. So anything that happened between 00:00 and 01:00 doesn't show up.
Here is a screenshot showing an example of each setting (I just realized the title shouldn't say percent )
Is there any way to fill empty rows with "0" but also keep the starting position at 00:00?
Thanks in advance.