How to make the Big Numbers component display the value from the second row?

[Isael_Rocha_Cunha]

How to make the Big Numbers component display the value from the second row? I have a table and I only want the Big Numbers component to display the value from the second row. Additionally, new rows will be added to the table, such as the third, fourth, and so on. In other words, new rows will be added to my table, and I want the Big Numbers to always display the latest value (in “value”), and the second-to-last value (in “description”). How can I do this?

[Jeff_Hager]

You could create single value columns that retrieve the last or second to last row value.

[Isael_Rocha_Cunha]

Sorry, the image above is from an old configuration and doesn’t apply. The correct image is this one:

[Isael_Rocha_Cunha]

@Jeff_Hager

You could create single value columns that retrieve the last or second to last row value.

How do I perform this procedure?

[MattLB]

Use the Single Value column type and select Row 1 (starts at 0)

And get the whole row. Should look like this:

[Jeff_Hager]

Like @MattLB shows, you can get from the start or from the end. The number tells it how many rows from the start or end.