SeriesIndex
Pulls a single value out of a column by position: the first, the third, or, most usefully, the last. Negative positions count from the end, so -1 always means "the most recent value" no matter how many rows the column has. The result is a single number you can feed to a KPI card or further calculations.
Inputs
| Input | Accepts | Required |
|---|---|---|
Series | Series (a list of numbers) | Yes |
Index | Value (a single number) | Yes |
Outputs
| Output | Produces |
|---|---|
Result | Value (a single number) |
Settings
Typed in on the node or set by the assistant, not wired.
| Setting | Default | Notes |
|---|---|---|
Index | 0 | Position to pick, counting from 0 (so 0 is the first value and 2 is the third). Negative numbers count from the end: -1 is the last value, -2 the second-to-last. Default 0. |
Example
You have wired monthly cash flows through Accumulate to get a cumulative cash position. Add SeriesIndex with Index -1 to pull the latest balance (say $1,284,000 after 18 months) and wire it into a KPI card labeled Cash Position. When next month's row arrives, the card updates itself; -1 still points at the newest value.
Tips
Positions start at 0, not 1. Use two SeriesIndex nodes (-1 and -2) into a KPI card's value and comparison inputs to show the latest figure with its change versus the prior period. Aggregate's First and Last cover the two most common positions if that reads clearer.