### Apache Airflow version

2.6.2

### What happened

All tasks were run 1 time. The try number is 2 for all tasks

### What you think should happen instead

Try number should be 1 if only tried 1 time

### How to reproduce

Run a task and use the UI to look up try number

### Operating System

centos

### Versions of Apache Airflow Providers

_No response_

### Deployment

Virtualenv installation

### Deployment details

_No response_

### Anything else

_No response_

### Are you willing to submit PR?

- [ ] Yes I am willing to submit a PR!

### Code of Conduct

- [X] I agree to follow this project's [Code of Conduct](https://github.com/apache/airflow/blob/main/CODE_OF_CONDUCT.md)

"""Returns cluster activity historical metrics."""
        start_date = _safe_parse_datetime(request.args.get("start_date"))
        end_date = _safe_parse_datetime(request.args.get("end_date"))
        with create_session() as session:
            
            dag_runs_type = (
                session.query(DagRun.run_type, func.count(DagRun.run_id))
                .filter(
                    DagRun.start_date >= start_date,
                    or_(DagRun.end_date.is_(None), DagRun.end_date <= end_date),
                )
                .group_by(DagRun.run_type)
                .all()
            )
            dag_run_states = (
                session.query(DagRun.state, func.count(DagRun.run_id))
                .filter(
                    DagRun.start_date >= start_date,
                    or_(DagRun.end_date.is_(None), DagRun.end_date <= end_date),
                )
                .group_by(DagRun.state)
                .all()
            )
            
            task_instance_states = (
                session.query(TaskInstance.state, func.count(TaskInstance.run_id))