Bicycle.LLCSchedule a call

← Dashboard collection

Choose dashboard — Talent Acquisition Funnel

people analytics dashboard

Talent Acquisition Funnel

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.

Choose page — 2 Time to fill

Selected page

2 Time to fill

DAX definitions

Exact source expressions and direct measure dependencies for the selected page.

% Open Over SLA

Requisition · Time

DIVIDE([Open Over SLA], [Open])

Direct dependencies: Open Over SLA, Open

Average Days Open (Open Reqs)

Requisition · Time

AVERAGE(Requisition[daysOpen])

Direct dependencies: None

Average Time to Fill (Days)

Requisition · Time

AVERAGE(Requisition[daysToFill])

Direct dependencies: None

Filled

Requisition · Pipeline

CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Filled"))

Direct dependencies: None

Median Time to Fill (Days)

Requisition · Time

MEDIAN(Requisition[daysToFill])

Direct dependencies: None

Open

Requisition · Pipeline

CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Open"))

Direct dependencies: None

Open Over SLA

Requisition · Time

CALCULATE(COUNTROWS(Requisition), KEEPFILTERS(Requisition[status] = "Open"), FILTER(Requisition, Requisition[daysOpen] > LOOKUPVALUE(Parameters[value], Parameters[name], "OpenSlaDays")))

Direct dependencies: None