## Bug description

*Please describe.*  
- some datapoints show 0 but people will appear in modal

*If this affects the front-end, screenshots would be of great help.*  

## Expected behavior
- amount of people and datapoint should be the same


## How to reproduce

1. demo data clickhouse instance
2. go to retention trends for a day with some people


## Environment

- [ ] PostHog Cloud
- [ ] self-hosted PostHog, version/commit: _please provide_

## Additional context



#### *Thank you* for your bug report – we love squashing them!

ee/clickhouse/queries/clickhouse_retention.py
)
        initial_interval_result = sync_execute(
            INITIAL_INTERVAL_SQL.format(reference_event_sql=reference_event_sql),
            {
                "team_id": team.pk,
                "start_date": date_from.strftime(
                    "%Y-%m-%d{}".format(" %H:%M:%S" if filter.period == "Hour" else " 00:00:00")
                ),
                "end_date": date_to.strftime(
                    "%Y-%m-%d{}".format(" %H:%M:%S" if filter.period == "Hour" else " 00:00:00")
                ),
                "reference_start_date": date_from.strftime(
                    "%Y-%m-%d{}".format(" %H:%M:%S" if filter.period == "Hour" else " 00:00:00")
                ),
                "reference_end_date": (
                    (date_from + filter.period_increment) if filter.display == TRENDS_LINEAR else date_to
                ).strftime("%Y-%m-%d{}".format(" %H:%M:%S" if filter.period == "Hour" else " 00:00:00")),
                **prop_filter_params,
                **target_params,
                **returning_params,
                "period": period,
            },
        )
        result_dict = {}
        for initial_res in initial_interval_result:
            result_dict.update({(initial_res[0], 0): {"count": initial_res[1], "people": []}})
        for res in result:
            result_dict.update({(res[0], res[1]): {"count": res[2], "people": []}})
        return result_dict
    def _get_condition(self, target_entity: Entity, table: str, prepend: str = "") -> Tuple[str, Dict]: