Same on "Sale module" in dashboard, but in my module has Rubric model its has from_date and to_date filed.

 I hope when I choose Rubric in the filter, my chart will compare with all record in last rubric.

classRubric(models.Model):

_name="employee.assessment.rubric"

_description="Assessment Rubric"
name=fields.Char()

description=fields.Text()type=fields.Selection

([("week", "Week")("month", "Month"),("quarter", "Quarter"),("year", "Year"),],"Type",default="month",required=True,)

rubric_line=fields.One2many("assessment.rubric.lines", "rubric_name", string="Rubric Line"    )
from_date=fields.Date("From"

)to_date=fields.Date("To")

criteria=fields.Many2many("employee.assessment.criterion",required=True)active=fields.Boolean(default=True)

In each asessment rubric, I have a lot of assessment sheet.

classAssessmentSheet(models.Model):

_name="employee.assessment.sheet"

_description="Employee Assessment Sheet"_inherit= ["mail.thread", "mail.activity.mixin"]

_order="create_date desc, revenue_line desc"name=fields.Char(related="rubric.name", store=True)
rubric=fields.Many2one("employee.assessment.rubric", ondelete="restrict", tracking=True )

rubric_type=fields.Selection(related="rubric.type")

from_date_rubric=fields.Date(related="rubric.from_date",store=True)

to_date_rubric=fields.Date(related="rubric.to_date")

assessment_date=fields.Date("Date", required=True, default=lambdaself:fields.Date.today() )

assessed_by=fields.Many2one("hr.employee","Assessed by",default=lambdaself: self.env["hr.employee"].search( [["user_id", "=", self.env.user.id]]),ondelete="restrict",)

assessed_for=fields.Many2one("hr.employee", "Assessed for",ondelete="restrict")

note=fields.Char()
rubric_sheet_line=fields.One2many("assessment.sheet.line", "sheet", string="Rubric Sheet Line", ondelete="cascade" )

revenue_line=fields.Float(compute="_compute_revenue_line", store=True)

profit_line=fields.Float(compute="_compute_profit_line"store=True)

ratio=fields.Float(related="rubric_sheet_line.ratio")state=fields.Selection(        [            ("draft", "To Submit"), ("confirm", "To Approve"),  ("refuse", "Refused"),            ("approved", "Approved"), ("done", "Done"),        ],string="Status",compute="_compute_state",store=True,group_expand="_expand_groups",tracking=True,copy=False,readonly=False,help="The status is set to 'To Submit', when a Assessment is created."+"\nThe status is 'To Approve', when Assessment is confirmed by user."+"\nThe status is 'Refused', when Assessment is refused by manager."+"\nThe status is 'Done', when Assessment is Done by manager.",    )

state_string=fields.Char(compute="_compute_state_string", store=False)

count_customer=fields.Integer(compute="_compute_count_customer", store=True)

percentage_status_sheet=fields.Boolean(compute="_compute_check_value")

per_status_sheet=fields.Selection(        [            ("passed", "Passed"),            ("failed", "Failed"),        ],compute="_compute_check_boolean",store=True,    )
employee_id=fields.Many2one("hr.employee",string="Employee",store=True,index=True,readonly=False,ondelete="restrict",tracking=True,compute_sudo=False,    )department_id=fields.Many2one("hr.department",store=True,compute="_compute_department_id",string="Department",readonly=False,    )

can_submit=fields.Boolean("Can submit", compute="_compute_can_submit")can_confirm=fields.Boolean("Can Confirm", compute="_compute_can_confirm")can_done=fields.Boolean("Can Done", compute="_compute_can_done")active=fields.Boolean("Active", default="True")compute_field=fields.Boolean(compute="get_user")have_permission=fields.Boolean(compute="_compute_have_permission")
message=fields.Many2one("mail.message")notification_ids=fields.One2many(related="message.notification_ids")