Hello @Ori J, You can try this code,

In report py file

# -- coding: utf-8 --

from odoo import models, fields, api

from functools import lru_cache

class ReportAppointmentOrder(models.Model):

    _name = "report.appointment.order"

    _description = "Appointment Analysis"

    _auto = False

    time= fields.Float('Time', readonly=True)

    @property

    def _table_query(self):

        return '%s %s' % (self._select(), self._from())

    @api.model

    def _select(self):

        return '''

            SELECT

              order.id,

            order.time

           '''

    @api.model

    def _from(self):

        return '''

        FROM appointment_order order

        '''

In Report xml file,

    report.appointment.order.pivot

    report.appointment.order

   Somehow, I am not able to add the complete code. Have a look at the screenshot:

https://prnt.sc/0C3AqTyCnYnd