这是对应的日？出勤是是什么标识？

在数据集用case when判断就好

里面值代表什么都不知道 怎么回答

你这个是原数据还是你转换过后的数据？正常来说如果想要统计【天数/人】数据，最好使用横向数据表

userid          月/天       出勤状态

user001      2025-02-01         0010u

user001      2025-02-02         0010y

user001      2025-02-03         

user002      2025-02-01         0010y

user002      2025-02-02         0010u

user002      2025-02-03    

上面这个表格的格式直接使用sum函数就可以计算了     

SQL SERVER参考：

WITH

A AS(

SELECT '2025-01' AS COL1,'X' AS D1,'A0001' AS D2,'X' AS D3

UNION ALL

SELECT '2025-01' AS COL1,'B0001' AS D1,'A0001' AS D2,'X' AS D3

UNION ALL

SELECT '2025-01' AS COL1,'A0001' AS D1,'B0001' AS D2,'C0001' AS D3

),

AttendanceData AS (

    SELECT 

        col1 AS month,

        day_column,

        employee_id

    FROM A

    UNPIVOT (

        employee_id FOR day_column IN (d1, d2, d3)

    ) AS unpvt

    WHERE employee_id IS NOT NULL

)

SELECT 

    month,

    employee_id,

    COUNT(*) AS attendance_days

FROM AttendanceData

GROUP BY month, employee_id

ORDER BY month, employee_id;