deadline reporting chart

Looking at ways to reduce or eliminate automations for this task.
currently have an automation that will change a column based on status and date, that will reflect “pending” if waiting on completion, or “on-time”, "overdue if the job is complete or past the due date. these automations were made because i wasn’t able to find a way to make the monday.com charts work off of deadline data.

chart will look at the “overdue vs on-time” status, is there a better way to go about reporting this data? or collecting the data that the chart will utilize?