Function Index

Nth

Repeat the nth value of the the given column for every row in a column.

Usage

Nth(<field>,<n>)

field (required) Column to pick from.

n (required) Offset from top of column. Must be an integer greater than 0.

Examples

Nth([Quarter], 2)

  • If Quarter has”Q1″,”Q2″,”Q3″and”Q4″, the result would be”Q2″,”Q2″,”Q2″and”Q2″.