How Metrics Are Derived

Overview

Every number on the dashboard and finance pages comes from a defined query. This guide is the source of truth when you ask where did this come from?

Attendance

Hours today

Check-out minus check-in for today's row, capped at the 9h shift. Open sessions use live elapsed time (also capped). Source: attendance table · session_duration_hours()

Attendance this week

Sum of billable hours Mon-Sun from attendance rows (closed sessions + today's open session). Stale open days excluded until checkout. Source: attendance · last 7 calendar days

Days in

Count of days this week with a check-in timestamp (not hours threshold). Source: attendance.check_in_time

Day streak

Consecutive calendar days with a check-in, walking backward from today. Source: attendance rows

Shift %

Today's billable hours divided by 9h shift target, capped at 100%. Source: attendance · SHIFT_HOURS=9

Month hours

Sum of billable hours for closed sessions plus today's open session in the calendar month. Does not count stale open past days. Source: attendance · month filter

Finance / P&L

Labor cost (P&L)

Approved timesheet hours × effective hourly rate per user/role. Feeds project P&L labor line. Source: project_finance · approved timesheet entries

Budget vs actual

Project budget baseline (approved bid or manual budget) compared to logged spend: labor + PO committed + render + misc. Source: projects.budget_amount + finance rollups

Render farm

Active farm jobs

Render jobs with status queued or rendering right now. Source: render_jobs.status

Render cost

Sum of chunk render seconds × rate card, rolled to PEID on job completion. Oversight roles only. Source: render_jobs + render_cost rollups

Dependencies & lineage

Where-used

Reverse dependency graph: shots/tasks/assets that reference this asset or publish. Source: asset_dependencies + task dependency edges

PEID lineage

Publish lineage chain: parent PEIDs, version bumps, and downstream consumers for one published element. Source: element_lineage + peid registry

Gotchas

• Attendance hours ignore stale open sessions on past dates until checkout or admin close.
• Timesheet hours and attendance hours are separate sources - compare them on the dashboard week card.
• Render cost requires job completion before it rolls to PEID totals.

Steps

1. Read the overview and try the linked app pages.
2. Follow steps in order - skip only if your role does not use that area.
3. Use See also / prev-next in the sidebar for related guides.

Cross-links

• Getting Started - see Help Center
• Finance Overview Guide - see Help Center
• Render Farm Overview - see Help Center