이어온

[확인 결과]

1.통계 > 접속률 TAB 

  1) st_user_log 데이터로 표시

[SQL]

SELECT *
FROM (SELECT G2.log_time,
             G2.access_today,
             G2.daily_average,
             CAST(@running_total:=@running_total + G2.access_today AS INTEGER) AS cumulative_sum
      FROM (SELECT G1.*,
                   COUNT(G1.log_time) AS access_today,
                   TRUNCATE(CAST(G1.total AS NUMERIC) / CAST(COUNT(1) OVER (PARTITION BY null) AS NUMERIC),
                            0)        AS daily_average
            FROM (SELECT A.*, count(1) OVER (PARTITION BY null) AS total
                  FROM st_user_log A
                  WHERE A.log_time BETWEEN '2025-04-28 00:00:00.0' AND '2025-05-28 23:59:59.0') G1
            GROUP BY DATE_FORMAT(G1.log_time, '%Y%m%d')) G2
               JOIN (SELECT @running_total:=0) r)
ORDER BY log_time DESC

  2) st_user_log 생성 시점

• 사용자 화면 (/meta/) 에서 비회원 로그인 으로 접속한 경우
• 사용자 화면 에서 로그인 화면으로 로그인한 경우