Integrity automation

[Kartikeya_Sharma]

I am building a integrity score for an organization. Everything is on clickup, Building dashboards for Individual, Lead, Managers level to check al the tasks completed in a particular day. Now i want a Integrity score (a formula that calcuated % of tasks completed on time) for each individual, Team level and Organization level. Is this possible through n8n? if so can someone help me?

[krisn0x]

Hey, yes, sounds possible. Here is a general outline of the flow you will need:

1. Get task data
   -Use the ClickUp → Task → Get Many node.
   -Fetch fields: assignee, status, due_date, date_done (completed date).
   -Apply filters (e.g. only tasks updated today).

2. Calculate integrity score per task
   Add a Code node:

   return items.map(item => {
     const due = new Date(item.json.due_date);
     const done = new Date(item.json.date_done);
     const onTime = done <= due ? 1 : 0;
     return {
       json: {
         assignee: item.json.assignee?.id,
         team: item.json.assignee?.team_id,
         onTime,
       }
     };
   });
   
   

3. Aggregate scores:
   Use Aggregate (built-in node) or another Code node to group by:
   -Individual (assignee ID)
   -Team
   -Entire org

4. Build dashboard data
   Push results into Google Sheets, ClickUp custom fields, or a DB (Postgres/MySQL).

General Flow:

• ClickUp Get Many Tasks
• Function (mark onTime)
• Aggregate (by assignee) → produce % completed_on_time
• Aggregate (by team)
• Aggregate (all tasks)
• Push to dashboard DB/Sheet

Let me know if this helps. You can also open threads when you start building it and you face any technical difficulties

[krisn0x]

@Kartikeya_Sharma Oh, and if you feel my answer is enough for now, please mark my previous reply as Solution. Follow up questions are welcome of course.