$queryTask  = $em->getRepository(Task::class)->createQueryBuilder('tk')
      ->select('SUM(case when tk.estado = 'PD' then 1 else 0 end) pendiente')
      ->addSelect('SUM(case when tk.estado = 'P' then 1 else 0 end) progreso')
      ->addSelect('SUM(case when tk.estado = 'F' then 1 else 0 end) finalizada')
      ->leftJoin('tk.timeslices','tm','with','tk = tm.task')
      ->andWhere('date(tk.fechacomienzo) BETWEEN :from AND :to OR date(tm.startAt)
         BETWEEN :from AND :to')->setParameter('from', $from_date_new)-
         >setParameter('to',$to_date_new);

$queryTask->getQuery()->getArrayResult()

->andWhere('date(tk.fechacomienzo) BETWEEN :from AND :to OR date(tm.startAt)
             BETWEEN :from AND :to')->setParameter('from', $from_date_new)-
             >setParameter('to',$to_date_new)