JIRA Issue Aggregator by Week

Jira_Issue_Aggregator.cls

public class Jira_Issue_Aggregator {

    public static void aggregate(){
        List<Jira_Issue_Week_Aggregation__c> aggrs = [SELECT Id FROM Jira_Issue_Week_Aggregation__c];
        if(aggrs.size() > 0){
            delete aggrs;
        }
        
        Map<string, Jira_Issue_Week_Aggregation__c> aggrMap = new Map<string, Jira_Issue_Week_Aggregation__c>();
        Set<Date> dates = new Set<Date>();
        Set<String> resolutions = new Set<string>();
        for(Jira_Issue__c j : [SELECT ID, Created_Date_Date_Value__c, Date_Completed__c, Story_Points__c, Resolution__c, Status__c 
                               FROM Jira_Issue__c 
                               WHERE Story_Points__c > 0 
                               AND Issue_Type__c = 'Story'
                               AND Resolution__c in ('Done','Unresolved')
                               ORDER BY Created_Date_Date_Value__c ASC]){
            //dates.add(j.Created_Date_Date_Value__c.toStartOfWeek());
            //resolutions.add(j.Resolution__c);
            boolean CreatedAndClosedSameWeek = j.Date_Completed__c != null && j.Date_Completed__c.toStartOfWeek() == j.Created_Date_Date_Value__c.toStartOfWeek();
            String CreatedStartWk = j.Created_Date_Date_Value__c.toStartOfWeek().format() + '['+j.Resolution__c +':'+j.Status__c+']';
            String ClosedStartWk = j.Date_Completed__c != null ? j.Date_Completed__c.toStartOfWeek().format() + '['+j.Resolution__c +':'+j.Status__c+']' : 'N/A';
            boolean validClose = j.Status__c == 'Done' || j.Status__c == 'Deployed' || j.Status__c == 'Deployment Deferred';
            if(aggrMap.containsKey(CreatedStartWk)){
                Jira_Issue_Week_Aggregation__c aggrc = aggrMap.get(CreatedStartWk);
                System.debug('Contains Key:' + CreatedStartWk);
                System.debug(aggrc);
                aggrc.Points_Added__c = aggrc.Points_Added__c + j.Story_Points__c;
                if(CreatedAndClosedSameWeek && validClose){
                    //aggrc.Points_Closed__c += j.Story_Points__c;
                }
            }else{            
                Jira_Issue_Week_Aggregation__c aggrn = new Jira_Issue_Week_Aggregation__c();
                aggrn.Week_Date__c = j.Created_Date_Date_Value__c.toStartOfWeek();
                //aggrn.Week_Group__c = CreatedStartWk;
                aggrn.Points_Added__c = j.Story_Points__c;
                if(CreatedAndClosedSameWeek && validClose){
                    aggrn.Points_Closed__c = j.Story_Points__c;
                }else{
                	aggrn.Points_Closed__c = 0;
                }
                aggrn.Resolution__c = j.Resolution__c;
                aggrn.Status__c = j.Status__c;
                aggrMap.put(CreatedStartWk, aggrn);
            }
            /* */
            if(j.Date_Completed__c != null && validClose){
                if(aggrMap.containsKey(ClosedStartWk)){
                    Jira_Issue_Week_Aggregation__c aggrd = aggrMap.get(ClosedStartWk);
                    aggrd.Points_Closed__c = aggrd.Points_Closed__c + j.Story_Points__c;
                }else{
                    Jira_Issue_Week_Aggregation__c aggrn = new Jira_Issue_Week_Aggregation__c();
                    aggrn.Week_Date__c = j.Date_Completed__c.toStartOfWeek();
                    //aggrn.Week_Group__c = ClosedStartWk;
                    aggrn.Points_Added__c = CreatedAndClosedSameWeek ? j.Story_Points__c : 0;
                    aggrn.Points_Closed__c = j.Story_Points__c;
                    aggrn.Resolution__c = j.Resolution__c;
                	aggrn.Status__c = j.Status__c;
                    aggrMap.put(ClosedStartWk, aggrn);
                }
            }
			/* */
        }
        insert aggrMap.values();
    }
}

Jira_Issue_Week_Aggregation__c-Fields.csv