CUSTOM pages/custom/new-analysis-page.md

Ready

Publish Page ⌘S

1

--- title: 새로운 분석 페이지 category: custom --- # 새로운 분석 페이지 > 일자별 매출 및 결제 사용자 추이를 분석하는 리포트입니다. ```sql daily_summary SELECT date_kst, new_devices, msg_devices, payers, revenue_krw AS gross_revenue_krw, cost_krw, profit_krw, ROUND(((profit_krw::numeric / NULLIF(cost_krw, 0)) * 100), 1) AS roi_pct FROM mart.mart_daily ORDER BY date_kst DESC LIMIT 14; ``` <Grid cols=4> <BigValue data={daily_summary} value=gross_revenue_krw title="총매출" /> <BigValue data={daily_summary} value=cost_krw title="총비용" /> <BigValue data={daily_summary} value=profit_krw title="순이익" /> <BigValue data={daily_summary} value=roi_pct title="ROI %" /> </Grid> <CustomTable data={daily_summary} />