For one of my reports I'm trying to calculate the total duration within specific time ranges. Each entry in the database has a duration column and a timestamp column. When I try to calculate the total duration for each bucket, some ID's don't have all of the bucket values I defined. For example, the third bucket is gone from one ID while some ID's only have one bucket all together. Why would some bucket values not appear at all? Below is a screenshot of what I'm talking about:
Basically, I want all five buckets to appear for all ID's and a default value of zero to appear if there's no data for that bucket. How do I make all five bins/buckets persist?