Examples
Examples
Try the starting example
- JSON Candidates [ID,stage,days since entry,supplied stale threshold days]
- [["A","screen",4,7],["B","panel",12,10]]
- Aging rows and threshold status
- [["A","screen",4,false],["B","panel",12,true]]
- Stale candidate count
- 1
- Maximum stage age (days)
- 12
Try another scenario
- JSON Candidates [ID,stage,days since entry,supplied stale threshold days]
- [["A","screen",9,7],["B","panel",8,10]]
- Aging rows and threshold status
- [["A","screen",9,true],["B","panel",8,false]]
- Stale candidate count
- 1
- Maximum stage age (days)
- 9
Calculation method
Calculation method
Aging rows and threshold status
J([[r[0],r[1],r[2],r[2]>r[3]] for r in a])
Stale candidate count
sum(r[2]>r[3] for r in a)
Maximum stage age (days)
max(r[2] for r in a)
Symbols and units
- a
- JSON Candidates [ID,stage,days since entry,supplied stale threshold days]
Use the units shown. A list keeps the order in which you enter its values. The symbol ^ means “raised to the power of”.
Calculation steps and notation
sum(list) adds all entries in the list.
Assumptions & limits
Assumptions & limits
- Dates converted to elapsed whole days at selected report date; stale means strictly older than user threshold. Supported limits: All numeric inputs must be finite. Only the explicitly described mathematical scenario is supported.
Are these inputs private?
These calculations run in your browser. A shared link contains the values you choose to share. Only questions submitted to the separate AI finder are sent to OpenAI.