% Open Over SLA
Requisition · Time
DIVIDE([Open Over SLA], [Open])Direct dependencies: Open Over SLA, Open
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
DIVIDE([Open Over SLA], [Open])Direct dependencies: Open Over SLA, Open
Requisition · Time
AVERAGE(Requisition[daysOpen])Direct dependencies: None
Requisition · Time
AVERAGE(Requisition[daysToFill])Direct dependencies: None
Requisition · Pipeline
CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Filled"))Direct dependencies: None
Requisition · Time
MEDIAN(Requisition[daysToFill])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