Thingsboard Rule Creation & Dashboard Design

Hi, I want you to do some average and percentage calculations to represent this on the chart on the dashboard, I put more details in the attached file, Thanks!