I am working on perf system and wanted make sure that I am going in right direction. I will breifly explain what I am doing or will implement.
Firstly, projects and users are fetched from asana API and store them in database, if they are not currently present. Then, for each project, tasks are fetched.New tasks are directly inserted in database and which are already in db are updated if changed.
For calculating the scores, the list of the tasks completed in last week are fetched from database and and the score is updated for member who is assigned for the task according to the task tag color. If a task belongs the project “Learning and Improvements” the score will be 25% for that task. If a particular member has no completed tasks in last week, score for that member is zero.
Is it the good way to do it?