SOURCE

console 命令行工具 X clear 
> [{"date01":"01","date01-num":605,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":305,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"总投诉率","complaintCateNameId":"总投诉率","name":"反馈台数"},{"date01":"01","date01-num":3057,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":5011,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"总投诉率","complaintCateNameId":"总投诉率","name":"当月直签在途数"},{"date01":"01","date01-num":10490,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":20490,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"总投诉率","complaintCateNameId":"总投诉率","name":"买断18个月在途"},{"date01":"01","date01-num":"10490.06","date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":"20490.06","date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"总投诉率","complaintCateNameId":"总投诉率","name":"总投诉率"},{"date01":"01","date01-num":"","date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":"","date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"总投诉率","complaintCateNameId":"总投诉率","name":"总投诉率指标"},{"date01":"01","date01-num":605,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":305,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"安装阶段","complaintCateNameId":"安装阶段","name":"反馈台数"},{"date01":"01","date01-num":3057,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":5011,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"安装阶段","complaintCateNameId":"安装阶段","name":"当月直签在途数"},{"date01":"01","date01-num":10490,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":20490,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"安装阶段","complaintCateNameId":"安装阶段","name":"买断18个月在途"},{"date01":"01","date01-num":155,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":55,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"安装阶段","complaintCateNameId":"安装阶段","name":"安装台数"},{"date01":"01","date01-num":"12490.01","date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":"20490.01","date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"安装阶段","complaintCateNameId":"安装阶段","name":"安装投诉率"},{"date01":"01","date01-num":605,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":305,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"维保阶段","complaintCateNameId":"维保阶段","name":"反馈台数"},{"date01":"01","date01-num":3057,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":5011,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"维保阶段","complaintCateNameId":"维保阶段","name":"当月直签在途数"},{"date01":"01","date01-num":10490,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":20490,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"维保阶段","complaintCateNameId":"维保阶段","name":"买断18个月在途"},{"date01":"01","date01-num":7,"date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":7,"date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"维保阶段","complaintCateNameId":"维保阶段","name":"维保台数"},{"date01":"01","date01-num":"30490.00","date02":"02","date02-num":0,"date03":"03","date03-num":0,"date04":"04","date04-num":"20490.00","date05":"05","date05-num":0,"date06":"06","date06-num":0,"date07":"07","date07-num":0,"date08":"08","date08-num":0,"date09":"09","date09-num":0,"date10":10,"date10-num":0,"date11":11,"date11-num":0,"date12":12,"date12-num":0,"complaintCateName":"维保阶段","complaintCateNameId":"维保阶段","name":"维保投诉率"}]
>
console
function generateMonthlyData(data, conditions) {
    // 初始化1-12个月的数据模板
    const months = _.range(1, 13).map(month => ({
        key: `date${month < 10 ? '0' + month : month}`,
        date: month < 10 ? '0' + month : month,
        numKey: `date${month < 10 ? '0' + month : month }-num`
    }));

    // 按月份分组数据
    const dataByMonth = _.groupBy(data, item => item.recordDate.substring(0, 7));

    // 处理每个条件
    return _.flatMap(conditions, condition => {
        const [categoryName, fields] = _.toPairs(condition)[0];

        // 处理每个字段
        return _.map(fields, field => {
            const fieldMappings = {
                'totalNum': '反馈台数',
                'totalInstallShipping': '当月直签在途数',
                'totalBuyoutShipping': '买断18个月在途',
                'complaintRate': '总投诉率',
                'complaintRateTarget': '总投诉率指标',
                'installNum': '安装台数',
                'installComplaintRate': '安装投诉率',
                'maintenanceNum': '维保台数',
                'maintenanceComplaintRate': '维保投诉率'
            };

            const name = fieldMappings[field] || field;

            // 初始化每个月份的默认值
            const monthlyData = {};
            months.forEach(({ key, date, numKey }) => {
                monthlyData[key] = date;
                monthlyData[numKey] = 0; // 默认0，后续填充真实数据
            });
            // 填充实际数据
            _.forEach(dataByMonth, (items, month) => {
                const monthValue = dayjs(month).format('MM');
                const monthKey = `date${monthValue}`;
                const numKey = `${monthKey}-num`;
                const value = _.get(items[0], field, 0);
                monthlyData[numKey] = value !== undefined ? value : 0;
            });

            // 计算平均值（不忽略0，直接累加12个月后除以12）
            const values = months.map(({ numKey }) => {
                const val = monthlyData[numKey];
                return val !== "" ? parseFloat(val) || 0 : 0; // 空值视为0
            });

            const avg = _.round(_.sum(values) / 12, 2); // 直接计算12个月的平均值

            return {
                ...monthlyData,
                complaintCateName: categoryName,
                complaintCateNameId: categoryName,
                name
            };
        });
    });
}

// 使用示例
const data = [
    {"id":"1921745702099095553","createduserid":"","createddate":"2025-05-12 09:54:14.000","updateduserid":"","updateddate":"","tenantId":"","totalNum":605,"totalInstallShipping":3057,"totalBuyoutShipping":10490,"complaintRate":"10490.06","complaintRateTarget":"","installNum":155,"installComplaintRate":"12490.01","maintenanceNum":7,"maintenanceComplaintRate":"30490.00","recordDate":"2025-01-12"},
    {"id":"1921745702099095553","createduserid":"","createddate":"2025-05-12 09:54:14.000","updateduserid":"","updateddate":"","tenantId":"","totalNum":305,"totalInstallShipping":5011,"totalBuyoutShipping":20490,"complaintRate":"20490.06","complaintRateTarget":"","installNum":55,"installComplaintRate":"20490.01","maintenanceNum":7,"maintenanceComplaintRate":"20490.00","recordDate":"2025-04-12"}
];
const conditions = [
    { '总投诉率': ['totalNum', 'totalInstallShipping', 'totalBuyoutShipping', 'complaintRate', 'complaintRateTarget'] },
    { '安装阶段': ['totalNum', 'totalInstallShipping', 'totalBuyoutShipping', 'installNum', 'installComplaintRate'] },
    { '维保阶段': ['totalNum', 'totalInstallShipping', 'totalBuyoutShipping', 'maintenanceNum', 'maintenanceComplaintRate'] }
];

const result = generateMonthlyData(data, conditions);
console.log(result);
<script src="https://unpkg.com/lodash@4.17.21"></script>
<script src="https://unpkg.com/dayjs@1.11.13"></script>