Average Days Open (Open Reqs)
Requisition · Time
AVERAGE(Requisition[daysOpen])Direct dependencies: None
people analytics dashboard
Recruiting funnel, time-to-fill, source, quality, cost, and requisition views.
7 pages · Power BI
These dashboards use synthetic workforce data. Values illustrate the report design.
Selected page
Exact source expressions and direct measure dependencies for the selected page.
Requisition · Time
AVERAGE(Requisition[daysOpen])Direct dependencies: None
Requisition · Pipeline
CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Open"))Direct dependencies: None
Requisition · Time
CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Open"), FILTER(Requisition, Requisition[daysOpen] > LOOKUPVALUE(Parameters[value], Parameters[name], "OpenSlaDays")))Direct dependencies: None