Spaces:
Running
Running
Download global.R from phantomas34/perfect-margin: direct link, hf CLI and curl.
- Browser
- Download file 2.71 kB
-
https://huggingface.co/spaces/phantomas34/perfect-margin/resolve/main/global.R
- Command line
-
hf download hf://spaces/phantomas34/perfect-margin/global.R
-
curl -L -o global.R https://huggingface.co/spaces/phantomas34/perfect-margin/resolve/main/global.R
2.71 kB
| # --- global.R --- | |
| library(shiny) | |
| library(shinydashboard) | |
| library(tidyverse) | |
| library(lubridate) | |
| library(plotly) | |
| library(DBI) | |
| library(duckdb) | |
| library(scales) | |
| library(DT) | |
| library(shinyWidgets) | |
| library(cluster) | |
| library(openxlsx) # Tier 1 Excel report | |
| library(strucchange) # ITS breakpoint detection | |
| library(lmtest) # ITS coefficient testing | |
| library(pool) # Connection pooling | |
| # --- LOAD MODULES --- | |
| source("mod_cohort_analysis.R") # <--- THIS IS THE MISSING LINE! | |
| # 1. ESTABLISH DATABASE CONNECTION POOL | |
| db_pool <- dbPool(drv = duckdb::duckdb(), dbdir = ":memory:") | |
| onStop(function() { | |
| poolClose(db_pool) | |
| }) | |
| source("seed_data.R") | |
| # 2. GLOBAL SPC LIMITS FUNCTION (Restored to prevent app crash) | |
| spc_limits <- function(df, metric_col, is_quarterly, by_person = FALSE, bl_start, bl_end) { | |
| grp_date <- function(d) if (is_quarterly) floor_date(d, "quarter") else floor_date(d, "month") | |
| if (by_person) { | |
| baseline_stats <- df %>% | |
| filter(report_date >= bl_start, report_date <= bl_end) %>% | |
| mutate(date_group = grp_date(report_date)) %>% | |
| group_by(primary_name, date_group) %>% | |
| summarise(Val = sum(.data[[metric_col]], na.rm = TRUE), .groups = "drop") %>% | |
| group_by(primary_name) %>% | |
| summarise(BL_Mean = mean(Val, na.rm = TRUE), | |
| BL_SD = replace_na(sd(Val, na.rm = TRUE), 0), | |
| .groups = "drop") | |
| trend <- df %>% | |
| mutate(date_group = grp_date(report_date)) %>% | |
| group_by(primary_name, date_group) %>% | |
| summarise(Val = sum(.data[[metric_col]], na.rm = TRUE), .groups = "drop") | |
| trend %>% | |
| left_join(baseline_stats, by = "primary_name") %>% | |
| mutate(UCL = BL_Mean + 3 * BL_SD, | |
| LCL = pmax(0, BL_Mean - 3 * BL_SD), | |
| Anomaly = ifelse(Val > UCL | Val < LCL, "Anomaly", "Normal")) | |
| } else { | |
| baseline_stats <- df %>% | |
| filter(report_date >= bl_start, report_date <= bl_end) %>% | |
| mutate(date_group = grp_date(report_date)) %>% | |
| group_by(date_group) %>% | |
| summarise(Val = sum(.data[[metric_col]], na.rm = TRUE), .groups = "drop") %>% | |
| summarise(BL_Mean = mean(Val, na.rm = TRUE), | |
| BL_SD = replace_na(sd(Val, na.rm = TRUE), 0)) | |
| bl_mean <- baseline_stats$BL_Mean | |
| bl_sd <- baseline_stats$BL_SD | |
| df %>% | |
| mutate(date_group = grp_date(report_date)) %>% | |
| group_by(date_group) %>% | |
| summarise(Val = sum(.data[[metric_col]], na.rm = TRUE), .groups = "drop") %>% | |
| mutate(BL_Mean = bl_mean, | |
| UCL = bl_mean + 3 * bl_sd, | |
| LCL = pmax(0, bl_mean - 3 * bl_sd), | |
| Anomaly = ifelse(Val > UCL | Val < LCL, "Anomaly", "Normal")) | |
| } | |
| } |